Here's my problem. I have an SSRS report with subreports on it. The main report and subreports work fine on my machine when I run the main report. However, when I deploy them to our test server and change the server name of the shared datasource, only the main report brings back data. The subreports show an error of something like "Error in displaying the subreport" for each subreport. The subreports require parameters that I believe I am supplying from the main report. What am I doing wrong? Is it really necessary to deploy the subreports with the main report to the new server. With Crystal Reports, I didn't have to do this. Any thoughts or suggestions would be appreciated.
Are you sure that the subreports are using the shared datasource? Can you run any of the subreports by themself?
|||SteffoS,
Thanks for replying. Yes, I can run the subreports individually and get data. Thanks again. Any other suggestions?
|||Hi All,
I found the answer to my problem. When I right clicked on the subreport and chose properties then went to the parameters tab, I chose the Fields.fieldName.Value for the the value of my parameter. This is incorrect. What I needed to do and did was choose the <expression> item in the dropdown box then click on parameters and choose the correct parameter from the main report to be the value for the parameters in my subreport. Worked like a charm, but I'm not getting too excited. I've read too much that things just started working for people and they could not explain why. That's scary too. Thanks. 
No comments:
Post a Comment