Saturday, February 25, 2012

DisplayGroupTree Format?

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.You could use a formula to convert it to a string and group on the formula.
e.g.

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

No comments:

Post a Comment