CA Service Management

  • 1.  Total Number of row count in jasper studio

    Posted Feb 17, 2019 03:31 PM

    1. How to display total number of Row at top of report ?

    2. How to display Date filter value at the top of the report? 



  • 2.  Re: Total Number of row count in jasper studio

    Posted Feb 18, 2019 02:47 AM

    Hi Saikat,

     

    1. you can place the row count using the default variable REPORT_COUNT - see the first answer to jasper reports - How to get the total row count? - Stack Overflow.  Place a text field in the 'Title' band of your report (unless you want to repeat it on every page, in which case you'd put it in the Page Header band).  Enter $V{REPORT_COUNT} as the expression for the text field and set the property 'Evaluation Time' to 'Report' to get the final value.  Add a static text element with an appropriate label for the field.

     

    2. Assuming you're using the technique described here to set up a date filter - Jasper Studio, filtering on a date range - add another text field to the Title band or the Page Header band, and set the expression for the text field to the value of the relevant input parameter (e.g. something like $P{pOpenDateMin} ).

     

    Regards,

    James