So I want to show a variable prompt in Preview. I would like to allow user to specify a From and a To value.
I use the Range type. In the Init By, I use an Expression. And I specify my table field in the From and To (did this by picking from the field list).
I turn on Request from User and Allow User values (tried with this off).
When I Preview the report, I get 2 textboxes for the From and To. But I want to have a drop-down list of values from the field that I attached to (I assume that was the purpose for me to set the Init By).
Any ways to get what I want?
Using Range in variables
-
- Posts: 6337
- Joined: Tue Mar 20, 2018 5:34 am
Re: Using Range in variables
Hello,
Unfortunately, for the Range variables, it is not possible to show lists.
You can use two List variables instead.
Thank you.
Unfortunately, for the Range variables, it is not possible to show lists.
You can use two List variables instead.
Thank you.