creating renewal forms without Infomaker

We do not have infomaker installed on our server, and I am just a Box Office manager. We do not have an IT staff person. I need to pull data for renewal forms from the rollovers I created. Does anyone know of a way to get all of the necessary data out in one report? Last year I pulled the order info and the constituent info separately, then did a merge in Excel. That process is very involved and it seems there should be an easier way. Any suggestions would be greatly appreciated.

Thank you.

-dennis

 

Parents
  • You don’t need InfoMaker to run this report.  You should be able to use the sample forms just fine.  You only need InfoMaker to customize the forms.

     

    Try changing the D_Object to d_renewal_notice_sample2, run the report again, and then see what happens.  If you still get nothing, the problem might actually be your data.  Have you checked your rollover orders to make sure that they rolled over successfully?  If so, try creating a list with just one person on it that you know has a successful rollover and then select that list when you run the report.  Also review your report parameters to make sure that everything is correctly set to find the orders you want.  If none of that works, you should open a help ticket so the support staff can help you resolve the problem.

     

    Good luck,

     

    Kevin Sheehan

    Senior Documentation & Learning Resources Specialist

    Tessitura Network

    +1 888 643 5778 x 329

    ksheehan@tessituranetwork.com

     

Reply
  • You don’t need InfoMaker to run this report.  You should be able to use the sample forms just fine.  You only need InfoMaker to customize the forms.

     

    Try changing the D_Object to d_renewal_notice_sample2, run the report again, and then see what happens.  If you still get nothing, the problem might actually be your data.  Have you checked your rollover orders to make sure that they rolled over successfully?  If so, try creating a list with just one person on it that you know has a successful rollover and then select that list when you run the report.  Also review your report parameters to make sure that everything is correctly set to find the orders you want.  If none of that works, you should open a help ticket so the support staff can help you resolve the problem.

     

    Good luck,

     

    Kevin Sheehan

    Senior Documentation & Learning Resources Specialist

    Tessitura Network

    +1 888 643 5778 x 329

    ksheehan@tessituranetwork.com

     

Children
  • I know this issue is years old but I'm at the point of throwing Tess out the window. Confirmations should be a standard and easy function but I have now had days of stress in running different reports without the needed results. Why isn't it clear what reports give you when you run them? 

    I'm trying to get a report  that I can export into a merge document to print my subscription confirmations. 

    So the data is: 
    Performance (Production Description or Production Name)
    Venue (facility)
    Series (Day)
    Date of the performance
    Time
    Seats (Section, row, seat)

    Torch Song Trilogy

    Mead Theatre

    9/29/2013 7:30pm

    AA 203-204

    That Hopey Changey Thing

    Milton Theatre

    Not yet purchased

     

    Sweet and Sad

    Milton Theatre

    12/8/2013 7:00pm

    A 203-204

    Tribes

    Mead Theatre

    2/2/2014 7:00pm

    AA 203-204

    Water by the Spoonful

    Metheny Theatre

    3/30/2014 7:00pm

    A 203-204

    ***

    Milton Theatre

    6/8/2014 7:00pm

    A 203-204

     

     

    So the data is: 
    Performance (Production Description or Production Name)
    Venue (facility)
    Series (Day)
    Date of the performance
    Time
    Seats (Section, row, seat)
    Is there a report that pulls this? I thought the order output would show this but it shows seats but not venue or time. 

     

  • Former Member
    Former Member $organization in reply to Adria Gunter

    Hi Adria

    A side point here - if you're trying to get Word Merge to produce a table-like output with a variable number of rows, as I think you are (your list of performances/seats/etc) - That's not something that the merge functionality in Word is really equipped to deal with. It's theoretically possible, using a bit of trickiness and vb coding, but after a few attempts, leading to tears before bedtime, I wouldn't try it again myself.

    I think you'd be much better off trying to do this sort of thing as a report in Infomaker or SSRS, and if you don't have the report-fiddling skills in-house, I'd be looking at your friendlyTess consultant/s for a bit of help.

    Ken