MSSQL Multi Report in One
Posted: Thu Oct 13, 2022 7:10 am
Hi,
We currently have a Report in Crystal where you have 3 reports in one. This produces a report with 3 separate data sets and results.
Explained;
Dataset A will use Clients = Report 1
Dataset B will then uses the Clients ID/Number to produce Invoices = Report 2
Dataset C will then uses the Clients ID/Number to produce Orders = Report 3
Then it totals this clients Invoices and Orders, then the next client..........and so on
Can I reproduce this in Stimulsoft, and if so maybe advise me in a direction please?
Thank you in advance.
We currently have a Report in Crystal where you have 3 reports in one. This produces a report with 3 separate data sets and results.
Explained;
Dataset A will use Clients = Report 1
Dataset B will then uses the Clients ID/Number to produce Invoices = Report 2
Dataset C will then uses the Clients ID/Number to produce Orders = Report 3
Then it totals this clients Invoices and Orders, then the next client..........and so on
Can I reproduce this in Stimulsoft, and if so maybe advise me in a direction please?
Thank you in advance.