Crystal Reports for Peachtree

[computerkathy]

I am using Peachtree Accounting system to pull my data from in Crystal Reports.

I need to roll- up some of my account numbers. For example, I want all 4101 ,4102 etc to roll up into 4100 account number. How can I do this?

 

[synapsevampire]

Group on a formula containing:

left({table.accountnumber},2), or whatever it's called.

If it's a numeric, use:

left(totext({table.accountnumber},0,"&quot,2)

-k

 

[dgillz]

Create a formula field:

@RollUpAccount
truncate({accountNumber}/100)*100

This should return 4100, 4200, 4300, etc.

Then group on this formula field.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com