display groups horizontally

[syamgumpalli]

hi!

i have salary table with fields empid, salary_type(A/D),salary_name(HRA,DA,TA...).

when i group my report by empid and then by salary_type i am getting my payslip as

empid

salary_type-1

salary_name-1
salary_name-2
-------------

slary_type-2

salary_name-3
salary_name-4

i want the groups to be displayed horizontally like this

empid

salary_type-1 salary_type-2

salary_name-1 salary_name-3
salary_name-2 salary_name-4

thanx n regards,
syam gumpalli

 

[IdoMillet]

Insert, CrossTab... )

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

http://www.MilletSoftware.com

 

[HowardHammerman]

Group only on Employee ID
Suppress the details section and the group header section
Insert a cross-tab object in the group footer section

Use salary type as the row element and salary name as the summary field. Howard Hammerman,
Editor and Publisher of Database Reporting Made Easy newsletter
howard@hammerman.com

http://www.hammerman.com

800-783-2269