Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

The ) is missing error on a Crystal 11 formula

Posted on 2006-12-01
1
Medium Priority
?
827 Views
Last Modified: 2012-06-27
Here's the formula:

IF {pr_hvt_fundraising_status.sort_option_2} = 3 THEN
    {pr_hvt_fundraising_status.sort_person_name_2} + (SELECT {pr_hvt_fundraising_status.sort_person_string_2}
                                                    CASE "L" : " - Lead" CASE "S2" : " - HIPEP V Backup" default : " - Backup" END)
ELSE
    {@Sort2_Group1}


It says that I am missing a )  ?

help?
0
Comment
Question by:TimFred
1 Comment
 
LVL 2

Accepted Solution

by:
badstink earned 2000 total points
ID: 18056332
Remove the "END" from your formula.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

971 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