Forum Discussion

Jlewis's avatar
Jlewis
Qrew Member
4 months ago

Ask The User Exact Search

Hi, I have a report that asks the user to input a value and returns the result. I am searching for Asset records assigned to a user, or client. Because these clients are formatted with "HFT" and le...
reports
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 months ago

np,

I suggest that you make a formula numeric field literally called 

[Enter the numeric Store Number with no leading zeros]

 

Then make a formula of ToNumber(NotLeft([Client Store Number],3))

The use that field in the <ask the user> report with a test of equals.

 

.