bkpierce
asked on
SQL Reporting Error, subreport could not be shown
I moved a SQL reporting data source and report RDL files to a VM. I backed up the database and restored it on the VM (same version SQL). I then uploaded the datasources and RDL report files to the VM.
When you try to run the main report it says "Error subreport could not be shown"
However if you go to the sub reports individually and run them they work fine, why would they error out on the main report but not individually when run?
When you try to run the main report it says "Error subreport could not be shown"
However if you go to the sub reports individually and run them they work fine, why would they error out on the main report but not individually when run?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I re-added both the sub reports to the main report and that fixed one of them however the other is still generating the "sub report could not be show error"
The sub report that's generating the error works fine when you run it by itself but as soon as you add it to the main report as a sub report it generates the error.
Any other suggestions?????