Limit columns in a cross tab up to 10

[Shukhrat]

Hi everybody,
I have 20 rows (say patients) and 15 columns ( say tests). The number of rows/columns can change.I want to put in one cross-tab , all 20 rows (patients) with columns (tests) up to 10. The next 5 columns and the 20 rows should be displayed under the first cross-tab of 20 rows/10 columns.
On the bottom of each cross-tab I need to display statistic comparison between row/column (patients /tests).

Test1 Test2 ................ Test10

Patient1 0.04 1.56 .................. 3.56
Patient2 2.45 4.34 ................... 4.67
|
|
|
Patient20 3.66 3.45 ................... 3.79
_______________________________________
Avg( ) Avg ( ) ................ Avg ( )


Next Cross-tab on same page:

Test11 Test12 ................ Test15

Patient1 0.24 6.56 .................. 6.56
Patient2 3.45 9.34 ................... 3.67
|
|
|
Patient20 6.66 8.35 ................... 6.79
_______________________________________
Avg ( ) Avg ( ) .................. Avg ( )


Thanks in advance

 

[Crystalguru]

Sukhrat,

Sorry to be the bearer of bad news. Since you are going to need averages in your report, you won't be able to do a Crystal crosstab, unless of course, you are doing your averages in a View/Stored procedure. Otherwise, you will need to do a manual crosstab. See the FAQ section for directions on how to do this.

Secondly, you may have to create a main report with manual crosstab with first 10 test. Then create a subreport with manual crosstab and the remainder Test.

This is just my initial thought on your problem.


crystalguru

 

[Shukhrat]

Crystalguru,
Thank you.
but few problems:
1.unfortunatle, on back-end MS Access 2002.
2.I don't know tests name. user can insert any name and any number of tests. in manual crosstab I'll limit not only col. number, patients number will be limited too. I need show all 20 patients in on cross-tab.

Thanks again.
Shukhrat