May 6, 2010 at 11:56 am
Hi I'm on SQL 2008 standard 64 bit using full professional VS 2008 to do report dev.
We I hit deploy for a report it does not overwrite the previous report definition. I have to manually delete the definition of the previous version before the deploy works (by going at http://server name/Reports/Pages/Folder.aspx).
I get no error message, ever, and since it works after the delete I don't think this is due to permission issues (I'm admin on all machines involved).
May 10, 2010 at 10:53 pm
Hi,
Have you set OverWriteDateSources property as True in Configuration Tab in All Configuration/Release Mode
Raunak J
May 11, 2010 at 5:12 am
Yes I've tried that but that setting is only for the datasource and has [no apparent] effect on the rdl itself..
May 11, 2010 at 5:35 am
This is really interesting....deleting the old .rdl....
:alien:
Raunak J
May 11, 2010 at 6:35 am
Just out of curiosity and forgive me for asking the is it plugged in type of question, but did you make any changes to the report?
On SSRS 05/win03 I've had some issues when I wanted to update the description only of a previously deployed report. I changed the description in VS and redeployed the report. The old description was there unless I deleted the report prior to deploying the "new" report. Since I'm in a small shop this isn't a huge issue and we just deal with it, but I'm guessing it has to do with the fact that I wasn't actually changing anything on the report, just the description.
Perhaps you can try making a small formatting change, saving the report, and then reverting the change and saving it again then trying to redeploy. This was pretty much the only way I was able to overcome the issue with the description not changing, but it was easier for me to just delete and redeploy.
-Luke.
May 11, 2010 at 7:08 am
I have seen this in both 2005/2008 when you try and deploy a new report over an existing report. If the report has a different signature (GUID - I think), it won't overwrite the existing report.
This also happens if you recreate a report model - you have to delete the previous version before you can deploy the new version.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 11, 2010 at 8:23 am
Any workaround or bug on the connect site I can be reffered to?
Or plan D, any shortcut to delete all reports and redeploying everything at once?
May 11, 2010 at 8:28 am
As far as plan D you could look into the Reporting Service Scripter It's a handy tool to have for keeping Development Instances Synched with Prod. More than likely it will be able to accommodate what you are trying to do. It is a helped tool for creating (and executing) scripts with rs.exe. If it can't help you create the exact script it should get you close enough that you'll be able to finish it off with rs.exe
-Luke.
May 11, 2010 at 8:30 am
Luke L (5/11/2010)
Just out of curiosity and forgive me for asking the is it plugged in type of question, but did you make any changes to the report?On SSRS 05/win03 I've had some issues when I wanted to update the description only of a previously deployed report. I changed the description in VS and redeployed the report. The old description was there unless I deleted the report prior to deploying the "new" report. Since I'm in a small shop this isn't a huge issue and we just deal with it, but I'm guessing it has to do with the fact that I wasn't actually changing anything on the report, just the description.
Perhaps you can try making a small formatting change, saving the report, and then reverting the change and saving it again then trying to redeploy. This was pretty much the only way I was able to overcome the issue with the description not changing, but it was easier for me to just delete and redeploy.
-Luke.
I've had a couple different cases with different changes not getting deployed. My main issue is that I need to work with n different companies at the same time that the user chooses at run time in parameters. Since those n compagnies each have a different set of tables in a single DB I've made a "sp_msForEachCie" proc that takes a parameter for the list of companies. Then I build the sql at run time and run with that.
However that means from SSRS point of view that I only make changes to a string in a query. Maybe SSRS assumes that this change is trivial but that's far from it... every little change matters in there.
Then I hit deploy and "nothing" happens even if I don't get any errors.
Again any connect link to bump up this bug up the list or maybe start a new one (I have not found anything relevant but maybe you guys know of one)?
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply