Jasper Ideas

Range data / rows for null data to be displayed at the application level (display a zero value)

Several customers i have had needed to show data is Zero for specific rows.


This usually comes up in ranges. Eg. Product defect rate 0-5, 5-10, 10+ to be displayed as a count in a crosstab. If there is no information in the 5-10 range then the crosstab will not contain a column for 5-10.

This can be achieve with SQL queries to manually inserting rows for this range. But a lot of customers have difficulty doing this without messing up other parts of the report.

So if we could somehow manually insert extra rows as needed (probably with a variable ).

Another example would be if regons were returning sales info. If a region made no sales over a period but a customer would want to display all their regions. They might have to join several tables together. Where as if we know there is going to be 3 results they might be able to just access a single table. Then fill in the missing data as "that region made no sales".

  • Eoin Ffrench
  • Mar 10 2021
  • To be Reviewed
Components JasperSoft Studio
  • Attach files