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?
just use select 1 (from dual)
Thanks Georg for the quick reply!! Works great.