View Single Post
  #1 (permalink)  
Old 06-22-2009, 12:44 PM
JBonavita JBonavita is online now
Junior Member
 
Join Date: Jun 2009
Posts: 4
Default Formatting a data field in a pivot table

We need to format the data fields in a pivot table as we create it.
I've trying:
FieldSettings fieldSettings = dataField.getFieldSettings();
NumberFormat nf = fieldSettings.getNumberFormat();
nf.setCustomFormat("#,###.##;;;");
dataField.setFieldSettings(fieldSettings);

But there resulting pivot table doesn't have any formatting applied.

Any ideas?

Thanks,
Joe
Reply With Quote