Map DB values to strings

[topred]

Hi,

I've checked the documentation and forums but haven't been able to find an answer so far.

 

I have a database with an integer Status column. The Java code normally takes care of mapping the numeric value to a string value, such as 1="Ready", 2="In Progress", etc. However, I want to generate a JasperReport with the string values, not the integers. I'm using a JRResultSetDataSource for the data.

 

How do I perform this mapping? Thanks.

 

Bob

[topred]

Any suggestions? It seems like some of the options are conditional expressions, resource bundles, or parameters, but I expect someone has already solved this in an intelligent way. Also, I want to keep it simple when using iReports. Thanks.

 

Bob

[Teodor Danciu]

Hi,

 

I guess it is about: "where to store this relationship between numbers and texts".

Well, you already seemed to find some answers, which should work pretty good.

I like the resource bundle approach.

 

Otherwise you could just create an utility static method somewhere in your application that takes an integer and returns a string and use it in your JRXML.

 

I hope this helps.

Teodor