Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Suppress Formula based on Username Post Reply Post New Topic
Author Message
codyssey
Newbie
Newbie


Joined: 26 Jan 2016
Online Status: Offline
Posts: 1
Quote codyssey Replybullet Topic: Suppress Formula based on Username
    Posted: 12 Feb 2016 at 4:27am
Hi everyone,

I am just starting to learn Crystal so forgive me if I am lacking any info. I have a suppress formula that suppresses a line item IF the line item is greater than one
(line item 1 {sales config template} always needs displayed, since it states the manufactured object model being ordered) AND if the line item has a choice assigned (ie not blank) OR, if the option's choice text contains "NO ELECTRIC PACKAGE".




{CRM_QUOTE_DETAIL.SALES_OPTION_CHOICE_ID} = 0
and {CRM_QUOTE_DETAIL.SEQ}>1
or {CRM_QUOTE_DETAIL.SOURCE_DISPLAY} = "NO ELECTRIC PACKAGE"




This works fine for our manufactured orders. However, for orders that just contain parts (no sales config template at line 1) it needs to display all items. So I thought maybe adding an exception for the parts salesmen user IDs. I got it to work perfectly for one user, but it gets screwy trying to add two user IDs.

Works fine:



{CRM_QUOTE_DETAIL.USERID} <> "DAVIS"
and {CRM_QUOTE_DETAIL.SALES_OPTION_CHOICE_ID} = 0
and {CRM_QUOTE_DETAIL.SEQ}>1
or {CRM_QUOTE_DETAIL.SOURCE_DISPLAY} = "NO ELECTRIC PACKAGE"



Needing something like:




{CRM_QUOTE_DETAIL.USERID} <> "DAVIS" or "JOHN"
and {CRM_QUOTE_DETAIL.SALES_OPTION_CHOICE_ID} = 0
and {CRM_QUOTE_DETAIL.SEQ}>1
or {CRM_QUOTE_DETAIL.SOURCE_DISPLAY} = "NO ELECTRIC PACKAGE"



Any way of specifying what user IDs to watch out for besides explicitly stating what usernames are the exception? Like a find(davis or john) formula? Thank you for your help.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 12 Feb 2016 at 8:03am
(NOT({CRM_QUOTE_DETAIL.USERID} IN ["DAVIS","JOHN"]))
and {CRM_QUOTE_DETAIL.SALES_OPTION_CHOICE_ID} = 0
and {CRM_QUOTE_DETAIL.SEQ}>1
or {CRM_QUOTE_DETAIL.SOURCE_DISPLAY} = "NO ELECTRIC PACKAGE"
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.035 seconds.