Hi all,
i wanna ask, is it reference cell's value cant contain '&' in excel jet report? cos i cant retrieve data from data tat hv '&'
Just wanna make sure tis is the problem cause i cant retrieve the other data..
Ur reply is really appreciated.Thx
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi Jeanny,
If you are trying to filter for a value with a special character like &, you have to either put single quotes (') around your filter or prefix the filter with @@ like this:=NL("Rows","Customer",,"Name","'T&A Holdings'")=NL("Rows","Customer",,"Name","@@T&A Holdings")
If you are referencing another cell with the value "T&A Holdings", then you could do it like this:=NL("Rows","Customer",,"Name","@@"&D5)
Does this help?
Regards,
Hughes -
Jet Reports Historic Posts Thanks Hughes.
It did work for &
How about special character like @
The value cant show if the reference cell got @ however it work perfectly for &
Regards,
Jeanny -
Jet Reports Historic Posts The problem with the "@" sign is that most databases won't let you search on it. For instance, NAV will not let you do this therefore Jet Reports will not let you filter on the "@" symbol. If you are using NAV, you will see that you cannot filter on this symbol within the system itself. This is why it is always best to not have special characters in fields you need to filter on. Sorry!
Please sign in to leave a comment.