Click here to Skip to main content
15,887,886 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I want to generate report for multiple datasest means my stored procedure returns 2 results so how to generate a one report for multiple results/datasets. I am using Report bulder 3.o. I am new to this please help.

What I have tried:

I think have to create multiple dataset or join two datases dont know how to do it. so please suggest
Posted
Updated 7-Mar-16 23:18pm

1 solution

The documentation clearly states that you can't do that:
If multiple result sets are retrieved through a single query, only the first result set is processed, and all other result sets are ignored.

You'll need to modify your query to return a single result set, or have two procedures returning one result set each.

NB: As the documentation also says, "You cannot display detail data from multiple datasets in a single data region."
 
Share this answer
 
Comments
Member 9579525 8-Mar-16 6:29am    
Thank you.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900