HOW TO FILL TABLES SEPARATE in crystal report

[former_member1263774]

hello im freasher in Crystal Report,

Im facing one problem that ,

I have two tables with data 1.employee 2.Purachse order

two employees are there

purchase order comes in three types A,B and C

so i need to see the count of A,B,and c for each employees.

lets say

EMP POcount type

Abi 2 A

1 B

0 C

Bibi 5 A

0 B

1 C

Like this how could i do this

[abhilash_kumar]

Hi,

1. Insert a Crosstab

2. Use the Emp Field as the Row and PO Type field as the Column

3. Use the PO# field as the "Summarized fields" and set the summary function to "Distinct Count"

-Abhilash