Hi, our current solution grabs a reports definition, modifies it to handle collapsable columns, modifies the reports datasource (else it blows up), then sends it back to the server for processing. These modifications are done by doing string replaces.
This has worked fine until now.
The business has created reports with sub-reports. The main report runs fine but where the sub-reports are to be displayed we get an error. I've searched the net and the fix has been stated that when using web service calls to execute a report
you need to use absolute datasource references vs relative. This makes sense as that's why i modify the reports datasource above manually.
Question 1: Do i also need to load each sub-report, manually modify the definition to use absolute datasource references then send back to the server? Is this best practice?
Question 2: Am i doing this all wrong? Is there a better way of modifying a reports datasource than performing a string replace on the rdl file?
I'm thinking i've going about this the wrong way and hoping someone can "show me the light!"
Thanks for any help in advance!