Formula Editor errmsg:  The remaining text does not appear to be part of the formula

Posted on 2006-04-17
Last Modified: 2008-02-01
The below function returns the errmsg in my question title, and the cursor is in the line above FinalResult;

stringVar FinalResult;
FinalResult := '';

if ({spr_single_broker_history_summary;1.quarter_id} = '999999') then
    FinalResult := 'Grand Total'
else if ({spr_single_broker_history_summary;1.quarter_id} = '999998') then
    FinalResult := 'Total for last four quarters'
    FinalResult := Picture(Cstr({spr_single_broker_history_summary;1.quarter_id},0,""),"xxxx Quarter x")


Thanks in advance.
Question by:Jim Horn
    LVL 28

    Accepted Solution

    It looks like you need a semi colon after the last line of the If statement:

        FinalResult := Picture(Cstr({spr_single_broker_history_summary;1.quarter_id},0,""),"xxxx Quarter x");
    LVL 65

    Author Comment

    by:Jim Horn
    That was it.  Thank you.  -Jim

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now