Community
Participate
Working Groups
I have a report which I want to hide one of the columns in the column side's Grand Total. Following a guide online I have set the whole column's (each cell in the column) Display in Section->Display as "No Display". When I preview my report, I see an empty column at the end of my Cross Tab and when I generate the report using the xls emitter, an empty column without any data shows up.
There seems to be some error in the description. No display is not supported in xls emitter now, so the grand total data will be show up in the xls, while it will be hide in html preview. But for crosstab, the grandtotal column will not be hide, only the data will. This is different from normal table. Since the grandtotal column is not actually not a complete column.
(In reply to comment #1) > There seems to be some error in the description. > No display is not supported in xls emitter now, so the grand total data will be > show up in the xls, while it will be hide in html preview. > > But for crosstab, the grandtotal column will not be hide, only the data will. > This is different from normal table. Since the grandtotal column is not > actually not a complete column. How would I go about truly hiding a column in the grandTotal area then? Is there a way to do it ? I don't even want an empty column appearing.
(In reply to comment #2) > (In reply to comment #1) > > There seems to be some error in the description. > > No display is not supported in xls emitter now, so the grand total data will be > > show up in the xls, while it will be hide in html preview. > > > > But for crosstab, the grandtotal column will not be hide, only the data will. > > This is different from normal table. Since the grandtotal column is not > > actually not a complete column. > > How would I go about truly hiding a column in the grandTotal area then? Is > there a way to do it ? I don't even want an empty column appearing. Is there any reason that you want to hide the grandtotal other than removing it from the design directly?
(In reply to comment #3) > (In reply to comment #2) > > (In reply to comment #1) > > > There seems to be some error in the description. > > > No display is not supported in xls emitter now, so the grand total data will be > > > show up in the xls, while it will be hide in html preview. > > > > > > But for crosstab, the grandtotal column will not be hide, only the data will. > > > This is different from normal table. Since the grandtotal column is not > > > actually not a complete column. > > > > How would I go about truly hiding a column in the grandTotal area then? Is > > there a way to do it ? I don't even want an empty column appearing. > > Is there any reason that you want to hide the grandtotal other than removing it > from the design directly? I just need the values in the column for calculations not for display, but I need the values from the grandTotal column
In such case, you should create aggregation in the binding page of crosstab instead of creating the grand total in layout.
Okay. The suggestion works. going to close it.
