Print Page | Close Window

Select Expert based on formula

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12564
Printed Date: 03 Apr 2025 at 9:51am


Topic: Select Expert based on formula
Posted By: althomas
Subject: Select Expert based on formula
Date Posted: 09 Mar 2011 at 4:29pm
Hi,
 I am trying to create a "select expert" based on a formula to give me 2 different results based on the boolean.
 
My conception is like this:
 
if ({Option03}) = True then {jobdtl.jobcomplete} = true else if ({Option04}) = True then {jobdtl.jobClosed} = true else if
({Option03} and {Option04}) = True then ({jobdtl.jobcomplete} and {jobdtl.JobClosed}) = true
 
Basically i want it as:
 if Option03 is True then make Jobdtl.Jobcomplete True as well  or else
if Option04 is True then make Jobdtl.JobClosed True as well
else if both options are True then make Jobcomplete and jobclosed true.
 
Am i writing this properly? Any advise will be greatly appreciated...


Replies:
Posted By: comatt1
Date Posted: 08 Jun 2011 at 4:35am
you would need to test for both options in all three stages, otherwise, like in this case, you COULD NEVER reach the final test.
Must have Option03=True and Option04=False.

However, not sure if the select expert will have much to do with this.

Are you filtering based off of those jobcomplete/jobclosed statuses?


Print Page | Close Window