Solved

Crystal Reports Multiline IF

Posted on 2011-09-17
3
436 Views
Last Modified: 2012-08-14
I keep getting an error "the remaining text does not appear to be part of the formula." I know I'm missing something simple. Thanks
IF {@Print FED} = "X" THEN TRUE
IF {@Print FMED} = "X" THEN TRUE
IF {@Print FSOC} = "X" THEN TRUE
IF {@Print FUTA} = "X" THEN TRUE
IF {@Print SUTA} = "X" THEN TRUE
ELSE FALSE

Open in new window

0
Comment
Question by:dk04
  • 2
3 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 36555254
Try it this way

IF {@Print FED} = "X" THEN TRUE
ELSE IF {@Print FMED} = "X" THEN TRUE
ELSE IF {@Print FSOC} = "X" THEN TRUE
ELSE IF {@Print FUTA} = "X" THEN TRUE
ELSE IF {@Print SUTA} = "X" THEN TRUE
ELSE FALSE

mlmcc
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 36555257
These also work

IF {@Print FED} = "X" THEN TRUE;
IF {@Print FMED} = "X" THEN TRUE;
IF {@Print FSOC} = "X" THEN TRUE;
IF {@Print FUTA} = "X" THEN TRUE;
IF {@Print SUTA} = "X" THEN TRUE
ELSE FALSE

A third way

IF {@Print FED} = "X" OR {@Print FMED} = "X" OR {@Print FSOC} = "X"
   OR {@Print FUTA} = "X" OR {@Print SUTA} = "X" THEN TRUE
ELSE FALSE

mlmcc
0
 

Author Closing Comment

by:dk04
ID: 36560411
All of them worked without errors but the first way in the second post brought back the information I needed.

Thanks
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

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 …
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

707 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