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.
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