the word else is missing?? Crystal formulas killing me 3

[slim2]

I keep getting the word else is missing. What am I missing?? There is no information to indicate anything is wrong in crystal help.

If not inRepeatedGroupHeader Then
(
Global NumberVar Array TotLnDol := [0,0,0,0,0,0,0,0,0,0,0,0,0];
Global numberVar Array NonAcDol := [0,0,0,0,0,0,0,0,0,0,0,0,0];
)

Thanks

 

[Roadkill150]

you have to end an if then statement with an else

If not inRepeatedGroupHeader Then
(
Global NumberVar Array TotLnDol := [0,0,0,0,0,0,0,0,0,0,0,0,0];
Global numberVar Array NonAcDol := [0,0,0,0,0,0,0,0,0,0,0,0,0];
) else 0 Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com

 

[slim2]

Thanks for the promt reply, now I get the following message

The array must be subscripted.

 

[kenhamady]

Actually the ELSE isn't necessary in this case. The problem is that the THEN can't end with an array, so you need something after that for the formula to return.

If not inRepeatedGroupHeader Then
(
Global NumberVar Array TotLnDol := [0,0,0,0,0,0,0,0,0,0,0,0,0];
Global numberVar Array NonAcDol := [0,0,0,0,0,0,0,0,0,0,0,0,0];0
)
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

 

[Ngolem]

Ken is right...this is the problem with your formula

the same would happen if you removed the If-then

Since a formula cannot end with an array I usually let it have a null value. Serves the same purpose and since you are not displaying the formula nothing is harmed

@initialize

Global NumberVar Array TotLnDol := [0,0,0,0,0,0,0,0,0,0,0];
Global numberVar Array NonAcDol := [0,0,0,0,0,0,0,0,0,0,0];
"";

 

[slim2]

Thanks a lot guys. You have been a big help.

Is there a book or manual somewhere that describes this, or is it no pain no gain.

 

[kenhamady]

Arrays aren't covered very much in CR courses or reference materials, probably because most users don't have much use for them. Actually, up until v8, you couldn't even update a single element in an array. So, before v8 there weren't many practical uses for them IMHO. 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

 

[slim2]

ken,

I saw your book on your website on report sepecifications and am getting it. If you would ever do a cookbook on Crystal functions and events, how they work and what the quirks are I sure would get it.

Thanks again