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
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.
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.
Thank you! I was able to fix that. And I had my shared data source spelled wrong. Ha! But after deploying I don't see the report in security to grant access to it.
Did you setup the report and the parameters in the application:
I had missed that step. I set it up, using the standard report as a template and added in my additional parameter. But I'm unsure what to use for the File Path. When I look up the file path for the report in Visual Studio in Test, it is showing me what looks like a Prod file path
The parameter window opens, but it isn't finding the report.
Thank you for all of your help on this!
Anne
If you have another custom report in Test that is working, I would open the settings and take a look at the report path there, and then just replace the .rdl name.
Strangely enough, there is no path, just the file name. But that isn't working. Oh well. I'm going to step away from this for a bit and revisit next week. Thank you again for your help.
I just noticed the report type from your screen shot. It should be SSRS Custom. Hope that works it out for you. Have a great weekend!
It can find it! Now to fine tune, because something is off in the report itself. THANK YOU!!!!!!
Seconding to make sure SSRS Custom is used. And usually that takes care of the file path for me; I never need to put anything there besides the file name.
It worked! I'm waiting on the person who requested the report to test it and let me know if she is getting what she's expect. The only thing that seems a bit off is this message at the top of the report. But the body of the report appears to have run correctly. It just isn't displaying the parameters, I think. Is that something I need to update in the stored procedure?
Do you have the report parameters RDL in the body of your report? I usually have it at the top right below the report title.
I believe so:
This error means that the sub-report couldn't be found.
You can go two ways to fix this: download a copy of the canned ReportParameters.rdl and add it to your custom project and deploy it, and then make sure your sub-report is pointing to that report.
Or you can go into the sub-report and point directly to the canned ReportParameters rdl in the canned folder. If you're on v16 there are a few different canned parameters reports to choose from, and if you're on v15 you may want to revisit those options as you upgrade to v16. At any rate, to include the canned RDL, change the sub-report to:
../Tessitura/Reports/Common/ReportParameters
Good luck!
Thank you! It looks like my ReportParameters.rdl was pointing to the wrong data source. I fixed that and deployed it, but it still isn't working. This report is a copy of a standard report with one parameter added, so I'm not sure why it isn't working. I'm not sure what you mean by sub-report -- this is my first try at a custom report -- or where I point to the parameters rdl. We are still on v15.
A sub-report is just an object on the RDL that calls another report, in this case the Report Parameters report. Here's a custom report of mine with the sub-report object in gray:
If you need any help I'm happy to hop on Zoom or Teams to help you get this running!
Got it! and it works. THANK YOU!
Yay! Congrats!
Yay!!!!! I have loved reading this saga and watching the learning. (though I know how frustrating it must've felt for you at times. Reports are not the easiest thing in the world)