Hey everyone,
I’ve written a stored procedure that ends in two SELECT statements, but when I try to make a report out of it in InfoMaker, I only get the results of the first SELECT. Anybody know how to work around this? I might just monkey with the output of the second statement to UNION it with the first, but I thought I’d see if anyone had a better idea.
Thanks in advance!
Rey
--
A. Rey Pamatmat
Tessitura Manager
The Public Theater
425 Lafayette Street
New York, NY 10003
(212) 539-8739
RPamatmat@PublicTheater.org
Hi Rey, Info maker can’t handle multiple datasets as Jon mentioned. You can join them with a UNION statement if you can, as you have mentioned, or can create a composite report with two sub-reports. Another option is making a SSRS based report – I will vote for this one. This will be easier and you will get more flexibility.
Mo
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jon Ballinger Sent: Tuesday, November 02, 2010 12:18 PM To: Mohiuddin Faruqe Subject: Re: [Tessitura Technical Forum] Stored Procedure ending in two SELECT statements
I don't think Infomaker can handle multiple datasets. Usually I ended up having a couple sub reports, or constructed the dataset differently.
From: A. Rey Pamatmat <bounce-areypamatmat2177@tessituranetwork.com> Sent: 11/2/2010 11:02:36 AM
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!