Finance | Project Operations, Human Resources, ...

How to merge two SSRS reports at runtime

(0) Share

Report

Posted on by CU07051604-0

I have one report (SalesInvoiceExtension) that I want to merge with another fixed/static report to it upon generation. The idea is that the second report would append to the first one on the end when the report is generated. Has anyone done this before? Do you have any ideas or resources to help with this?

Thanks in advance!

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report

Hi,

No this is not possible. You cannot combine different SSRS reports to one.

You can run two reports at a time, but you cannot combine both.

If you want, you need to create one single report - Maintain separate table for two reports - Insert the data into the table separately - Create one report design which will hold both the report designs.

Thanks,

Girish S.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report

Hi, You mentioned static report so I am assuming you want to display something like Terms & conditions pages in SSRS report. If yes, then you can refer to these articles.

https://stackoverflow.com/questions/41722755/ssrs-i-need-to-add-terms-and-conditions-to-the-end-of-a-quote

https://ax.docentric.com/append-terms-and-conditions-to-printed-purchase-orders-or-invoices-in-d365fo/

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

If you are referring to report like terms and conditions, you can refer to HcmACA1095B and HcmACA1095C report.

Thanks,

Girish S.

Was this reply helpful? Yes No
Suggested answer

Hana Xue Microsoft Employee on at

Like (0)

Report

Hi,
This blog describes grouping multiple reports into one report in SSRS, you can simply check it out:
reporting services - Group multiple reports into one in SSRS - Stack Overflow
Best Regards,
Hana

Was this reply helpful? Yes No