Subreport error in when previewing an SSRS report in BIDS
I am using SSRS 2008 R2 and using BIDS to develop reports. I have a report that runs fine on its own but when that report is included as a subreport in the main report I get the following error where the subreport is supposed to render: Data retrieval failed for the subreport, "sub report name", located at:/sub report name. Please check the log files for more information. This seems to be a problem with any sub report in BIDS on my machine when running in preview. When the reports are deployed to an SSRS server, they run fine.Jeff T Jones
January 28th, 2011 10:35am

Hi Jeff, Based on your information, I think your subreport might locate in another report project, to this scenario, it will not render the subreport correctly except deploying the subreport to the report server, then set a relative subreport path in subreport's property. Please see this FAQ: How do I preview a Subreport which is in another SSRS project at this link http://blogs.msdn.com/b/sqlforum/archive/2010/12/21/faq-how-do-i-preview-a-subreport-which-is-in-another-ssrs-project.aspx Thanks, Challen FuChallen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
January 31st, 2011 12:26am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics