2

Is there a way to hide rowGroups with NULL values in Crosstab ?

Ravi
  • 2,472
  • 3
  • 20
  • 26
  • it is unclear what you want to achieve. E.g. If you want to hide the entire row: filter out null data in your query. If you want to hide the specific field: select blank when null in the text field properties. – MrsTang Jan 09 '13 at 11:48
  • I can't comment the null data. For example, I have a LEFT JOIN in my query that the lists values for every date in a specified date range, there will obviously be nulls for some dates without values. – Ravi Jan 09 '13 at 12:25
  • 1
    as far as I am concerned this is currently not possible within crosstabs. see http://community.jaspersoft.com/jasperreports-library/issues/4626, so unfortunately only choice would be data manipulation. – MrsTang Jan 09 '13 at 14:19
  • @Ravi I've tried to reply to the similar question at this post: [How to show column at Crosstab even the data is absent](http://stackoverflow.com/a/35998020/876298) – Alex K Mar 14 '16 at 21:32
  • Thanks Alex. I've already done what you've suggested i.e. tweaking the query to get all the non null values. – Ravi May 05 '16 at 15:15

0 Answers0