Crystal Reports Formula Help

[PotatoOfDoom]

Greetings,

I'm a relative newby to Crystal Reports. Specifically green when it comes to writing CR formulas.

I'm currently using Crystal Reports version 8.5 and a SQL database, ODBC connection.

I'm working with two tables.

1. Zone (location) information
2. Order information

What I want to do is write a report that will give me the distinct count of orders from and to all zone combinations in our database.

EG.
Zone From Zone To Count
101 101 5
101 102 12
....
280 300 22

I hope this is enough information to start.

Any information that would point me in the right direction would be much appreciated.

Thanks!

 

[lbass]

You don't need a formula for this. Insert a group on {Zone.From} and then insert a second group on {Zone.To}. Drag the group name from Group #1 into the Group #2 Header, and then suppress the Group #1 header and footer. Then place the {Order.ID} (or the equivalent) field in the detail section and right click on it and insert a summary->distinctcount at the Group #2 level. Drag the result into the Group Header #2. Then suppress the detail section.

-LB