Use a parameter multiple times in a union query

Hi,

I have a union query which takes 3 parameters as input from user (From_DATE, To_DATE and Company_name)

I want to use these values in multiple places in my union query. Please let me know how to achieve it?

Thank you.

Regards
Ramji S

Find more posts tagged with

Comments

bhanley

When you setup the actual query text, you will use a question mark (?) for each place a parameter should be substituted. Then look on the "Parameters" group on the Data Set editor. There you will bind each instance of a question mark to a value; likely a report parameter. You can re-use a value for different bindings without any issue at all.