1. Paul Weir
  2. InfoMaker
  3. Tuesday, 29 November 2022 18:03 PM UTC

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?

Accepted Answer
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 29 November 2022 20:25 PM UTC
  2. InfoMaker
  3. # Permalink

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



  1. Roland Smith
  2. Tuesday, 29 November 2022 20:31 PM UTC
Or create a second stored procedure that combines the multiple result sets of the first stored procedure into a single result set.
  1. Helpful
There are no comments made yet.

There are replies in this question but you are not allowed to view the replies from this question.