I was asked to provide a solution to launch an SSRS report from SQL Server 2008, without using SSIS. I need to build the report string dynamically (that part I can handle) because I pass in parameters. The Link is supposed to export the report to pdf...it looks something like this once the string is built:
Can I use xp_cmdshell or something to navigate to this link? If so, what is the syntax?