asked on

Crystal Reports 11 - Cross-Tab report

Hi,

I am trying to create a cross-tab report, but the output of the report is blank.
Below is my exact output of the SQL.

Emp_Cat 	Total_Emp_Months	Total_Employees
--------        ----------------   	---------------- 
            

Manager		400			15
Clerk		600			6000
Admin_Asst	800			60


My Report should look something like this:


--------------------------------
Total Employee Months : 1800
-------------------------------

Emp_Cat 	Total_Employees
--------        ----------------   	
            

Manager		15			
Clerk		6000			
Admin_Asst	60	
Total		6075		

--------------------------------------

First I created the formula for the total employee months (1800) sum({command.Total_Emp_Months})

Then I tried creating the cross-tab and made some changes in the cross-tab expert section.
I selected emp_cat in the Rows section and Total_employees in the Columns section, and selected total_employees in summary section.

My report is blank with no data in it, except for the text box information (Total Employee Months :, and the lines I drew on the rpt), all others are blank.
I am also not seeing the data for the formula I created.

Questions:

Do we need to use cross-tab on the first place.
If so how can I get this working.

Thoughts?

Thanks@

Open in new window

LinInDenver

I think all you need to do is display your Total Employees number in your detail section (or if you have multiple records per category, insert a group on Category and then insert a sum on your total_employees field).

You can then insert a summary on your Total_Emp_Months into your report header or footer.

D-pk

ASKER

I tried placing the cross-tab in the group header (Created group on Emp_cat) and in the rows option I gave the Emp_cat and in the summary field I gave the Total_employess leaving the columns field empty...
still no luck.. the output is blank...

Thanks@

ASKER CERTIFIED SOLUTION

LinInDenver

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial