what is way to do this

[lynchdog]

I've been asked to write a report against a transactional database which is made up of 3-7 transactions.

TRANSTYPE STATUS
--------- --------
68 SUCCESS specific data for this transtype
71 MATCH specific data for this transtype
76 SUCCESS specific data for this transtype
77 503 specific data for this transtype

Each transaction has a specific transtype and a set of status codes that go along with it. Also attached to each transactions is information such as address, name, etc.

What is the best way to try and report against this. In the past the developers had programs that formatted all this data into one big transaction. Any help would be appreicated.

 

[IdoMillet]

You can insert multiple detail sections and format each for a specific transaction.

Then, suppress (using an expression) all sections except one according to the transaction type.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com