| Category: | Feature request |
Priority: | Urgent |
Status: | New |
| Project: | Severity: | Block |
Resolution: | Open |
|
| Component: | Reproducibility: | Sometimes |
Assigned to: |
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).
3 Comments:
This FR is similar to request #0002670, the only difference is that requester there wants support of printWhenExpression in crosstabCell.
Is anything happening with this? Whether it be printWhenExpression, removeLineWhenBlank or someother mechanism I need the ability to remove a row
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