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

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
142
Views
6
Comments
John Bruso1
John Bruso1 Rank 6 - Analytics Lead
in Oracle Analytics Cloud and Server

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:

<?import:psxmlp://WYES001A?><?call-template:WorkTypeCodes?>

Thanks for your help and direction!

John

Answers

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach

    please create two data sets within 1 data model and generate xml and upload here , Thanks

  • John Bruso1
    John Bruso1 Rank 6 - Analytics Lead

    Hi Venkat,

    My two datasources have nothing in common. 1 is a list of Vendors and the other is a list of Work type codes. Can the 2 xml data-sources still be combined into 1 XML file?

    John

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach

    https://blogs.oracle.com/xmlpublisher/formatting-concatenated-datasources please follow above link , let me know if you have any issues.

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach

    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
    John Bruso1 Rank 6 - Analytics Lead

    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:

    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
    Venkat Thota - BIP Rank 7 - Analytics Coach

    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