Converting Crystal Rpt with subreport to BI Publisher. 2 separate PS query data sources in 1 report?

Question

Summary Converting Crystal Rpt with subreport to BI Publisher. 2 separate PS query data sources in 1 report? Content Hi All, I'm not sure if this is more of a peoplesoft question or a BI Publisher question.. I apologize if this is not the correct forum... I'm confused about how the BI Publisher sub templates work within Peoplesoft. I have a Crystal report that I am converting to a BI Publisher report. As you know, Crystal can pull data from 1 source in the main report and another source in the sub report. The data may or may not be linked in some way. I have 2 separate PS Query data sources, 1 for the main report and 1 for the sub report. The data between the two has no link or shared keys. Just 2 otherwise separate reports that just so happen to need to be put together into 1 report. So, I have created my main RTF report, it's PS Query data source and Report definition, WYES001.RTF. It works great. I created my second RTF report that will be the sub report, WYES001A.RTF , and it works great as well. How do I bring WYES001A.rtf into WYES001.RTF?? I tried the content library but that just brings in the rtf content of WYES001A.RTF without processing any of the data. There is no linkage to the WYES001A query: Thanks for your help and direction! John

Venkat Thota - BIP · Answer

so your requirement is to show two reports data one after the other in one pdf ? if yes ,then create two data sets in single data model then generate xml , create two tables for each datasets groups in rtf template.then click preview then result pdf is combination of two data sets data.

John Bruso1 · Answer

The user requirement is for the two reports to be merged into 1 PDF like it is in the Crystal Report.

I created an Oracle support ticket. Their suggestion was to see Doc ID 1078734.1 ​in Oracle support:

E-BI/XMLP: How To Generate A Merged File From Two PDF Reports? (Doc ID 1078734.1)

It essentially wants you to code an app engine to take the 2 seperatly generated pdfs and merge them into 1.

I might give it a shot.

Venkat Thota - BIP · Answer

If there is no common relation what is the purpose of combining two data sources into 1 , you can create two reports as separate. please check what is business logic combining two sources. Thanks