Skip to Content
0
Former Member
Aug 22, 2013 at 04:36 PM

Crystal Reports: Join 2 columns to display in one row and also count them

470 Views

I have two columns in a table and need to display as one row.Also I wan to count them.

Table - T1

Col1 Col2 Col3
------- ---------- -----------
Accounts OH, completed by u1;CA,completed by u1;NC completed by u1 IL,NY
Policies OH, completed by u1;TX,completed by u1; null
Misc AL, completed by u1;CA,completed by u1;NC completed by u1 DC,MA

I need output in report as

Department
-------------------

Details a: Accounts
Details b: OH,CA,NC,IL,NY
Details a: Policies
Details a: OH,TX
Details a: Misc
Details a: AL,CA,NC,DC,MA


Report footer: Count: 12 (count of all above states (details b)for the departments mentioned)

Please help me in this. Appreciate anybody's help. Thanks in advance.