I'm working with a tablix in SSRS 2008 R2. I had to add a parent group with the code
"=Int((RowNumber(Nothing)-1)/65000)" as the group expression because my users will be exporting the data to Excel and we have an older version that cuts off at 65,000 rows and I had to break the data on two sheets when that happens.
Anyway, because it's a Matrix, it automatically adds it as a column group. I don't want this empty column to show, since it's only a container for the row limit code. I can hide the column, but it leaves white space when it renders in SSRS (no big deal), but it also creates a blank column in Excel when it exports, which I absolutely don't want. I tried to change the dataelementoutput to no output, but what that does is remove all of my detail rows, since the grouping for the rowlimit has to be on the details. In SSRS 2005, when you added a group it was automatically a row (not a column) and when you hid it, it stayed hidden and did not export to Excel.
Does anyone know of a way to not export the column group to Excel? Thanks, Denise.