Greetings!
Is it possiable to pass a parm that can be used to filter data within a Pass-thru sql query within report studio. The report has other queries that are not a pass-Thru query that are using a Date prompt, the same prompt/date I needed to be passed within the SQL of the pass thru SQL query, is this possiable if so how?
Thank you in advance for your consideration!
Charlie
A #prompt() macro would probably work, but why are you using pass-thru queries? There is almost never a reason to do so. And if you do bury the prompt macro in a query, I can see that being a maintenance headache for some poor soul who has to maintain your report and figure out what you did after you've moved on to something else.