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
I don't think Infomaker can handle multiple datasets. Usually I ended up having a couple sub reports, or constructed the dataset differently.