Crosstab formatting 1

[dday01]

Hi All,

I have a crosstab and it is in the following format:

The two values are Clients Served and Number of encounters.

Male Female
Contract 2 3
5 6

I want it to format like this instead:

Male Female
Contract 2 5 3 6

It seems that in design view you are not allowed to move the values aroun within the column, I have tried every which way to do it. I'm stumped! Any help would be greatly appreciated.

Thanks,

D

 

[lbass]

I think you have to use a manual crosstab to do this. First group on {table.contract}. Because you will get repeat values for gender with multiple encounters per person, I would use running totals to get the summaries. For gender, select {table.contractID}, distinctcount, evaluate based on a formula: {table.gender} = "Male"
Reset on change of group (contract). Repeat for "Female."
For encounters, use the same field in the running totals, but use a count on {table.contractID}, instead of a distinct count, and again add in the formula for gender.

Now you can place these anywhere you want in the contract group footer (not header), and suppress the details.

-LB

 

[kenhamady]

No way to do this in v8.5, but this is an option in v9.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[dday01]

Thank you both for your responses, I am having IT find a version 9.0 for me and hopefully I am able to move the fields side by side. (very frustrating trying to do something that the software does not allow!)

Thanks again

D

 

[lbass]

Just a comment--Ken's comment was about using an "automated" crosstab--you can still do a manual crosstab in 8.5 as I outlined above.

-LB

 

[kenhamady]

Lbass is correct, a manual cross-tab would allow this. I have a description of the formulas needed on my FORMULAS page.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com