Adding to an if statement.

[mudflap]

Here is what I have that works fine.
whileprintingrecords;
numbervar counter := counter+1;
stringvar job;
If {Prepress WIP.Proofs Due (Date) (User Defined)} = currentdate then
job := job + {Prepress WIP.Docket (User Defined)} +chr(13)
else job

I want to add if = this
{Prepress WIP.Production Status (User Defined)} in ["Out on Proofs(Film Imaged"]
Then don't print or suppress how would I add that into the same formula

Thanks
Peter

 

[synapsevampire]

For:

"I want to add if = this
{Prepress WIP.Production Status (User Defined)} in ["Out on Proofs(Film Imaged"] "

I think that you want to place:

{Prepress WIP.Production Status (User Defined)} = ["Out on Proofs(Film Imaged"]

in the *in* is:

{Prepress WIP.Production Status (User Defined)} in ["Out on Proofs(Film Imaged", "Not Available"]

Note the comma separating the values.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Naith]

Hey Pete,

Is this what you're getting at:

WhilePrintingRecords;
NumberVar Counter := Counter+1;
StringVar job;

If {Prepress WIP.Proofs Due (Date) (User Defined)} = CurrentDate
Then
If {Prepress WIP.Production Status (User Defined)} <> &quot;Out on Proofs(Film Imaged)&quot;
Then job := job + {Prepress WIP.Docket (User Defined)} + chr(13)
Else job
Else job

I went ahead and added a ')' at the end of '(Film Imaged', as I'm assuming that's how the field looks in your database.

All the best,

Naith

 

[mudflap]

Thats perfect thanks Naith..Just couldn't figure out the
syntax..
Getting a little better with all this stuff.
Made another form for the finacial people. That is going well too.

Again thanks for the Help.

PEter