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
Anne,
You should have access to a Tessitura standard report called "Report Manager". That is where you will download and save the RDL file for the existing reports.
John A. Moskal II
Thanks, John. I have that, but when I open it all I can see are my custom reports:Am I missing something right in front of my face?
Anne
Yep. Not sure why you are missing it, but you should see another option there that probably just says "Tessitura". Might need to open a ticket for that. (Tessitura_reports is our custom folder.)
Aren't you a hosted client? If so, do you have access to SSDT (you referred to Visual Studio). If so, you should see a Tessitura_Custom project when you open SSDT. You should see reports in the Solution Explorer. You can easily make a copy here and begin working on it.
We are hosted and Tess publishes the SSDT instances for al three of our environments - DEV0, TEST and PROD in our Citrix Storefront, so I have never worked in SSRS to develop a report. This will show you all of your reports and you can browse out to the RDL's (not sure what folder they are in but it sounds like you know where to find them on the server). Once it's open in SSDT you can easily add the parameter you need and update the RDL.
Hope this helps.
Yes, I mean SSDT. It looks like I have to install some files (see comment below). I have the custom project, but it only had my existing custom reports, not any of the standard reports, which is what I need.