Oh, InfoMaker – you done me wrong again.
I’m trying to make a new report, but when I select the stored procedure for Infomaker to use, I keep getting an error that says “Cannot create DataWindow. ‘Requested result set number 1 not found.’” Has anyone gotten this before? Does anyone know what to do about it?
It is a custom report, but it’s based on a canned one (The Daily Sales Report). I’ve run the procedure in SMSS successfully.
Thanks,
Rey
--
A. Rey Pamatmat
Tessitura Manager
The Public Theater
425 Lafayette Street
New York, NY 10003
(212) 539-8739
RPamatmat@PublicTheater.org
Infomaker tries to create the column specifications for the datawindow by running the procedure with all parameters set to a NULL value. If your procedure doesn’t return a result set with this run case, it won’t be able to generate the datawindow properly.
The workaround is to hardcode a few parameters in your procedure just to get sample results. Once the datawindow has been built, you can remove these values.
-Ryan
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of A. Rey PamatmatSent: Wednesday, October 27, 2010 3:08 PMTo: Ryan CrepsSubject: [Tessitura Technical Forum] InfoMaker Error
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!