Hi, I am using CR XI and a OLEDB connection. I want to use a Parameter Field allowing multiple, discrete and range values. Now I am facing a small issue with the range:
[ul]
[li]If I select the range: Rows 1-9 from an offer request - I get rows 1-16 (all rows)[/li]
[li]If I select the range: Rows 1-10 from an offer request - I get rows 1 and 10[/li]
[li]If I select the range: Rows 1-3 from an offer request - I get rows 1-3 and 10-16 (all rows)[/li]
...and so on. However, adding values 1, 3, 6, 7 works.
[/ul]
The database field is a string value and therefore I need to have the Parameter type: string
The report does fetch the row numbers via the database field and I have added the same Value field to the Parameter.
Hope there is an easy fix for this
[ul]
[li]If I select the range: Rows 1-9 from an offer request - I get rows 1-16 (all rows)[/li]
[li]If I select the range: Rows 1-10 from an offer request - I get rows 1 and 10[/li]
[li]If I select the range: Rows 1-3 from an offer request - I get rows 1-3 and 10-16 (all rows)[/li]
...and so on. However, adding values 1, 3, 6, 7 works.
[/ul]
The database field is a string value and therefore I need to have the Parameter type: string
The report does fetch the row numbers via the database field and I have added the same Value field to the Parameter.
Hope there is an easy fix for this