Jump to content
Changes to the Jaspersoft community edition download ×

Maintain numeric type w/ currency formatting?


Recommended Posts

By: swedegeek - swedegeek

Maintain numeric type w/ currency formatting?

2006-05-17 07:06

I have several reports created that output various dollar amounts. I have them set as BigDecimals in my jrxml with formatting of "$#,###". The users would like these reports in Excel so they can easily manipulate/sum/sort/etc. the data after the report has been generated. However, with the above formatting, Excel ends up converting the dollar amounts into text fields that can no longer be easily summed or otherwise operated on as a number.

 

Is there a way to apply the currency formatting I'm using and still maintain a Numeric type in Excel? Right now, I have to remove all formatting in order for the numeric type to stay in Excel, so I'm hoping there's a method to get around this. Thanks in advance for any assistance!

 

-BN

 

 

 

 

By: swedegeek - swedegeek

RE: Maintain numeric type w/ currency formatt

2006-05-18 04:52

Anyone have any ideas on this one? Is what I'm asking about even possible??

 

 

 

 

By: Ionut Nedelcu - ionutned

RE: Maintain numeric type w/ currency formatt

2006-05-19 00:50

The JasperPrint object resulted after report filling does not contain any data type information, the computed textfield values are just stored as strings. Thus, the excel export cannot convert the appropiate values to their original types.

 

Ionut

 

 

 

 

By: swedegeek - swedegeek

RE: Maintain numeric type w/ currency formatt

2006-05-23 13:14

Thanks much for the reply, Ionut. Just to be clear, this means Jasper canNOT force a data type in Excel, correct? In any case, I now know what I need to do to make my users happy... for a little bit, at least... ;)

 

 

 

 

By: swedegeek - swedegeek

RE: Maintain numeric type w/ currency formatt

2006-05-30 10:47

One more attempt to confirm... Jasper can NOT force an Excel data type to be used instead of the general type. Is this correct?

 

 

 

 

By: Ionut Nedelcu - ionutned

RE: Maintain numeric type w/ currency formatt

2006-05-31 01:01

This feature implies a lot of problems, so for the moment it is impossible.

 

Ionut

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...