I am working on an XI R2 Webi report over SQL Server 2005.
I have a need to enter a Start and End date prompt, but these prompt values will be used to filter several dates in the query.
At the moment I have 3 start dates and 3 end dates - all start dates are likely to match and all end dates are likely to match.
Is it possible to Add 2 prompts - Start Date and End Date and then pass the values entered to the underlying query?
I am sure that it is possible and I am probably missing something obvious, but just can't seem to figure it out.
Many thanks.
Justine
I have a need to enter a Start and End date prompt, but these prompt values will be used to filter several dates in the query.
At the moment I have 3 start dates and 3 end dates - all start dates are likely to match and all end dates are likely to match.
Is it possible to Add 2 prompts - Start Date and End Date and then pass the values entered to the underlying query?
I am sure that it is possible and I am probably missing something obvious, but just can't seem to figure it out.
Many thanks.
Justine