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.)
Hi Anne,With each version's installation files, we include .RDL files for all standard SSRS reports along with some samples and tools to aid you in customization. As a hosted member, you don't generally get to see those files. You can download the files for the latest 15.2 from the 'Installation and Upgrade Files' tab on this page:https://www.tessituranetwork.com/Support/Documentation/Tessitura-v15_1
Or, here's a link to a .zip file of just the report files to get you started (edited to provide correct link):
https://tessituranetwork.box.com/s/f2pyr48tbydgghq5jydn7xn3tx163ccv
Regards,Brian PedaciSenior Technical AnalystSupport Escalation
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.
Thank you! I knew I had to be missing something.
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.
I downloaded the files and I can access the folder via SSDT, but I can't see any of the files when I try to open them. They are there in Windows Explorer, but when I go to open a project/solution, the only file type options are:
It isn't recognizing any of the .pbl files, which is what I think I need to get at the standard report I'm looking for. I watched a webinar from 2020 on custom reports yesterday, so I'm not sure what I'm missing here.
If it's a .pbl then that's been built in Infomaker and won't be available via SSRS.
Anne, I am SO sorry. In my haste, I grabbed a link to the InfoMaker sample library, not the SSRS standard report collection.Can you please try this one instead? It should have a set of subfolders that match the standard report folders. Each one then has a set of .rdl files for SSRS setup. tessituranetwork.box.com/.../f2pyr48tbydgghq5jydn7xn3tx163ccv