Input Controls on JasperServer Pro AWS Ad-hoc Views/Reports
Posted on May 6, 2013 at 8:18am
We have an column in our DB with values from 0 to 9 representing different statuses (ID_ACTIVE, ID_FAILED, etc).
I did a View/Report and I can add an input control to select which statuses I want, but only in numeric form.
I would like to use a custom input control in the form of a multi select list with the ID_XXXX values.
Is that possible in an ad-hoc view or report?
Joined: May 3 2013 - 6:51am
Last seen: 9 years 8 months ago
Posted on July 1, 2013 at 3:54pm
If the data type is numeric, then unfortunately you do not have the list-of-values filter operators. You could consider changing the source data type from numeric to varchar/text. Sorry I cannot think of a better alternative.
Mary Flynn
Jaspersoft
Joined: Sep 19 2006 - 5:43am
Last seen: 9 years 6 months ago
I have the same issue! Do we have an answer for this!?
Advance thanks,
VV Nagesh.