Can I do it?

[TTA23]

I have a table that looks like this”
Category/Weight/Location/Qty
PEAR .78 100 5
PEAR .78 110 1
PEAR .78 130 2
ROUND .80 100 2
ROUND .80 130 1
MARQUISE .78 100 1
MARQUISE .78 130 2
MARQUISE .78 140 1
MARQUISE .80 100 1
MARQUISE .80 140 1


I would like the report to look like this when I read the data:

Weight Locations Totals
PEAR 100 110 120 130 140
0.78 5 1 0 2 0 8
Totals 8
ROUND
0.8 2 0 0 1 0 3
Totals 3
MARQUISE
0.78 1 0 0 2 1 4
0.8 1 0 0 0 1 2
Totals 6



The locations are fixed to 100/110/120/130 and 140. When there is no information for one specific location, I need to see 0 as a qty.

Can I do this, and where should I start. I can easily, if necessary, add information to the table.

I am using Crystal XI reading MS Access.

Thanks for any hints on this problem I have.

 

[kenhamady]

You could use either a cross-tab or a manual cross-tab. If all 5 locations will always have at least one number in one row you could use a regular cross-tab and it would be simpler. But if a location might have all zeros for every row, then you will need to create a manual cross-tab like this:

Group by Category, then by weight.
Create 5 formulas that are like this:

If {location} = "100"
then [weight]
else 0

Put these formulas on the detail band (hidden) and do subtotals and grand totals of each formula.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/

 

[TTA23]

Thanks- I will try this tomorow.