Can infomaker handle multiple result sets being returned from a stored procedure in SQL server?
I (and technically-inclined end-user and not a programmer) have a report I am trying to build and I am only getting the first result set back. Its a group report where the top level has the summary and the detail has all the detail transactions.
Is there a setting in infomaker I am missing to grab both result sets?
Hi Paul;
IN IM, you can only choose one result set (IM defaults to RS #1). You can see that in the "Report Painter" when you view the SP mapping. For example:
Report Painter ...
SP Dialogue ...
Now choose the RS number you want.
Note that IM will only allow one RS to be chosen. However, you might be able to synthesize a multiple SP result query processing using either a nested or composite report where each child report handles on RS number. Food for thought. HTH
Regards ... Chris
