View Only
  • 1.  Some Reports questions

    Posted Nov 22, 2016 02:56 PM

    Hi group. Here some questions related to CA Harvest Birt Reports:


    1. It is possible to set filter parameters in order to execute a report?

    2. it is possible to call Stored procedures?

    3. Is possible to call SQL Functions?


    Thanks for your help.


    Best Regards,


  • 2.  Re: Some Reports questions

    Broadcom Employee
    Posted Nov 24, 2016 07:51 AM
      |   view attached

    Hi John,,

    First question is regarding the possibility of using filter parameters.

    Yes, definitely filters can be used to sort the data as required by you.
    For ex: Using where or any other filter supporting sql queries to fetch the data as per your requirements

    Sample queries can be found in the below attached PDF



    Questions 2 and 3:
    2.It is not possible to call stored procedures and sql functions from the reports.

    The query used in the reports needs to begin with select statement.Otherwise it throws up an error mentioning "HSQL query must begin with SELECT".


    More specific  details on custom reports can be found from here (link to docops content  of CA SCM Harvest documentation)


    Please do let us know if this answers your questions.





  • 3.  Re: Some Reports questions

    Posted Nov 29, 2016 04:11 PM

    Thank you Balakrishna.


    Then I have the doubt that it is a limitation of BIRT in Harvest, because based on what I know of BIRT  in fact it is possible to call stored procedures using for example "SELECT * FROM {call TestProc(?)}"


    What could be an alternative in order to more complex reports requirements?


    Best Regards,



  • 4.  Re: Some Reports questions

    Broadcom Employee
    Posted Dec 06, 2016 12:29 PM

    Hi John,


    Could you let us know what kind of reports you are looking for.?

    As you have mentioned about the complex reports requirements,if we do get to know,may be we can try to assist you further .




  • 5.  Re: Some Reports questions

    Posted Dec 09, 2016 06:44 PM

    For example:

    - Number of package that have more than N shared items (Customer consider any item reserved more than 2 times a shared item.)

    - Package details for packages that Passed through a lifecycle state in a specific date range (admin should be able to define this date range as input data to the report)


    Thanks for your suggestions.

  • 6.  Re: Some Reports questions

    Broadcom Employee
    Posted Dec 13, 2016 04:25 AM

    HI Johnv,

    Thank you for the response and info on the specific reports you were looking for.

    Kindly raise a support ticket with CA.

    Specific solutions like this one need to be done through the CA support.
    Our SE team (L1 and L2) will be able to provide support you through the support ticket.

    You may kindly mention the same reports as you mentioned in the previous mail above and we will be able to take it further from there.

    Regards ,