ParameterValue.Label from rs.GetSubscriptionProperties() is blank
Hello,
Is there some reason why ParameterValue.Label when calling the function rs.GetSubscriptionProperties() is blank, where rs is ReportingService2010(), a connection to Reporting Services? ParameterValue.Value is populated, but we have some values that
will not make much sense to the users if we show the internal values, we want to show the labels that they would see in Report Manager in the dropdowns.
I'm trying to develop a C# application to give a more consolidated view of report subscriptions, so they can be better managed. We had one report that had 150 subscriptions, whittled down to 70 after manually creating a spreadsheet to identify duplicates
and things that could be consolidated. We would like a compressive view into subscriptions so that we don't need a spreadsheet to figure how to re-use an existing subscription. The SQL Server performance implications of running unnecessary subscriptions
can be huge if the report is not speedy. Ideally I would like an expanded view into subcriptions to be in the Subscriptions tab of a report in Report Manager so I don't have to code this workaround application to give me that expanded view.
The current Report Manager is not friendly when you are more of a subscription power user, like we seem to be. Please please please create this expanded view, maybe as an option, so you can switch back and forth between expanded and normal view if you
don't want to see all the details. If you could also go so far as to put the expanded view into a grid that could be exported to Excel, that would be incredibly useful.
In the meantime, I'll keep working on my C# app that gives me the expanded consolidated view. :)
Thanks,
Robert
June 24th, 2011 12:36pm
Hi friction909,
According to your description, you would like to improve the subscription function on report manager, right?
If that’s the case, I am afraid it is impossible to achieve in reporting services, all the report server web pages are compiled already, and we have no source code of the report server. I suggest you programming the function in your C# web application
using web services.
Moreover, if you have any concern about this, please submit a feedback at
http://connect.microsoft.com/SQLServer/Feedback and hope Microsoft improve this feature in the next service pack or product release.
Any questions, please feel free to ask.
Thanks,
Eileen
Free Windows Admin Tool Kit Click here and download it now
July 1st, 2011 8:57am


