VB.NET Crystal Select statement for Viewer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I hope I posted this to te correct forum

How do I put something like the following in a Select statement for the Crystal Viewer
JOSD_JOHN NOT IN (select JOHN from RATE_DATA

I tried "{JOSD_DATA.JOSD_JOHN} NOT IN (select {RATE_DATA.JOHN} from RATE_DATA)" and that doesn't wor
 
Hi,

Put this into your record selection formula:

instr({tblcusts.fullname},"JOSHD_JOHN") = 0

HTH,

Bernie Yaeger

schildr said:
I hope I posted this to te correct forum.

How do I put something like the following in a Select statement for the Crystal Viewer?
JOSD_JOHN NOT IN (select JOHN from RATE_DATA)

I tried "{JOSD_DATA.JOSD_JOHN} NOT IN (select {RATE_DATA.JOHN} from
Click to expand...
RATE_DATA)" and that doesn't work
 
Back
Top