I am using SQL Server 2012 Standard Edition and create my reports in SSDT (VS 2010). I have created hundreds of drill through reports without any problem but they are always in the same folder and same server.
How do I specify the report in SSDT if it I am going to deploy it to a different folder of the same report server? Let's say that under the HOME folder I have deployed a report to a folder called Sales/Products. The main report is in that folder but a drill through report is in Sales/Employees folder. Using a report in Sales/Products can I drill through to a report in Sales/Employees? If so, how?
I have tried identifying the report by a path but it doesn't accept "/" or "\" when specifying a report.
Thanks for your help.