Remaining Text error in formula using a Select statement 1

[Siggy19]

When I try to save the following formula, I get an error saying "The Remaining Text does not appear to be part of the formula" and Crystal puts the cursor on the line before the IF statement;

numberVar Limit := 0;

select {RPT_Inventory_1.ClaimType}
    case 'Acknowledged' : Limit := 15
    case 'Forwarded' : Limit := 10
    default: Limit := 0;

If {@WorkingDays} <= Limit Then 1
    Else 0;

Any idea what the problem is ?

 

[rosemaryl]

Dear Siggy,

You don't state your version but I am going to guess you are at 8.5 .... Crystal had issues at that version reading anything (paren, semicolon and so on). To get it to work, just put in an extra one. Only issue is that in cr10 the way you had it works just fine.

I rewrote it slightly becuse I thought it was cleaner, but yours is fine the way it is if you add an extra semicolon.

numberVar limit :=
select {RPT_Inventory_1.ClaimType}
case 'Acknowledged' :15
case 'Forwarded' : 10
default : 0
;; //comment: note that second semicolon!

If {@WorkingDays} <= Limit Then 1
Else 0;


Regards,

ro


Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762

 

[Turkbear]

Hi,
Nice one Rosemary..

Actually,I just posted to say Hi..I just finished 4 days with your training partner Mike learning about MagicTSD Administration - If he is representative of the talent level you folks have, it is no wonder your postings are so good.



Hope this is not an inappropriate use of this forum..






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Siggy19]

My Heroine !!!

Thank you... It had been an occasional bugbear, but I had usually just rewritten the code to find some way that it did work and I was sick of it... now I have a long term fix, at least until my company upgrades to 10.

I had thought about doing it the way you rewrote it, but I'm old-school and like to do one thing at a time... it helps me to work out what on Earth I was trying to do six months later when I have to debug something.

 

[rosemaryl]

Dear Turkbear,

I believe we are able to converse... just no selling, recruiting, and student postings... if we don't go too far off topic!

I have seen your posts and had no idea you were a fellow MagicTsder ... nice to meet you.

Feel free to email me if you want (not taking any tek-tips stuff offline) ... just to start a MagicTSD conversation. I am actually meeting with Q/A for Magic this month to go over report issues with their team and would love to add any you have come across.

Best regards,
ro


Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762