Programmatically Suppressing Report Sections?

[dckerry73]

Can someone please tell me if there is a way to suppress sections of a report at runtime? I am giving the user the option to output to excel or pdf. If excel, I want to suppress the page headers and footers so I don’t end up with a bunch of blank rows for every page break. Can this be done or do I need to create two nearly identically reports to accomplish this? Thanks!

Version – vs2003, C#

 

[IanWaterman]

You can link your user input to a parameter used within the report. This parameter can then be used to conditionally suppress sections.

Ian

 

[dckerry73]

Oh that's clever, I like it, wish I had thought of that! Thanks a lot for the suggestion Ian.

 

[lbass]

Page headers and footers don't ordinarily create blank rows in an Excel export.

-LB