Hi,
I have a Capex Report -
NL("Rows","FA Ledger Entry",,"+FA No.","*","Posting Date",Options!$D$22,"FA Posting Type",Options!$D$24,"FA Posting Group",Options!$D$25,"Global Dimension 1 Code","*")
Which works perfectly, but this only reports on a certain month, I have been asked to attempt to get each month side by side, I cant see a way of doing this as the only way I can get the information that I need is with "Rows" this obviously takes into account the information on the report next to it, so I am finding duplicate entries. (So far, I've just tried copying and pasting the same report next to it)
Is there any way of doing a "List" function instead of "Rows", or a way of using "Columns" just for the date filter?
Date
Votes
2 comments
-
Jet Reports Historic Posts Can you provide a copy of the report you are working on? We might be able to help. I do know that it sounds like you need to using the NL("Columns") function with your NL("Rows").
-
Jet Reports Historic Posts Hi, if I understand you correctly, this could help you:
In cell C5 you have your "rows" function, in F2 you have a columns function.
The Columns function reffers to the "integer table", a table in NAV that contains numbers, so you can generate columns on demand (ex: NL("Columns";"Integer";"Number";"Number";"1..12") will generate 12 columns, all with the number as the header in row 2).
Then, in F3 you can add a date filter by using the DATE(day;month;year) function, (ex: DATE(1;F2;2008) will return you the twelve starting days, from 1/01/2008 to 1/12/2008, in F4 you create the last day in each month (EOMONTH(F3)).
Now you have, above your rows, your starting and beginning date (can use a NP("datefilter") if needed), which you can use in your rows as a filter.
Of course, you can play with this and probably add some "options". But this would be the basic idea.
Please sign in to leave a comment.