MSSQL Multi Report in One

Stimulsoft BI Designer discussion
Post Reply
MariusNel
Posts: 5
Joined: Fri Sep 30, 2022 6:16 am

MSSQL Multi Report in One

Post 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.
Lech Kulikowski
Posts: 6196
Joined: Tue Mar 20, 2018 5:34 am

Re: MSSQL Multi Report in One

Post 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.
MariusNel
Posts: 5
Joined: Fri Sep 30, 2022 6:16 am

Re: MSSQL Multi Report in One

Post 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?
Attachments
2022-10-13_14-31-47.png
2022-10-13_14-31-47.png (62.83 KiB) Viewed 15515 times
Lech Kulikowski
Posts: 6196
Joined: Tue Mar 20, 2018 5:34 am

Re: MSSQL Multi Report in One

Post by Lech Kulikowski »

Hello,

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

Thank you.
Post Reply