Infomaker Question

Hi, Dot,

Standard reports use a system window called w_report_psr.  These windows (w_renewal_report and w_renewal_report_all) are specific to Subscription Renewal Notices in that they handle formats set in T_FORMAT_INFO, but run a specific procedure for generating (or reprinting) renewal notices.

If you start a custom format from the existing sample renewal notice formats, the window runs the standard procedure (TP_GEN_RENEWAL_NOTICES) for generating or reprinting renewal notices.  If you start with a brand new datawindow, can start with your own SQL Select or stored procedure.  These report windows know to look for this and use it…the caveat being that the standard procedure will not be run.  In this case, you have one of two options.  One, you can run TP_GET_RENEWAL_NOTICES yourself in a custom procedure (don’t alter the standard proc!).  Two, you can run the regular process to a standard format, then use the reprint for a custom format (with the additional data you may need).

Hope this helps

-Ryan Creps

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Dot Krebs
Sent: Thursday, February 16, 2017 1:50 PM
To: Ryan Creps <rcreps@tessituranetwork.com>
Subject: [Tessitura Technical Forum] Infomaker Question

Have a question for an InfoMaker mad scientist out there. Yeah, you know who you are.

I noticed that both of the canned Subscription Renewal Notices (all and reprint) open a different InfoMaker Window, but yet, can use the same InfoMaker report to produce the forms.

So, what's up with that?

What is the purpose of w_renewal_report_all and w_renewal_report in InfoMaker?

• Do they just tell the system which stored procedure to run?  
  • If that's the case, it makes total sense.  One report format, serving two masters.

I'm going to a road where I would need two report formats and I'd kind of like to get away from that if I could by using a Data Window.

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Hi, Dot,

Standard reports use a system window called w_report_psr.  These windows (w_renewal_report and w_renewal_report_all) are specific to Subscription Renewal Notices in that they handle formats set in T_FORMAT_INFO, but run a specific procedure for generating (or reprinting) renewal notices.

If you start a custom format from the existing sample renewal notice formats, the window runs the standard procedure (TP_GEN_RENEWAL_NOTICES) for generating or reprinting renewal notices.  If you start with a brand new datawindow, can start with your own SQL Select or stored procedure.  These report windows know to look for this and use it…the caveat being that the standard procedure will not be run.  In this case, you have one of two options.  One, you can run TP_GET_RENEWAL_NOTICES yourself in a custom procedure (don’t alter the standard proc!).  Two, you can run the regular process to a standard format, then use the reprint for a custom format (with the additional data you may need).

Hope this helps

-Ryan Creps

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Dot Krebs
Sent: Thursday, February 16, 2017 1:50 PM
To: Ryan Creps <rcreps@tessituranetwork.com>
Subject: [Tessitura Technical Forum] Infomaker Question

Have a question for an InfoMaker mad scientist out there. Yeah, you know who you are.

I noticed that both of the canned Subscription Renewal Notices (all and reprint) open a different InfoMaker Window, but yet, can use the same InfoMaker report to produce the forms.

So, what's up with that?

What is the purpose of w_renewal_report_all and w_renewal_report in InfoMaker?

• Do they just tell the system which stored procedure to run?  
  • If that's the case, it makes total sense.  One report format, serving two masters.

I'm going to a road where I would need two report formats and I'd kind of like to get away from that if I could by using a Data Window.

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!