simple formula

[Guest_imported]

I need a simple formula which uses a "where" clause. Similar to this SQL statement: Select a WHERE b = c What is this formula in crystal syntax???? Something along the lines of : select {employee.lastName} where {employee.employeeIdNumber} = {project.employeeIdNumber}.

 

[Ngolem]

a simple If statement will do that

if {employee.employeeIdNumber} = {project.employeeIdNumber} then
{employee.lastName} ;

Jim Broadbent

 

[Guest_imported]

thats about right...however I need it to look like:
**********************
select {employee.lastName} where {employee.employeeIdNumber} = {project.employeeIdNumber};
**********************
furthermore, {project.employeeIdNumber} is the Group Name

how do I do this?

 

[synapsevampire]

Crystal doesn't allow you to use subqueries.

You accomplish joins using the visual linking expert in Crystal.

If you already have the tables joined in some other fashion, and want to compare these two values, just do as ngolem suggested and create a formula:

if {employee.employeeIdNumber} = {project.employeeIdNumber}then {employee.lastName}

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Ngolem]

Sorry...but this

****************************
select {employee.lastName} where {employee.employeeIdNumber} = {project.employeeIdNumber};
**********************

As you know is a query or subquery as SV has said. Crystal cannot use this as a "formula".

Rather than have us guess...please describe your real problem...between myself, synapsevampire and all the others here we should be able to sort it out Jim Broadbent

 

[RhondaH]

I'm trying to do something very similar. A simpe "Search and Replace". Where the Status = 200 I want Use the Record Selection Formula Editor replace 200 = PASSED. Here's the SQL to start wtih....
**********************************************
{TPV_PUB_ED_PROD_COMPLETED.STATUS} = 200.00
***********************************************

 

[Naith]

You wouldn't replace this value in the Record Selection Criteria.

You have to create a formula to to do the replacement for you, and display that in the report instead.

//Start
If {TPV_PUB_ED_PROD_COMPLETED.STATUS} = 200.00
Then "Passed"
Else
{TPV_PUB_ED_PROD_COMPLETED.STATUS}
//End

Naith