Global Variables 4

[JasGrand]

Hello, I am using Crystal Reports v7.0 to create a report. On this report I have a function (in the detail section) that calculates how many Direct Type jobs there are and how many Indirect Type jobs. I have a function included in the detail section which follows:

NumberVar NumDirectJobCount;
NumberVar NumIndirectJobCount;
If {V_JOBS_CREATED.JOB_TYPE}[1 to 3] = "Dir" Then
NumDirectJobCount := NumDirectJobCount + {V_JOBS_CREATED.NUM_JOBS}
Else
NumIndirectJobCount := NumIndirectJobCount + {V_JOBS_CREATED.NUM_JOBS}

I need to display these variables in the report footer (where all my totals will be located). I need help on how to pass the value of the two variables above to another function so I can display them in the report footer.

Thanks,

Jason

 

[Reebo99]

in you formula replace :

NumberVar NumDirectJobCount;
NumberVar NumIndirectJobCount;

with :

Global NumberVar NumDirectJobCount;
Global NumberVar NumIndirectJobCount;

Then create a formula :

Global NumberVar NumDirectJobCount;

This will give you the value of the variable.
Hope it helps, keep me posted.

Reebo
Scotland (Going mad in the mist!)

 

[JasGrand]

Hello, for some reason it just gives me a 0.00 in the field. Any Suggestions?

 

[synapsevampire]

As Reebo stated, add GLOBAL to the front of your variable declarations, the create formulas for each of the variables.

@DirectTotal
global NumberVar NumDirectJobCount;
NumDirectJobCount

@IndirectTotal
global NumberVar NumIndirectJobCount;
NumIndirectJobCount

Place these in the report footer.

If you need to display at the group level, create an initializing formula, as in:

@InitTotals
global NumberVar NumDirectJobCount:=0;
global NumberVar NumIndirectJobCount:=0;

Then you'd place this formula in the group header, the formula you have in the details, and the display as I just defined in the group footer.

-k

 

[Reebo99]

Synapse, you saved me.....Thank you.

I'd just like to congratulate you on being voted top tipster. Reebo
Scotland (Going mad in the mist!)

 

[JasGrand]

Hello thanks a lot for answering, like I said... I did that already and it's still showing me 0.00 in the other two fields(@DirTotal and @IndTotal). I just don't know why it's giving me the 0.00 when i know there is a number in the variable.

Thanks

 

[JasGrand]

Could I be doing something wrong?

This is the formula in the Details section:

Global NumberVar NumDirectJobCount;
Global NumberVar NumIndirectJobCount;
If {V_JOBS_CREATED.JOB_TYPE}[1 to 3] = "Dir" Then
NumDirectJobCount := NumDirectJobCount + {V_JOBS_CREATED.NUM_JOBS}
Else
NumIndirectJobCount := NumIndirectJobCount + {V_JOBS_CREATED.NUM_JOBS}


This is the formula for the @DirTotal function:
Global NumberVar NumDirectJobCount;
NumDirectJobCount

This is the formula for the @IndTotal function:
Global NumberVar NumIndirectJobCount;
NumIndirectJobCount

Any help is appreciated.


Thanks,

Jason

 

[mbarron]

Add the evaluation constraint of "WhilePrintingRecords" to your totals formulas

WhilePrintingRecords;
Global NumberVar NumDirectJobCount;
NumDirectJobCount
Mike

 

[JasGrand]

Thanks Mike, you answered my question.

Is there a way to give points or anything in this forum?

 

[Reebo99]

Whoops........forgot that one. Reebo
Scotland (Going mad in the mist!)

 

[mbarron]

That's what the

Mark this post as a 
helpful/expert post!

below each post (except your own) is for.




Mike