Counter based on a formula Y/N 2

[dreman]

Using CR8:
I have a report grouping salesman based on orders. Some of orders are completed some are not. (Y-completed and N-for non completed). I would like to count how many N's and how many Y's. Please advise. (I tried running total's but no success). thank you.
dré

 

[alley211]

Hi,

I would use some variables:

1st formula:
whileprintingrecords;
if {order_completed} = "Y" then
global numbervar yes_sales := Yes_sales + 1
else
// throwing in "N" just in case there is another possiblity
if {Order_completed} = "N" then
global numbervar no_sales := No_sales + 1

Place this formula on the detail section and suppress it

In your report footer place the following formulas:

Formula 1:

whileprintingrecords;
global numbervar yes_sales;

Formula 2:

whileprintingrecords;
global numbervar no_sales;

This will give you a count of yeses and nos.

alley

 

[dreman]

thank alley I will let you know.
Dré

 

[dreman]

Alley:
Yes it worked fine; however how would I init yes_sales and no_sales after printing them. Please advise thank you.

 

[alley211]

I'm confused on what you mean by init.

alley

 

[dreman]

Sorry Alley
init=initialize or set it to Zero to get the next yeses and nos for the next group in my report.
dré

 

[alley211]

Sorry:

In your group header put the following formula:

whileprintingrecords;
global numbervar yes_sales := 0;
global numbervar no_sales := 0;

Place the calculation formula in the details section

place the two formulas that give you the amount in the group footer.

alley

 

[dreman]

Alley:
wow what a response!!!
thanks for the quick response,
one more question: the formula is used in group footer, however I went to the format section but do not know wher the formula to be placed. I tried to place it reset or other section CR error out with 'it has to be a boolean value'
thank again dré

 

[dreman]

Alley:
You are a charm
ignore my last post. I figured it out.
Thank you very very much. I would have not done it without your knowledge and BIG help.

 

[kenhamady]

An alternative technique for doing this without variables is to create 2 if-then formulas:

if {order_completed} = "Y"then 1
else 0

Then Add subtotals and grand totals on these formulas. One advantage to this is the subtotals can now be in the Group Header or the Group Footer (variables won't be complete until the GF). Also, any grand totals would require separate variables, but with the formulas you just insert a grand total. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[alley211]

Hi,

If you want further information about this topic or classes a good place to start would be looking at the Crystal Decisions website to see an outline of the courses that are offered around the country.

alley

 

[kenhamady]

Or, go to Google and search for 'crystal reports training'. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[dreman]

Thank you
Dré