Business Objects Infoviewer

[BobBob10]

I am using Crystal 11 and I am able to view my reports via the web using Infoviewer. On the viewer, at the side of the report, where there are groups, my numbers are displayed as two decimal places where as on the actual Crystal report the numbers are rounded.

Does anyone know why this is happening and if it can be solved?

 

[kskid]

We have the same problem here. The report looks fine using Crystal XI but in InfoViewer, the values shows up with decimal precision of 2.

You can either

change the numbers to text before grouping. If the numbers had different lengths, then we left padded with zeroes sot it would sort right

or

Create a formula the replaces the group number with text

-lw

 

[VICKEL1]

I have had the same problem and I used a formula such as:

If Instr(1,cstr({field1}),".") > 0 Then
formula = left(Totext({field1}),len(Totext({field1})) - 3)
End if

to get rid of the decimal places. However, when you have more numbers (grouped) e.g. 101, 6 the numbers do not sort properly as these numbers are now text. Also, the thousand seperater is still there, is there any way of getting rid of this?

any help would be appreciated.