Cross Tab Report of more than one column and sub-column

[maulae]

Hi there, I am using Crystal 10 with SQL server db and having problem in creating Cross-tab report. If someone give me the solution either with Cross-tab or without Cross-tab that would be highly appreciated, here is my problem,
I have five fields in my table’s each row i.e. CompanyName, Department, EmployeeName, Rate, Salary. Each employee may be worked in more than one department up to 5, I want to present this information in such tabular form that’s group by Company then each row’s first column show the employee name and then related department names in 2nd, 3rd, 4th and 5th columns depends how many are the record. Further more I want to divide each department in related employee’s Rate and Salary. I need detail of each record and may be columns summary for salary.
Thanks..
Maulae

 

[Madawc]

In Crystal 10, you can put several fields in a 'cell'.

If that's not the answer, you can create a 'mock crosstab', consisting of a number of Running Totals, each of which has to be tediously defined. (You can save a little time by doing a paste to a dummy report, changing the name + logic and pasting back.)

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[maulae]

Hi Madawc, Thanks for your response, I am not very much familiar with mock cross tab, can you explain little more, I explain my problem more detail what I need
Company 1
Employee Name Department 1 Department 2 Department 3
Rate Salary Rate Salary Rate Salary

David $30 $800 $35 $900 $25 $700
John $20 $700 $32 $750 $25 $700
Mike $28 $600 $30 $800 $15 $500

In table data all information in same record i.e. CompanyName, EmployeeName, Department, Rate, Salary.
I appreciate your time.

 

[Madawc]

You should have examples given along with the software. Look under 'Crosstab'.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[XtraOrdinary]

I have a big problem while using crstal report , First I want to explaion my problem
City
Branch
Product
Complaint Type Complaint Statuses

For every city their are some branches , which have some products .Each product have differnet comlaint types and Each comlaint have 8 statuses.I HAVE TO SHOW COUNT OF THESE STATUSES.

Now i have place a records selection criteria , but the thing which is going wrong is it shows correct records when I enter one city one branch and so on... but if I add more than one cities It give me the same counts for each city
Second ,, I want to show a count of ZERO even if some record misses that condition..Pls reply

 

[Madawc]

Your job. You solve it. I've given you enough hints to be getting along with.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

XtraOrdinary, Please start a new thread. Madawc didn't even realize this was a different question.

-LB