Click to See Complete Forum and Search --> : Crystal Report Cross Tab Report summary column


jkmarvelmani
July 11th, 2008, 11:42 AM
I have the table data like this

Project Type Sub_Type Count
IT-Project Web C# 2
It-Project Web Vb.net 3
IT-Project Windows C# 5
IT-Project Windows Vb.net 8
Maintanence Windows C# 10
Maintanence Windows Vb.net 6

I need the report that should be like this
Web Windows
IT-Project C# - 2 C# -5
Vb.net-3 Vb.net- 8

Maintenance - C# -10
Vb.net-6

That is I need "Projects" in Row wise and "Type" as Column wise. The summary should be the combination of "sub-type" and "Count" Column.

How I can get it in Cross Tab. I tried like this in cross Tab.

Rows – Project
Columns –Type
Summary columns – {SubType +”-“+Count}

But I did not get the desired output. The Project, Type and subtype will be increasing…
Please anybody help me.
Please check the attachment