Viewer Group Numeric Format

I'm using CR 10 with VS 2005 Beta 2. A report is being grouped by a formula field: Year({vwVibAnalysisReport.Date}). When browsing the report, the years are formatted as: 1,999.00. I've tried using Fix, Truncate, Cstr, adding a leading or trailing space, etc. and I can not get the year to print as 1999. (Some of these attempts work while previewing the report in VS.) Is there somewhere that the format for the group-by can be set? Possibly a default numerical format for the report? Any other workarounds?

Thank you,

Andrew

[660 byte] By [DrewP] at [2007-12-16]

«« Cannot get remoting to work in IIS host
»» Web service forms authentication - n00bie

# 1

Hello Andrew,

I would try grouping on the date field {vwVibAnalysisReport.Date} and then setting "The section will be printed option" to "For each year".

If that is not possible then you can Format the Group Header field to the number format you desire. Right click on the header and select Format Field from the context menu.

Keith - Business Objects

KeithThomson at 2007-9-9 >