Clarity PPM

Expand all | Collapse all

AdHoc Reports vs Studio Reports

Jump to Best Answer
  • 1.  AdHoc Reports vs Studio Reports

    Posted 06-06-2016 12:20 AM

    Hi All,

     

    We are tryign to migrate reports from BO to Jasper.

    Can anyone let us know the differences between AdHoc Reports and Studio Reports.

    Would there be any performance related effcts.

     

    Thanks in Advance.

     

    Regards,

    Anusha



  • 2.  Re: AdHoc Reports vs Studio Reports
    Best Answer

    Posted 06-06-2016 12:34 AM

    Hi Anusha,

     

    Adhoc reports are domain based reports with limited options for formatting and its for smaller amount of data, where as studio reports are full fledged reporting where you can create reports based on domain or direct SQL.

     

    I would recommend not to write studio reports using domain based  as its has performance issues.

     

    Regards

    Suman Pramanik



  • 3.  Re: AdHoc Reports vs Studio Reports

    Posted 06-06-2016 12:42 AM

    Hi Suman,

     

    Thanks a lot for the response.

    We are currently creating reports in Studio using query.

    Do you forsee any disadvantages with Studio Reports.

    And also we saw that in AdHoc Reports the user can format the report (Sorting, formatiing cells,etc) where as in Studio Reports the reports are rigid.

    Is there a way where such formatting can be made available to users in Studio Reports.

     

    Regards,

    Anusha



  • 4.  Re: AdHoc Reports vs Studio Reports

    Posted 06-06-2016 12:46 AM

    Hi Anusha,

     

    Both kind of reports are pro's and con's. Studio reports are not interactive like sorting/formatting etc but you can always export the same in excel and do it. I don't see any disadvantages for Studio reports rather I prefer studio reports as you have better formatting options and you can build complex reports.

     

    Regards

    Suman Pramanik



  • 5.  Re: AdHoc Reports vs Studio Reports

    Posted 06-06-2016 12:50 AM

    Hi Suman,

     

    Thanks you for the information. That helped a lot.

    Just out of curiosity, is there any documentation which has advantages and disadvantages of Studio Reports and AdHoc Reports.

     

    Regards,

    Anusha



  • 6.  Re: AdHoc Reports vs Studio Reports

    Posted 06-06-2016 12:53 AM

    Hi Anusha,

     

    I am sorry, we don't have something from CA, however I will see if I can put together a document based on our experience. However found few discussion around the same in Jaspersoft and hope that will help for now

     

    Ad Hoc Views and Reports | Jaspersoft Community

    Ad-hoc views vs Reports | Jaspersoft Community

     

    Regards

    Suman Pramanik



  • 7.  Re: AdHoc Reports vs Studio Reports

    Posted 06-06-2016 12:56 AM

    Hi Anusha,

     

    However we have some best practices around both the reporting options, please take a look and see if that helps you

     

    Best Practices for Developing Jaspersoft Studio Reports - CA PPM - 14.4 - CA Technologies Documentation

     

    Best Practices for Ad Hoc Reporting - CA PPM - 14.4 - CA Technologies Documentation

     

    Regards

    Suman Pramanik



  • 8.  Re: AdHoc Reports vs Studio Reports

    Posted 06-06-2016 01:00 AM

    Hi Suman,

     

    Thanks a lot for the information.

    We shall go through the links and try following the best practices.

     

    Regards,

    Anusha



  • 9.  Re: AdHoc Reports vs Studio Reports

    Posted 06-06-2016 01:08 AM

    Thanks Anusha