Hello! I have access to SSMS and to Visual Studio and I have a basic understanding of how to create reports. What I want to do is add an additional parameter to a standard report -- I don't want to mess with the standard report, so I'd like to create a copy, edit it and save it as a custom report. What I can't figure out is how to get at the existing standard report in Visual Studio to make a copy -- do we have access to the standard reports? I see a folder for them, but it is empty.
Thanks!Anne
I think it is time for a support ticket - when I open SSDT in Live it can't access my shared data source either.
Do you have the correct Connection Properties for your Data Source? Can you Test Connection?
I think it may be that it was set to using SQL Server Authentication rather than Windows. Thank you! I'll keep trying.
But now it seems that my Report Parameters is pointing to Live instead of Test and I can't find where to change the file location.
Your Data Source needs to point to Test so the Dataset is connecting to Test as well.
I think I'm really close! But when I try to deploy the report I get the following error message: Severity Code Description Project File LineError Cannot deploy the report because the shared data source '/Data Sources/ImpressarioDB' that the report references does not exist on the report server. P:\User Reports\SSRS Projects\Tessitura_Custom\Tessitura_Custom\bin\Debug\CurrentConstituentGivingbyList_Custom.rdl 0
I'm working in Test and my data source is pointing to test. I'm in Debug mode.
one more update -- it looks like it is trying to deploy to: http://histnousla0testa/ReportServer_HISTNOUSLA0. That "a" shouldn't be there after test -- but I can't figure out where I change this. The data source is pointing to the correct address.
You can change that in your Solution Property Pages:
Look in your configuration manager. Are you deploying to TEST? Check your Project properties - Project --> Tessitura_Custom Properties. Is the TargetServerURL correct? This is where you will find the URL.
The data source name has an extra 's' in it - it should be ImpresarioDB.