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".
Components | JasperSoft Studio |