I am using sql server 2000 and crystal reports 9.0.
I have a stored procedure than generates a table that looks like the following:
Region User Type SummaryField
North Robb A 10
South John B 4
I would like a pivot table in Crystal that does the following:
Creates a header by Region
Then in the details groups all users in that region
Pivots the type as column names
The row data is the summary field listed under each column(type)
Then has a footer with a another total
My problem is I cant seem to get the pivot to allow me to work in both the header and the details section of crystal...its only allowing me to create this functionality in the header region..which is causing this to look very jumbled...
Any ideas on how to accomplish this task would be very appreciated.