Clarity

  • Private Community
 View Only
Back to discussions
Expand all | Collapse all

JasperSoft Studio reports using "Sub" datasets - how to

  • 1.  JasperSoft Studio reports using "Sub" datasets - how to

    Posted Apr 13, 2016 11:42 AM

    I have been able to generate excellent results using JasperSoft Studio where the "top-level" query uses the CA PPM beans. However, I have many reports which require a "Table" or "Crosstab" which requires a sub-dataset to be used/created. On my local workstation, I can use the "Empty Record" as the top-level query and create a sub-dataset referencing the CA PPM beans. However, I want to know if there is a best practice for creating this type of report. Is the solution to create a "Empty Record" data source on the JasperServer?

     

    many thanks,

     

    Michael



  • 2.  Re: JasperSoft Studio reports using "Sub" datasets - how to
    Best Answer

    Posted Apr 13, 2016 11:55 AM

    Hi Michael,

    just use select 1 (from dual)

     

    Regards

    Georg



  • 3.  Re: JasperSoft Studio reports using "Sub" datasets - how to

    Posted Apr 14, 2016 04:33 PM

    Thanks Georg for the quick reply!! Works great.