THY02K
March 26th, 2006, 07:54 AM
Hi, I'm investigating if it's possible to dynamically add column to selected report hosted by SQL Server's Reporting Service?
In my quest to resolve this problem I came across this article: http://www.codeproject.com/dotnet/DynamicReport.asp
Basically, the author's approach is to pass selected report a paratmer (plain old report parameter just like any other). The report toggle column property "visibility" of selected columns based on this parameter - but these columns needs to be defined ahead of time.
I'm looking for a way to truely dynamically add column to reports (rdl files loaded to Report Server). Thinking of further exploring Reporting Service Web Service Library - you can adjust web service properties, specify report paramters and retrieve report but it does not look like it will let you dynamically . Any idea? Thanks.
Norman Fung
REF:
MSDN - Reporting Services Web Services Library
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3g0y.asp
In my quest to resolve this problem I came across this article: http://www.codeproject.com/dotnet/DynamicReport.asp
Basically, the author's approach is to pass selected report a paratmer (plain old report parameter just like any other). The report toggle column property "visibility" of selected columns based on this parameter - but these columns needs to be defined ahead of time.
I'm looking for a way to truely dynamically add column to reports (rdl files loaded to Report Server). Thinking of further exploring Reporting Service Web Service Library - you can adjust web service properties, specify report paramters and retrieve report but it does not look like it will let you dynamically . Any idea? Thanks.
Norman Fung
REF:
MSDN - Reporting Services Web Services Library
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3g0y.asp