Passing a Date Parm into pass-thru SQL query within Report Studio 10.2.1

[CharlesAZ]

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

[bdbits]

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.