Hello,
I'm having the following problem with a filter:
When I use the filter "C & A" in an NL-function jet reports returns the filter as "C A".
"C & A" is used in a name-field and I cannot filter on any other fields.
Does anybody knows how I can tell 'jet reports' that the &-sign is just a part of the text?
Thanks for your help.
Henri
9 comments
-
Jet Reports Historic Posts Official comment Thanks again. Never to old to learn. :lol:
-
Jet Reports Historic Posts Use "@@C & A".
Only thing now is you cannot use more filters like "C & A..Zeeman". -
Jet Reports Historic Posts Sorry. Let me be more precise.
The text has already been put in a cell by Jet.
I have tried "@@"&$J14, but it still ignores the character &. -
Jet Reports Historic Posts Hi Henri,
What version of Jet Reports are you using and also, what is the exact Jet formula which is returning the value that way?
Regards,
Hughes -
Jet Reports Historic Posts Sorry for this late reply.
Our version is 9.2.10167.0 and the formula is:
=NL("Som";"Productieorder";"Aantal";"Status";"Vrijgegeven";"Productgroepcode";M$10;"Omschrijving 2";$K12;"Link=";"Materiaalregel";"Gereserveerd aantal";"<>0";"Prod.-ordernr.";"=Nr.";"Variant";Opties!$D$61)
In underlined part the problem occurs. $K12 contains a name with an '&'. Say the name is 'Jansen & Jansen' then the filter $K12 returns 'Jansen _ Jansen'.
Hopefully this explains my problem.
Regards,
Henri -
Jet Reports Historic Posts Hi Henri,
This sounds like a problem with the Jet Report Options. I think Jet 2009 did have problems with things like this when it was writing out the report options. I'm assuming if you look at the value in cell K12 (or the value on the Opties sheet itself) it says "Jansen Jansen" which you selected via the report options lookup. Is that correct?
In newer versions of Jet, we've changed the report options so that they would write the value out as ="Jansen & Jansen" which solves the problem since Excel treats it like a string in that case instead of a formula. You should try upgrading to the latest version of Jet and see if that fixes your issue. If you're not using report options, you might try entering the value as ="Jansen & Jansen" as I did above.
Regards,
Hughes -
Jet Reports Historic Posts Thanks Hughes. We shall try this or else we shall make a work around.
Do you know how this item can be closed?
Kind regards,
Henri -
Jet Reports Historic Posts By the way Hughes. Do you know a method to empty the cache automaticly
before refreshing/generating a new report?
Regards,
Henri -
Jet Reports Historic Posts Hi Henri,
Threads on the community site don't really get closed per se. You can mark a particular post as solving your problem by clicking the checkmark button and the post will appear as solved, but it is always open for you (or someone else) to comment on later.
The cache always gets cleared when you use the Refresh button. That's the difference between the Report button and Refresh button. The Report button runs the report but may use existing function results in the cache (assuming you haven't changed the functions or option values). The Refresh button clears the cache, then runs the report, so all values will be coming fresh from the database. Does that make sense?
Regards,
Hughes