Click to See Complete Forum and Search --> : DisplayGroupTree Format?


mrathi
July 7th, 2006, 01:02 PM
Hi, I have a report in which I have created a group. The grou field is an integer in the database. I could format the groupname field on the report to display it without any decimals.
However, when I bind the report to a viewer on windows form, the displaygrouptree diplays the group name with decimals. For ex:, the report displays 2000 and the displaygrouptree displays it as 2000.00 How can I make the displaygrouptree to display it as 2000?

Any suggestions are greatly appreciated.

Thanks.

JaganEllis
July 9th, 2006, 07:39 PM
You could use a formula to convert it to a string and group on the formula.
e.g.

totext({table.field}, 0, '')