crystal reports formula field within a formula field

Question

0.00/5 (No votes)

See more:

Within Crystal Report 10 I am doing a report.

I have 2 formula @Address1 & @Address2.

What is the correct syntax to do the following....

if field.area = "New York" then
display @address1
else
display @address2

Just recently starting using Crystal Report and also hope I have the correct forum. Sorry if in wrong area.

Posted 16-Feb-11 1:08am

Central_IT

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Accepted Answer · 2011-02-16T06:37:00

Solution 1

Try:

SQL

if {Customer.Region}  = 'New York'
then {Customer.Address1}
else {Customer.Address2}

For sample crystal formulas, look here:
Ken Hamady's Crystal Reports Formulas[^]
Formula via code[^]

Posted 16-Feb-11 6:37am

Sandeep Mewara

Comments

Central_IT 17-Feb-11 9:25am

Tried it and it work. Thanks for the advice

thatraja · Accepted Answer · 2011-02-16T06:48:00

Solution 2

Your formula should be like below

C#

if {field.area} = "New York" then
{@Address1}
else
{@Address2}

Posted 16-Feb-11 6:48am

thatraja

Comments

Central_IT 17-Feb-11 9:25am

Tried it and it work. Thanks for the advice