Merge 3 Unlinked Reports into a single Report

[Former Member]

I have 3 Crystal Reports with  different structures and groupings, I want to view it in single report .Right now I'm using Embedded Crystal Report hence I'm unable to merge it through the code .I require a solution to this.

Thanks a lot in advance.

[former_member183750]

There is no way to do this using the SDK, or CR designer. Only solution; new report.

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

[Former Member]

Hi Saurabh,

No other way to merge three unlinked reports. Follow above expert's suggestion.

One suggestion you can create a new report using three reports datasource into one data source i.e For ex:  sql query with using of Union operator.

Thanks,

DJ

[Former Member]

Hi Sastry,

Is there any other way to do the same, as the application I'm using doesn't allows me to perform the steps specifically the step-"Now go in Insert menu --Click on Sub report-- selection option to Browse to select existing report--locate first report and select it and place it in Report Footer 1"

[former_member205840]

Hi Saurabh,

There is no other way we can insert sub reports in main report.  If you are trying this through .NET or Java, you may have look for any coding options.

Thanks,

Sastry

[former_member205840]

Hi Saurabh,

You can do it through crystal reports designer :

Create a blank report and suppress all section except report footer, duplicate report footer like RP1, RP2 and RP3.  Now place your reports as sub reports in each section.

If you run this report all reports results will be displayed as one report.

Sastry

[Former Member]

Hi Sastry,

Thanks for your response, But the problem was that , that I wasn't able to do so may be due to the application through which we are using the Crystal Report.

Even then it would be appreciated if you describe me the steps for how to add a sub report to an existing report. And if you have an alternate solution then please let me know.

Thanks & Regards

Saurabh

[former_member205840]

Saurabh,

Open Crystal Reports designer

File--New--Blank Report

Now you will see only design of blank report

Right click on all sections and select 'Suppress' except Report Footer.

Right click on Report Footer and click on New Section to create one more Report Footer, create one more new report footer

Now go in Insert menu --Click on Sub report-- selection option to Browse to select existing report--locate first report and select it and place it in Report Footer 1

Repeat the above for 2nd 3rd sub reports. Place them in Report Footer 2 and 3 .

Now refresh the blank report to see all reports information at one place.

-Sastry