maual cross tab

[unknownly]

Using CR 8.5, Iam do a manually corss tab using 2 fields customer, pets

grouped by customer and written formulas to check what pet it is like

@Dogs = {table.pet} = 'DOG'
@Cats = {table.pet} = 'CAT'
so on and inserted summary field on these changing to count but it shows total count for each customer... Can you tell where Iam doing worng...
I need my report to look like below....I doing manuall corss tab beacause it shows only for what pets are available in databse.


customer Dogs Cats Birds Rabits Total

Name1 2 1 0 0 3
name2 1 0 0 1 0
name3 3 0 0 0 3
name4 0 3 1 0 4
Total 6 4 1 1 10

Thanks in advance,
Sweetie

 

[Jcfx]

Are you inserting your formula's at the detail level and do they look like this?:

//@Dogs
if {table.pet} = 'Dog' then 1 else 0

Which you are then inserting a count summary on at the Customer group level?

Julie
CR 9,10 CE10 Sql DB

 

[unknownly]

Yes that is what Iam doing. But get them wrong.

 

[lbass]

You should be inserting a sum, not a count, on formulas like Julie's. A count of a formula will equal the number of times the formula executes.

-LB