[#4626] - Support isRemoveLineWhenBlank in crosstabCell

Category:
Feature request
Priority:
Urgent
Status:
New
Project: Severity:
Block
Resolution:
Open
Component: Reproducibility:
Sometimes
Assigned to:
93

Imagine the following data:

RowGroup1a RowGroup2a ColumnGroup1 1
RowGroup1a RowGroup2a ColumnGroup2 2
RowGroup1a RowGroup2b ColumnGroup1 3
RowGroup1a RowGroup2b ColumnGroup2 4
RowGroup1b RowGroup2a ColumnGroup1 5
RowGroup1b RowGroup2a ColumnGroup2 6
RowGroup1b RowGroup2b ColumnGroup1 7
RowGroup1b RowGroup2b ColumnGroup2 8
RowGroup1c null ColumnGroup1 9
RowGroup1c null ColumnGroup2 10

This will produce the following crosstab (value in RowGroup1x are sum of values in appropriate RowGroup2x):

ColumnGroup1 ColumnGroup2
RowGroup1a 4 6
RowGroup2a 1 2
RowGroup2b 3 4
RowGroup1b 12 14
RowGroup2a 5 6
RowGroup2b 7 8
RowGroup1c 9 10
null 9 10

Now it is not possible to remove row with 'null' and show row with 'RowGroup1c':
- if we filer out row with NULL from dataset, then in crosstab row with 'RowGroup1c' disapears;
- using 'Print When Expression' + 'Remove Line When Blank' on text fields is removing text fields but crosstab line is still displayed (probably because crosstab data cell has fixed height).

typhoon's picture
37
Joined: Feb 22 2010 - 3:26am
Last seen: 11 years 1 month ago

3 Comments:

#1

This FR is similar to request #0002670, the only difference is that requester there wants support of printWhenExpression in crosstabCell.

#2

Is anything happening with this? Whether it be printWhenExpression, removeLineWhenBlank or someother mechanism I need the ability to remove a row

#3
  • Priority:Normal» Urgent
  • Severity:Minor» Block
  • Reproducibility:Not Attempted» Sometimes
  • Status:Acknowledged» New

which version the option of remove blank cell on crosstabCell supported. We have urgent requirement to remove blank line when a text field is hidden based on printwhenexpression in crosstab row group.

We are currently getting blank space in row group for which the text field is hidden

Feedback
randomness