Using sub reports

[Roncayenne]

I am using CR8.5 on an Oracle9i d/b. I haven't used sub reports so don't know if this is what I need.
The report suppose to look like a spread sheet for multiple organizations.

Class Gender Caucasian AfroAmerican Hispanic Other
AORgn Code Male 10 15 5 2
Female 20 25 5 0

BOrgn Code Male 2 2 0 0
Female 0 5 2 2

The info is in a table like
orgn
ethnic code
gender
I can get a count and print a report vertical but not like above. Any suggestions would be appreciated!!
Thanks!
Ron

 

[Madawc]

I think you need a crosstab. Create a key that is orgn + gender. Cross-tab this with ethnic code


Madawc Williams
East Anglia, Great Britain

 

[Madawc]

A subreport is an independent report that is started by your main report and can access different data, or the same data in a different way. Not relevant to what you are trying to do.

Madawc Williams
East Anglia, Great Britain

 

[Roncayenne]

I am new to CR so haven't had the time to try different things until it comes up. (Probably like alot of folks!)
I just looked up cross-tab and this looks like what I need. I'll see if I can get that going.. You saved me alot of time pointing me in the right direction. Thanks for your help!

Ron

 

[Roncayenne]

Hve to tell ya... I just did the report using cross-tabs and it worked great. Have to tune it a little but its fine. Thanks for the help and info!!

Ron

 

[DataDivaJill]

also formulas are handy
jill

 

[Roncayenne]

Jill,
Not to take up too much of your time, could you just give a sample of what the formula would look like?
I am familar with PL/SQL and 'C' prog. I was wondering how you would do this in 'code'. Thanks in advance!!

Ron