CODEWITHSUNDEEP
sqlreporting-servicesssrs-2008-r2
Dexter
Dexter

Reputation: 347

Can an SSRS report be aware of its filepath?

I'm working on SSRS reports and I'm trying to dynamically change the SQL based on which folder a report is in. The same report will be deployed into two folders but the SQL needs to be different based on the folder. My thoughts is that if I can access the filepath of a report I can alter the SQL based on the filepath. Is there any way to access the filepath within a report?

Upvotes: 0

Views: 43

Answers (1)

Scott Mildenberger
Scott Mildenberger

Reputation: 1597

You can create a query parameter that is set to the Report Folder [&ReportFolder].

You can pick it by clicking the Function button and choosing it under Built-In Fields.

Upvotes: 1

Related Questions