I get this error message when I debug.
Invalid FlowFilter '@@'. flowFilters may not contain '*','?', or '@'.
Obviously it says I can’t have a ‘@@’ in my flowfilter. Is there anyway around this? Because sometimes my flowfield could be a blank value.
IFit helps, here is my NL
My grouping NL.
=NL("Rows=4","G/L Account","Glob. Dim. 5 Filter","Glob. Dim. 5 Filter",Options!$D$5,"Date Filter",Options!$D$6,"No.",Options!$D$7)
My NL that pulls in the data.
=NL("Rows","G/L Account",,"+No.",Options!$D$7,"Glob. Dim. 5 Filter","@@"&$D6,"Date Filter",Options!$D$6)
Any help is appreciated. Thanx
Craig
Date
Votes
8 comments
-
Jet Reports Historic Posts Let me use your Options!D5 how I make it work in my report:
- create an IF in another cell (e.g. Options!E5): =IF(Options!$D$5="","''",Options!$D$5") (2 single quotes)
- change your NL to =NL("Rows=4","G/L Account","Glob. Dim. 5 Filter","Glob. Dim. 5 Filter",Options!$E$5….
And for your date filter an empty value would not be useful, you coul do this:
- create an IF in another cell (e.g. Options!E6): =IF(Options!$D$6="","*",Options!$D$6) (star)
- and the part you change in your NL: …,"Date Filter",!$E$6 …
Please let us know if this solved your problem.
(P.s. Interesting to see you have so many flowfilters for dimensions on your G/L account table) -
Jet Reports Historic Posts I have attached my Jet report. I did what you said for my Glob. Dim. 5 Filter in the grouping NL.
Would i also have to do it in the NL that creates the data?
There are many flow filter in this heavily customized database. -
Jet Reports Historic Posts Well, if it works for the first function why wouldn't it work for the other functions? Why don't you give it a try yourself first?
-
Jet Reports Historic Posts i gave it a try, and i think i may have it…but one thing is causing an issue, on my report tab, in cell F5, it should be bringing back 017 as a value, but it is bringing back a blank value…(probably because of the IF statement i put in there).
is my IF statement correct, and if so, why is it bringing back a blank value?
craig -
Jet Reports Historic Posts You mean the yellow marked cell F5 on the Options tab? When I open the report it looks good to me. I even get the 017 value.
Gotta go - it's past 9 PM over here. Have a good day and good luck with the report. -
Jet Reports Historic Posts no, actually F5 on the Report worksheet, this is where my grouping NL is located. It should be bringing back the 017 value.
-
Jet Reports Historic Posts Good evening Craig,
Initially I only looked at the filter in the functions, as this was what your question was about. But now that you let us look at the F5 cell on the report tab I notice there's more to this report.
Global Dim. 5 filter is a FlowFilter field isn't it? If so, than you cannot create a group on it. FlowFilters are indeed fields in a table, but they do not contain data as a normal field would. If a FlowFilter is enterd in NAV the value is applied to all records within the table. Grouping on FlowFilters is not possible.
(p.s. to learn more about flowfilters I recommend to read the Application designer's guide which is comes with the installation files of NAV. It's placed in the doc folder)
But the next question is… what should you do to get the info you want in the report. Well, I must say that I think I do understand most of the things in your report but not all. Cells L6, M6 and N6 are unclear.
Let me start with an assumption: You want to report those accounts for which a certain Global Dim 5 value was used during a period. And Global Dim 5 is a field in the G/L entry table. Row 5 is to group by Dim 5 and Row 6 reports the G/L Account info. Hopefully I got that right so far :)
Then you could start in F5 with: NL("Rows=4","G/L Entry","Glob. Dim. 5","G/L Account no.",Options!$D$7,"Date Filter",Options!$D$6;"Glob. Dim. 5",Options!$F$5)
And G6 would have to be changed to retrieve the G/L Account no: NL("Rows","G/L Entry","G/L Account no.","G/L Account no.",Options!$D$7,"Date Filter",Options!$D$6;"Glob. Dim. 5","@@"&F5)
And then you would need to add a column between G and H to link to the G/L Account table to be able to retrieve the fields from column H onwards.
(p.s. you will have to excuse any typo errors I made here as I don't know all the exact names of all tables and fields in your database)
As said, this is all based on some assumptions. I may be right, I may be wrong. But either way… I hope it takes you another step forward.
If this is not correct I suggest you contact a Jet Reports consultants or the report developers of Jet Reports to help you develop what you wish.
Take care and have a great day! -
Jet Reports Historic Posts Hans, thanx for your help, much appreciated.
Yes, on the G/L Account table it is a flow filter.
On the G/L Entry table, it is a regular field.
I never knew you couldn't create groupings from flowfilter fields.
I will have to link back to the G/L Table though, becuase we have some custom flow fields on there i will need for the report…I will give it a shot !!! thanx !!
Please sign in to leave a comment.