Page 1 of 1

MSSQL Multi Report in One

Posted: Thu Oct 13, 2022 7:10 am
by MariusNel
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.

Re: MSSQL Multi Report in One

Posted: Thu Oct 13, 2022 9:16 am
by Lech Kulikowski
Hello,

We do not understand your explanation.
You can add three pages in one report and use on each page only necessary dataset as you need.

Thank you.

Re: MSSQL Multi Report in One

Posted: Thu Oct 13, 2022 12:38 pm
by MariusNel
You can add three pages in one report and use on each page only necessary dataset as you need. => Will create a page for every dataset.

Hope this example (PNG) picture clarifies the problem?

Re: MSSQL Multi Report in One

Posted: Fri Oct 14, 2022 8:17 am
by Lech Kulikowski
Hello,

Yes, it is possible. You can place several DataBand components with different data sources on one page.

Thank you.