Friday, March 9, 2012

Deploying problem with reports

Hi,

I have two aquestions.

1. How do I select data ovewrite option in SSRS? When I deploy a report i got a following error message.

Warning : Cannot deploy data source mydatasource to the server because it already exists and OverwriteDataSources is not specified.

2. When I try to snapshot a report on report manager, I get a error message.

"Credentials used to run this report are not stored

Then I went to Management Studio and selected the data source and open the report data source property box. I gave a login name and a password under credential stored securely on the server. Can this login name and password be random ones or do they come from smwhere else? Even After I did this still i get the error.

Thanks

Click project -> Properties in your report project. There is an option for OverwriteDataSources. Personally, I use a shared datasource though. Is your datasource shared?

|||

OK thanks In this case no..my data source is not shared........Is there any disadvantage if i select Overwrite option?

what if the data source is shared? still can I used this option?

I'm supposed to create few reports and execute in daily and monthly basis. So which option should I use?

|||If you use a shared datasource then you don't need the overwrite option. If the data source is not shared and you are constantly redeploying it then you want to use the overwrite option.|||OK I understood..Thanks lot

I found the anwer for second question too. If I make snapshots, I can not select impersation option.

Thanks lot

No comments:

Post a Comment