Jasper Report and Value List

Classic Servoy
1

Hi

I’m using jasper plugin and Ireport for my reports.
I have some fields with custom valuelist ( for example: Real Values 1;2;3; Display Values: EURO;US DOLLAR; YEN; )

If I pass my foundset to the plugin and I have a field in Ireport called like the real field in my table ( for example “currency” ), in the report i can see 1 or 2 or 3 intead of EURO or US DOLLAR or YEN.

In there something like servoy custom value list in ireport? Or how can I see the display values of my custom value list?

Thank you!
Bye
Roberto

2

So you are using custom values? You probably need to base your ValueList on a database table that contains a column for the index and a column for the descriptive text instead.

3

The example is not properly a real example.
I know that work with a relation but if I have a custom value list there’s no solution?
Thank you for answers
Roberto

4

When using foundset you can define a calculated field on that foundset which returns the right value list display value.
Or if the value list real values are 1,2 ,3… and not to big you can transform it to a java.util.ArrayList and pass it as a parameter to your report.