August 16, 2010 at 7:46 am
Is there a way to show or hide the report header when a report is ran. I am trying to give the user the option of seeing the report header if they want. Can this be done?
August 16, 2010 at 8:52 am
You could add it as a parameter defaulted to either visible or not whichever is the most prevalent (or whichever set of users will complain the loudest). Return True or False from the parameter and use that to drive the visible property of the header.
-Luke.
August 16, 2010 at 8:56 am
Am I able to do this with the entire page header, if so do you know what the visibilty property of the page header is?
August 16, 2010 at 9:09 am
You could do it with each object in the header, or if it's only a one page report you could turn the Show Header on First Page Property to false to hide it, though I'm not sure either of these options will get you the screen/page real estate back which is what I'm guessing you're actually trying to do?
-Luke.
August 16, 2010 at 9:42 am
Ok, so I was able to show/hide the objects in the page header. Is there a way to not export the page header when I export to excel? Even if I don't show the page header it still exports it to excel with no data.
August 16, 2010 at 10:42 am
I'm not 100% sure, but you could look at playing with the data output tab of the section or object properties. I'm not sure how to configure it to do this (BOL and Google are your friends here.)
Can you perhaps share the business reason why the header should not be included when viewing or exporting the report? Perhaps we can suggest a better alternative?
Why not just create a report that doesn't have a page header? Perhaps it's something you can include on your main report that the users could click on to open prior to exporting the report? Make it almost like a drill though?
-Luke.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply