Combine 2 reports

[deepak2k2]

Hi,

I've created 2 seperate reports in report studio.  Now my requirement is to combine into 1 report. >:(   

Please give me suggestions to do it in an effective way.

Thanks in advance.

[blom0344]

As long as they run against the same package it is a matter of copying queries, variables, report pages and prompt pages into a new report. Allobjects that need to be copied should have unique names (check parameters) and you need to follow the correct order to avoid losing them in the proces

[phoenixfire]

Copy the queries first and then the layout.