Hello all,
I have an install of BIDS which was deploying reports with no problem until today. Now when I attempt to deploy a report to either the Release or Debug space, I get an error "The Definition of the Report is Invalid". This is true for every report in the project.
The only change I made (and clearly the problem) is that I altered the credentials in the shared data sources.
Is there something I can do to remedy this? I'm not familiar enough with SSRS setup yet to know where I should be digging.
I've seen this error in SSRS and I think its when there is a field referenced in the report that is not in the dB results.
When you changed the credentials, would it have got an updated version of the SP with different fields?
If you look at the error box in the bottom in SSRS when you deploy it should give you the item that is causing the error. e.g TextBox25 or similar. Then check the expression on that item.
Best of luck, Dara
Thank you for your responses. I am publishing from BIDS 2008 against SQL 2008.
Dara, when I updated the credentials, I did get new fields from the Stored Procedure although I don't think I lost any. I'm not seeing any detail in the error that points to a specific element and it appears that the error is popping up for everything I try to deploy, not just the one report I have been working on.
I'll keep digging. Thank you all for the help!
Is that the whole error message? Try right clicking the .rdl -> view code and see if it points you to an error after deploying.
Travis,
Unfortunately that is the whole message. The error does not return a file name, or row number. And view code does not point me to anything in particular. Seems like it is something higher up in the setup than just the report since I cannot deploy any of the other reports in the project.
I was finally able to get more detail from on the error by running the report in preview mode in BIDS. It pointed me to the offending field and I was able to correct it and deploy.
Thank you all for your responses!