October 8, 2008 at 9:03 am
Whenever I deploy my RS 2005 project, all the objects show up on the Report Manager selection screen (subreports, images, .bmp's, etc)
When editing the project / report .rdl, image, etc in Visual Studio 2005, HOW do I set the attribute to auto-hide a given object once it's deployed?
Currently, I'm manually clicking the SHOW DETAILS button on the Report Manager to render the entire list of objects in the project then editing and clicking the "Hide in list view" checkbox.
ALSO -- I'd like to enter the DESCRIPTION of the report w/in Visual Studio properties so it shows up on the Report manager screen? Where can I enter the DESCRIPTION specifically? (I'm hunting around and don't see it in VS 2005)
thx in advance
October 8, 2008 at 10:00 am
Let me answer myself (after some digging in this forum):
If you have update access to the database behind Reporting Services and know the names of all the objects you want to make hidden (subrereports in this case), open the ReportServer.dbo.Catalog table and set the 'Hidden' column value for these objects to 1 which is a bit datatype. Unfortunately there is nothing I am aware of that identifes if an object is a subreport versus a normal report so that you could do a mass update of the hidden column values basd on that identifier. As a normal practice however I name all my subreports with a prefix of 'SR_' so in my case I could have done an update like:
UPDATE ReportServer.dbo.Catalog SET Hidden = 1 WHERE LEFT(Name, 3) = 'SR_'
NOTE: The above is for SQL Server 2000 and I am not sure if it would apply to 2005 or 2008.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply