Friday, March 30, 2012

ReportViewer Control Internal Secrets

Hi,
unfortuntely, MS has changed the logic of their generated Report HTML
between RS 2000 and SSRS 2005 using the WEB RepotViewer control.
In RS 2005 the generated HTML
a) the values of parameter list are no longer the REAL report values -
now it's only the collection id
b) the name of the parameter control can't be identified anymore
because it shows someting like:
"ReportViewerControl_ctl01_ctl01_ctl01_ctl00" that was in RS 2000
always the name of the control - especially of the parameter values.
Now a few question regarding the RS 2005 Web ReportView internals,
perhaps somebody could answer:
1) Is there a possibilty during the runtime to lookup the parameter
controls ReportViewerControl_ctl01_ctl01_ctl01_ctl00 via webservices or
ReportingServices DB to find out what is the original name of the
control?
2) Is there a possibility during the runtime to lookup the collection
id values to find out the corresponding parameter values via
webservices or ReportingServices DB to find out what is the original
name of the control?
3) Is there the plan of MS to allow customizable parameterwith your own
ASP implementation with the next SP'
4) Has somebody experience/ idea how to extract the underlying SQL for
the report parameter or already an inplemenation of a dynamicly
generated Parameter screen only based on the RDL definition &
dependencies?
Thanks a lot
best regards
BBBruce, curious to know if you made any headway on your #2 problem?
As I understand, your trying to get the values that the dropdown list is
populated with.
The best I've come up with so far is to run your own dataset (ADO.NET) and
load the dataset into a combo box. Then pass the ddlist.selectedvalue to the
report parameter collection and send that along to the webservice when
rendering the report.
Let me know if you have more, I'm really trying to find way to build dynamic
webpages, based off the parameters of a particular report. Hence the user
selects a report from a dropdown, and the page (an aspx page) shows the
appropriate controls to satisfy the parameter requirements.
When a different with different set of parameters is selected the screen is
changed accordingly.
Thanks,
rwiethorn
"BB_Reporting" wrote:
> Hi,
> unfortuntely, MS has changed the logic of their generated Report HTML
> between RS 2000 and SSRS 2005 using the WEB RepotViewer control.
> In RS 2005 the generated HTML
> a) the values of parameter list are no longer the REAL report values -
> now it's only the collection id
> b) the name of the parameter control can't be identified anymore
> because it shows someting like:
> "ReportViewerControl_ctl01_ctl01_ctl01_ctl00" that was in RS 2000
> always the name of the control - especially of the parameter values.
> Now a few question regarding the RS 2005 Web ReportView internals,
> perhaps somebody could answer:
> 1) Is there a possibilty during the runtime to lookup the parameter
> controls ReportViewerControl_ctl01_ctl01_ctl01_ctl00 via webservices or
> ReportingServices DB to find out what is the original name of the
> control?
> 2) Is there a possibility during the runtime to lookup the collection
> id values to find out the corresponding parameter values via
> webservices or ReportingServices DB to find out what is the original
> name of the control?
> 3) Is there the plan of MS to allow customizable parameterwith your own
> ASP implementation with the next SP'
> 4) Has somebody experience/ idea how to extract the underlying SQL for
> the report parameter or already an inplemenation of a dynamicly
> generated Parameter screen only based on the RDL definition &
> dependencies?
> Thanks a lot
> best regards
> BB
>

No comments:

Post a Comment