When a memo with the title of “Approved – R & W” is used in a repair case the note (which is a date) does not populate on the repair inspection report. If any of the other “Approved” statuses is used, the note prints on the repair inspection report. How can I add “Approved – R & W” as a status that will print in the “approval date” field on the repair inspection report?
Below are screenshots.
If looking at the expression for hiding the field, it is calling for the field to be hidden unless the Memo_CategoryID equals “APPR”. The Memo_CategoryID for your ‘Approve - R & W’ is something other than “APPR” so it doesn’t print.
Correct, I’m looking to have both values print. Approval and Approval R&W. I just do not know the value for the Approve - R&W
There is a Memo Category screen available and it should list the various codes for the Memo Categories. You will need to find the correct File type at the top of the screen for these entries. In your case, it may be ‘Service Call Center’.
I’ve never heard of that. Maybe if submitted via a call but that’s not how our workflow is. I used to be able to click display field level help and it would give me the epbinding, DB field as well as the data field.
Try Memo Category Maintenance…
Hopefully you can find your “Approve - R & W” memo category there and see what the CategoryID is.
That was it… APPR4 is what it is and found in the memo category.
by any chance, would you know what the syntax would be to display both APPROVED and APPROVED R&W values if shown. Currently but would like to add the APPR4 so it would show values for when APPROVED is select or when APPROVED R&W is selected.
=UCASE(Fields!Memo_CategoryID.Value) <> “APPR”
I am getting the same results, no data, as well on the slide out screen but the information displays correctly when selecting a field on the main screen. I would chalk it up to a Kinetics issue. I looked at the Memo table via BAQ and I am seeing that Memo Title = Memo_MemoDesc, User ID = Memo_UserID, Notes = Memo_MemoText, Category = Memo_CategoryID. I hope this helps and sorry for the confusion.
Try:
=iif(
(UCASE(Fields!Memo_CategoryID.Value) = “APPR”) or (UCASE(Fields!Memo_CategoryID.Value) = “APPR4”), false, true)
So… we’re flipping the expression for hidden. If the value = “APPR” or “APPR4”, then return a value of “false” (don’t hide), else “true” (hide).
Thank you for that, it worked.
Quick question. If I’d want to have all the memo categories values to be added.
What would the syntax be to add the other 8? I would believe the IIF statement couldn’t add on to that, correct?
Well, one option is to remove the expression all together, so you’d see all memoID’s.
Otherwise, yes, you can keep adding on to the iif statement. Just need to add them within the correct set of parenthesis.
Or… you could write a statement where the ID Begins with or Contains “APPR” (which would include them all).
If you need help playing around with them, just let us know.
sorry for the delayed response but I’m not following your last statement. I tried adding on to the iif statement but didn’t work
I would assume a longer expression would look like this…
=iif(
(UCASE(Fields!Memo_CategoryID.Value) = “APPR”) or
(UCASE(Fields!Memo_CategoryID.Value) = “APPR1”) or
(UCASE(Fields!Memo_CategoryID.Value) = “APPR2”) or (UCASE(Fields!Memo_CategoryID.Value) = “APPR3”) or (UCASE(Fields!Memo_CategoryID.Value) = “APPR4”) or
etc
etc
etc, false, true)
If you always want your ID to show… just delete the expression all together so there is no visibility clause.
BUT… if you have others that you DON’T want to show… but DO want to show any of the “APPR” ones… you could try:
=iif(InStr(UCASE(Fields!Memo_CategoryID.Value), “APPR”),false, true)
This SHOULD use the “InStr” (in string) like a “contains” statements. So if your CategoryID.Value “contains” APPR", then “false” (don’t hide it), else “true” (hide it).
Thank you! Much appreciated!
