Jim Metcalf
asked on
question about variables in ssrs
Parameter configuration in ssrs. The dataset is configured with a normal query joining two tables. At the end of the dataset is where i have a question. it includes a where and "and" statement
Currently it is configured like this
Where a.rescode = ''
and a.adddttm > @conversion - This is a date field
How to i configure the variable to be one of the two choices instead of always Greater than (user supplied date)
Where a.rescode = ''
and A.adddttm > @conversion
or
Where a.rescode = ''
and a.adddttm < @conversion
Currently it is configured like this
Where a.rescode = ''
and a.adddttm > @conversion - This is a date field
How to i configure the variable to be one of the two choices instead of always Greater than (user supplied date)
Where a.rescode = ''
and A.adddttm > @conversion
or
Where a.rescode = ''
and a.adddttm < @conversion
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER