Report Custom Metadata
So from the looks of things, in SSRS you can add any Property you want to a Report providing a string Name and Value. Some of the Properties are already exposed through the Report Manager URL, while others are not (I'm not sure yet if these can be exposed or not). But in either case, you can still use the WebService to query these Properties (it's a bit of a cludge though). Below is an example: Create a custom "Friendly Name" property which is tied to the OneReport.rdl when it's created ==================== Dim pFriendlyNameProp As[Property] pFriendlyNameProp = New [Property]() pFriendlyNameProp.Name = "FriendlyName" pFriendlyNameProp.Value = "One Report To Rule them All" Dim props(0) As [Property] props(0) = pFriendlyNameProp waWarnings = rs.CreateReport("OneReport.rdl", "/Reports", True, baReportContents, props) Use the GetProperties() method on the Report to extract any properties which match the collection of Property Names passed in that you are searching for. If some of the properties don't exist then they won't be returned in the properties() array. Loop through the array to find the properties by name then extract the values (this is the part that seams like hack). ======================================= Dim properties() As [Property] Dim retrieveProp As [Property] Dim props(0) As [Property] 'Create the property to retrieve. retrieveProp = New [Property]() retrieveProp.Name = "FriendlyName" props(0) = retrieveProp properties = rs.GetProperties("/Reports/OneReport.rdl", props) For Each pProp As [Property] In properties Next Hopefully this helps someone else.
August 26th, 2012 11:31am

Hi Christopher, I don't think it is supported to add extended properties for a report even through Reporting Services Web Service. If you have code developing experiences, you may have a look at the SSRS execution endpoints: http://msdn.microsoft.com/en-us/library/reportexecution2005.aspx Regards, Leo
Free Windows Admin Tool Kit Click here and download it now
August 26th, 2012 3:10pm

Are there any options for adding custom metadata about reports into SSRS which can also be queried for through the WebService? When publishing our reports to the SSRS server, I would like to add metadata tags for things like "FriendlyName" and "IsSubreport" to help identify the aux information about the reports when being queried via the web service in our app. I don't think I want the information embedded in the actual rdl file rather something like an "Extended Property" which acts like the "Description" and "Hidden" Properties which can be set which publishing the report via rs.CreateReport(). It would also be great if the column could be shown within the SSRS Report Manager URL, but not a deal breaker. Any ideas?
August 26th, 2012 3:33pm

You could always put JSON text into the description on the server and parse that at run time.Robert Attaway The SQLMDX Dude sqlmdxdude@gmail.com
Free Windows Admin Tool Kit Click here and download it now
August 26th, 2012 4:45pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics