CROSS - TAB

[longfellow]

hai all
I am having lot of problems using cross-tab . Especially when it comes to rows and columns . Its like i have some curves for which i have to display concentrations, slope , intercept and correlation coefficient my table should look like this in the end output
____________________________________________________________
SNO ID A B C SLOPE INTERCEPT R2
____________________________________________________________
S1 C1 0.0942 0.0852 0.0852 10218.1 6336.43 1.000
S2 C2 0.0897 0.0822 0.0565 10541.1 6745.43 1.000
S3 C3 0.0830 0.0748 0.0656 10348.1 9943.43 1.000
S4 C4 0.0942 0.0655 0.0785 10414.1 1033.43 1.000
S5 C5 0.0912 0.0825 0.0854 10515.1 1079.43 1.000
S6 C6 0.0852 0.0755 0.0568 10416.1 9878.43 1.000
S7 C7 0.0765 0.0818 0.0758 10378.1 1010.43 1.000
S8 C8 0.0818 0.0825 0.0586 10258.1 6556.43 1.000
____________________________________________________________

can i get this sort of output using cross tab? All values are retreived from tables in database?
What should i put in as Add rows and Add columns?
What columns should i set summarize on?
How do i eliminate Totals from being repeated?
I need help regd this very urgently

Thanking you in Advance

Longfellow

 

[chelseatech]

A crosstab is a wonderful object for analyzing a big chunck of data. But the one rule that applies to each Crosstab is that every record is analyzed into ONE ROW/COLUMN location on the report. You are wanting a record to appear in several columns.

In fact your report is a column/row summary report where each column is a different formula. If you have a mathematic way to calc your columns, use summaries and formulas.

A crosstab will not solve your requirements, but another technique will. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[longfellow]

what is the technique Can you give an example

Thanking you


longfellow

 

[chelseatech]

Can you explain how the first three columns are calculated?

What version of CR are you using? Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[longfellow]

I get all the values directly from a table in the database. They are calculated and stored in it. I am using Crystal Reports Version 7.0

Thanks

Longfellow

 

[chelseatech]

In that case just put the fields in seperate columns across the page. No crosstab or analysis is needed. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm