How do I declare a variable in Crystal? 1

[Frostburn]

This formula keeps causing Crystal Reports to crash:

if Sum ({@YearlyBudget}, {tblSubSection.SSName}) > 0 then

Sum ({@AvailableBudget}, {tblSubSection.SSName}) / Sum ({@YearlyBudget}, {tblSubSection.SSName}) * 100

--How do I declare variables to work with so the formula can deal with those, not the actual sumations?

Thanks

 

[FredGexel]

Dont you want to affect that formula to a field or something ? : Sum ({@AvailableBudget}, {tblSubSection.SSName}) / Sum ({@YearlyBudget}, {tblSubSection.SSName}) * 100

Wouldnt it be : FIELD = Sum ({@AvailableBudget}, {tblSubSection.SSName}) / Sum ({@YearlyBudget}, {tblSubSection.SSName}) * 100

That if if u want it to be displayed in a field. If you want variables, just look in the C.R. help.. but i belive it's :

booleanVar x := y;
currencyVar x := y;
dateVar x := y;
stringVar x := y;

Hope it will give u a hint !

 

[MsPepperMintUSA]

Also check out this link(it can be found in FAQ for formulas)

http://support.crystaldecisions.com/communityCS/TechnicalPapers/cr8_formularef.zip

Goto insert/formula, once you are formula editor select "Operators", then "Variable Declarations". Also check out Scope to determine how lifespan of the variable.

You can find functions to convert datatypes in formula editor under "Functions" then "Strings".

Make sure you are not mixing datatypes, Crystal report does not give descriptive error messages for debugging.

 

[MsPepperMintUSA]

Forgot to include sample of declaration

Shared CurrencyVar Var1;
Shared CurrencyVar Var2;

Var1:= {@YearlyBudget};
Var2:= {@AvailableBudget};