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
Thank you!
Ah! That fixed it! I don't see the report in the security application to grant users access to it.
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.