Greetings all,
For a myriad of reasons, we have had to add a parameter to the "Print Acknowledgement Letter" report. The new parameter is program_no. I know that the ack letter report functions a bit differently than other reports because of the involvement of t_format_info.
The problem I'm having is that when you run the report you get an error message "Expecting 10 retrieval arguments but got 9". I know that the local stored procedure on the back end is working correctly. The data window also looks good to me including the Arguments portion in InfoMaker. And the report setup window looks good to me as well.
A SQL trace shows that 10 rows are being inserted into gooesoft_request_parameter when the report is run so I can't figure out where I'm losing one of the arguments.
Has anyone experienced something similar in the past? Any ideas on where I might look next for a solution?
Thanks!
Levi, this is not very clear in any documentation, so I understand some of the confusion. The Print Ack Letter report is a report that uses a special application window which handles the parameters and determining which datawindow to use based on the user selection from T_FORMAT_INFO. Unlike other reports that use the “standard” reports window (this is an “application” window that contains the datawindow), this report is hardcoded to only accept 9 parameters. The window also does a bit more processing in the background before passing the parameters to the datawindow. You can construct custom ack letters and reference them in T_FORMAT_INFO, but the parameters in custom datawindows (for ack letters) must match the expected set of parameters.
You could, however, make a copy of the Print Acknowledgment Letters report, and directly reference the ack letter datawindow you wish to build. In the report setup, you would change the window type to “Infomaker”, instead of “Custom”, and set the datawindow to the ack letter you have created (with the additional parameter) instead of referencing T_FORMAT_INFO.
Hope that makes sense.
-Ryan
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei Sent: Friday, July 16, 2010 7:57 AM To: Ryan Creps Subject: [Tessitura Technical Forum] Acknowledgement Letter Parameter
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!
Thank you for the info Ryan. That makes much more sense now.