@Variable question

[txwylde]

You know when you create a prompted @variable for start dates, like date(x_log_sale.dt_occurred) BETWEEN @variable('1. Enter Start Date:') AND @variable('2. Enter End Date:')

If I wanted to reuse that @variable in a where statement, what do I have to do? If later on I wanted to go back and set up a where statement where the date was = @variable, what is the syntax for that?

Thanks!
Bill

 

[Sridharan]

Do the normal selection of the Object and the Relational Operator and then instead of creating a new prompt jus select show list of prompts and it will list all the currently defined prompts. Just select the required prompt.

Sri

 

[Subhashab]

you could create objects in designer with the @promt clause.
for example
<start date> with defintion
@prompt('!Enter Start Date','D',,,)

and then reuse the object in your where clause where ever u want.

 

[skrandel]

Keep in mind that you can't use the date in a REPORT-level Where statement.

Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group

http://www.knightsbridge.com

 

[Subhashab]

I mean where clause in the DP and not at report level