Try a blank formula field PrintedByUser.  That is how Sage passes the value through to reports, but I don't know if that works for Custom reports too.

Thx for replying. that's the first thing I tried before reaching out..only works for canned sage reports.

Do you have this option in Company Maintenance checked?

Good thought David.  I know the feature doesn't work without that option turned on.

dhalpin, FYI, I just confirmed the PrintedByUser formula works in a custom report added to the menu on a 2018 system.  The formula should be named exactly as it appears in standard reports and it should use Basic syntax and contain the following.

formula = ""

What BASIC syntax are you referring to?

ProvideX would look like the following.

LET formula$ = ""

You must have been thinking ScriptBasic.

Thanks all. My mistake was not having parameter turned on in company preferences so now I can get the user to display on custom report. Really appreciate the feedback.

I see this is in Crystal which uses VB as its BASIC syntax. Thanks for the clarification.

I thought I had this figured out but in my suppression formula I have this which isn't working. It suppresses if even your a user in the formula:

{@PrintedByUser} <> "PHILIP" OR {@PrintedByUser} <> "GARY" OR {@PrintedByUser} <> "KIRK" OR {@PrintedByUser} <> "CH" OR {@PrintedByUser} <> "CHRISTINE"

It only works it I have one user in the formula:

{@PrintedByUser} <> "PHILIP" 

It's probably because I have OR and the <> and the logic isn't working right.

Anyone know of another way to go about this. I want to suppress sections based on who is printing report. Using Crystal Syntax in section expert suppression formula.

Thanks!

I thought I had this figured out but in my suppression formula I have this which isn't working. It suppresses if even your a user in the formula:

{@PrintedByUser} <> "PHILIP" OR {@PrintedByUser} <> "GARY" OR {@PrintedByUser} <> "KIRK" OR {@PrintedByUser} <> "CH" OR {@PrintedByUser} <> "CHRISTINE"

It only works it I have one user in the formula:

{@PrintedByUser} <> "PHILIP" 

It's probably because I have OR and the <> and the logic isn't working right.

Anyone know of another way to go about this. I want to suppress sections based on who is printing report. Using Crystal Syntax in section expert suppression formula.

Thanks!

Your boolean math is all wrong.  Try something like this.

{@PrintedByUser} <> ["PHILIP","GARY"]

Yes it was all wrong..thank you worked well.