Help

[metalteck]

I'm trying to write a report in crystal, but I'm having the hardest time trying to figure out how to get the data sorted the way I want it.

I have a customer list:
Name Type Dollar
Bob B 100
Chris C 1000
Gus F 2
Rudy U 5000

What I basically need to do is First Group all the information by types, then group them according to dollar values. But the grouping of dollar values needs to be further broken down, ex: 0-25, 26-100,101-500, etc.

Can someone help? Thanks

 

[synapsevampire]

Create a formula of:

if {table.value} <= 25 then
25
else
if {table.value} <= 100 then
100
if {table.value} <= 500 then
500
else
1000

Group on this formula.

You can also write a formula for display in the group header, as in:

if {table.value} <= 25 then
"0 - 25"
else
if {table.value} <= 100 then
"26 - 100"
...etc...

Furthermore, you can create a Crosstab and place the first formula as the row or column, and the other fields in the opposite, and the values in the summary field to get another way of looking at it.


Note that your post doesn't show how you wanted the output, which means we have to guess...

-k

 

[metalteck]

Thank you for the reply,

As for the output, what I would like is for it to look like this:
Type A
0-25 25 Accounts Total Dollars $100
26-100 5 Accounts Total Dollars $1000
101-1000 89 Accounts Total Dollars $1000000

Type B,etc....

 

[synapsevampire]

Then my formula should work for you.

-k

 

[Madawc]

metalteck, you should put the subject in the subject line. Everything with a green question-mark means 'Help'.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10