what would be the best way to do this report?

[yehong]

I am stuck with this report since last few days. I would appreciate if someone could give me an idea how would this be best done.

Right now all I have is theory.

Report is supposed to show Gender,Avg Current_Salary, Avg Past Salary,Current Ranking,Past Ranking.
Exp of Report layout: Two groups Ranking and Gender.

Ranking Gender Cnt Avg_Cur_Sal Past_Sal
--------------------------------------------------
1
Males 10 $3000 $2800
Females 12 $3050 $2600

2
Males 05 $3500 $2700
Females 03 $3000 $2900

3
Males 07 $3500 $2700
Females 09 $3000 $2900

As you can see I have two rankings types, Current Ranking and Past Ranking. Now when I group the report with Cur Ranking, all data appears for Cur ranking only. If group it by Past Ranking,data appears for past ranking only.
I tried creating sub reports for cur and past ranking and putting those subs on an other report, but not exactly sure which section to put those sub reports.
I hope this will help understand this problem.

Thanks,

 

[nagornyi]

Could you please specify which tables are involved here and what the fields are?

 

[Madawc]

if you want the data for current and past rankings, and these are different records on the same table, you probably do need to use a subreport and put it on your detail line. It is a slow method but does work.

As nagornyi says, you need to tell us where you get the data from. Also the version of Crystal you are using, since later versions include new options.

Madawc Williams
East Anglia, Great Britain