StupidSimple - Selection Formula Needed PLEASE

[markajem]

I don't know if it is because I have been working too hard and my brain is fried or that maybe I am trying to make this way more difficult than it is but I need a selection formula where I can use a parameter that I set up for a customer number. If the user enters a customer # then only bring back order information about that customer only, if the user enters "ALL" then let the report bring back order information from ALL Customers. Why I can't get my logic is beyond me today. Maybe I should just go back to bed again. Mark
Email: markanas333@hotmail.com

 

[synapsevampire]

Try:

(
If {Table.Cust#} <> &quot;All&quot; then
{Table.Cust#} = {?Custparm}
else
true
)

This will also pass the SQL to the database, and can be ganged with other selection criteria safely.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[markajem]

See, now I knew it was easy; I just was being really stupid or thick headed - god I need a vacation. Thanks it worked perfectly for this application.

Mark
Mark
Email: markanas333@hotmail.com

 

[synapsevampire]

Nae worries, we all have those moments...

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com