I have two sql procs that will return two different types of data for my product inventory. I want to display the report grouped by product and then in the detail for each product I want to display the two subtables for that product from each proc.
I'd like to avoid subreports running over and over for each individual product.
Is there a way that I can call the two procs to return all the data for all the products from each source, but then have the grouping somehow stay synced with each of the two datasets? If not, what would be the best way to write this type of report?
Grouping with two sub sections from two different tables
Re: Grouping with two sub sections from two different tables
Hello.
Please, try to add relations between data for each subtable and products data band.
Then you could add two data bands and set them as detailed band for products data band.
You could get more information about how to create the Master-detailed report in the Stimulsoft User Manual.
Thank you.
Please, try to add relations between data for each subtable and products data band.
Then you could add two data bands and set them as detailed band for products data band.
You could get more information about how to create the Master-detailed report in the Stimulsoft User Manual.
Thank you.