Preview Pane, formating of....

[Lanie]

Hi All,
Well I have a user who wants to see the items listed in the preview pane in a specific manner. They do not want to see the comma's and decimal places, just the whole number.

I've formated the field on the report with no comma, no decimal places, but the preview pane still shows with them.

Any ideas as to what I need to do for this user?

Thanks in advance for your help.

Lanie
laniet@ij.net
etroidl@conaxfl.com

 

[Reebo99]

I have had this problem inthe past, and to get around it I converted the number on the report to a string,
totext(mytable.numberfield,0,"&quot
then based my groups on this formula.

Hope this helps.....

Reebo
UK