Using Range in variables
Posted: Thu Feb 22, 2024 6:04 am
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?
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?