0

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?

Siyual
  • 16,415
  • 8
  • 44
  • 58
Dexter
  • 337
  • 1
  • 3
  • 12
  • If the report is being deployed in two different places, why not just make two different reports? – mituw16 Aug 11 '16 at 18:05
  • It saves so instead of editing two files and deploying them separately, I can edit one file and deploy that one twice. – Dexter Aug 12 '16 at 19:12

1 Answers1

1

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.

Scott Mildenberger
  • 1,456
  • 8
  • 17