Hello,
I'm new to SSRS and I need to deploy reports that exist in Live to our Test environment as soon as possible. Unfortunately, my predecessors did not add any of the custom reports to Test. There's nothing like trial by fire. We're on RAMP. The only instructions I've received from Tessitura are:
1) Go into the BIDS project containing your custom reports in LIVE 2) Change the config to the TEST location and deploy
If someone could step me through this, I'd greatly appreciate it.
Thank you!
Shereen -
In case your issue is not resolved at the field or tablix level...
While we are not on RAMP, we do have separate instances of SSRS running for Live and Test, so if what Levi says is true, our setup might be still comparable. You might be able to deduce what you have and what you don't have from a browser using Microsoft IE Report Manager interface - that has really helped me clarify what I have in Live and Test, and help troubleshoot things like this. Try going to http://<servername>/Reports - try both your test and live servernames in there, and compare the two setups. (You do need a server login, though, to access this, and maybe that is something that RAMP folks don't have...?)
I wonder if you might not have a Data Source deployed to your test environment, since you also didn't have any reports deployed there. If your report/tablix is pointing to a dataset that does not live within a data source in the test environment... maybe...?!? I had something similar once when I made a new view or sproc or something that hadn't been pushed out as an SSRS data source the first time...
Beth
Thank you everyone for your assistance! In addition to the path needing to be updated for Test, there was more than one tablix in the report that was not supposed to be there. I deleted them, deployed the report, and the report is now working.
Thanks again!
Shereen