I need to generate a cover page for an SSRS report, along the lines of this example in Excel:
Note on this image the hidden columns after N and rows after 30. Is it possible to force SSRS to hide these columns & rows?
I can't find anything about hiding these when not generating the columns, and I've tried generating the columns with a simple column group. Using =iif(Globals!RenderFormat.Name = "EXCELOPENXML" OrElse Globals!RenderFormat.Name = "EXCEL", True, False) does not work on generated columns; it hide the data, not the column.
For reference, the test report looks like this:
And the dataset is generated with this SQL:
set transaction isolation level read uncommitted;
set nocount on;
select top 255
n.Number
from dbo.Numbers as [n]
EDIT: For those who don't have a numbers table, you can use:
select top 256
row_number() over (order by v.number) as [Number]
from master..spt_values as [v]
My numbers table starts at 0, hence 255 in that and 256 in the alternative.
