By using this website, you agree to our Terms of Use (click here)
I am having trouble and hoping for some help with the Visible Expression field in the report designer regarding NoteText.
The goal is to display a highlighted text box containing the note text of a sales order when a note is present.
The value field is listed as: =[Note.NoteText]
Visible Field is listed as: True
It seems to work great as long as I do not enter anything into the VisibleExpr field.
As far as the visible expression I have tried multiple expressions and always end with the same result, a highlighted yet blank text box. You can see the text box, but not the text when it should be present. It seems that any visibility expression I enter caused the NoteText to vanish/not display. If I remove the visibility expression it comes back.
VisibleExpression's I have tried:
=True
True
=([Note.NoteText]<>Null)
=(Len([Note.NoteText])>2)
All have the same result.
Help Please!
This works for me when I set the VisibleExpr on the Detail Section. It looks like you might be trying it on the text box, which should still work, I think. However, try looking at the default OOTB PM641000 report in Report Designer. Highlight the Detail Section(s) and check out the VisibleExpr.
Kelly, thank you for the input. That did not work either. But I found the problem. Sometimes you just need a break and some shuteye for the old ticker to start working. I had the ProcessOrder field set to "WhilePrint" I don't even really know what that does. But I changed it back to the default of WhileRead and everything started working.
@tra_user Ahh...yes...I should have looked at that as well. I didn't notice it was "bold" (meaning not default). I never touch that ProcessOrder setting. Glad you got it working!