Hi,
I'm new here, I'm using JR 5.3.2 with Navision 3.70, and I'm not able to get data as I want.
I need to list (Rows)the "Item" table, for each row or "item number" I have a linked table (Comments) thru the "item number" where there are few records that I need to include in the main list with the "NL Columns", the problem is that JR list only the first record of the linked table and not all the records filtered.
Here attached the sample excel file, anyone can help me ?
here the functions that doesn't work:
(B4) =NL("Rows";"Item";;"Linea";"01")
(C4) =NF($B4;"Nr.")
(E4) =NL("Columns";"Comment Line";"Comment";"Table name";"Item";"Code";"Brani";"Nr.";C4)
if I try with a filter with only one "Item" it works, here the functions:
(B4) =NL("Rows";"Item";;"Linea";"01";"Nr.";"12345678")
(C4) =NF($B4;"Nr.")
(E4) =NL("Columns";"Comment Line";"Comment";"Table name";"Item";"Code";"Brani";"Nr.";C4)
why with the first it doesn't work ??? :(
thank you
Date
Votes
4 comments
-
Jet Reports Historic Posts Issue is that you can't do nl(columns) on a per row basis thats a per sheet function
so you would need B4 to be NL( Rows) C4 etcis your NF but to get new columns you would need in row 3 lets say H3
1st something to determine how many columns you require ( NL( "Columns", tablex, field name, filter to get 1 column per value )
then in H4 an NL(First, table, field , filtered by value in column header and your item )
Your other option is to start with a rows=2 then create a new NL(rows. table, comment, Filtered by your item number etc) that would give you a report that basically looked like this
Item Comment
item 12354
comment1
comment2
item 999999
That help ? -
Jet Reports Historic Posts Hi,
thank you for the reply but I don't understand what do you mean with the first example, how can I get in H3 the number of the columns if the Item to filter is in the row below in B4 ?
Could you please explain to me in a more simple way or with an example ?
thank you -
Jet Reports Historic Posts In short, you won't be able to use the NL("Columns") function in the manner that you are looking to. The reason for this is that every NL("Columns") function will copy everything in the column and copy it over. This may end up in a ton of duplication in your comments.
Take a look at the attached file. I took what you sent in and changed that "What" parameter to "1", which will return the first comment. Then I copied this over for the next 9 columns and changed the What parameter to "2", "3", "4", etc., which will return the second, third, and fourth comments. Just continue to copy it out for however many comments you would want to see. -
Jet Reports Historic Posts Hi Brian,
thank you for the reply and for the good solution, but if I don't know how many comments there are in the table in which way can I get all them ?
Thanks
Paolo
Please sign in to leave a comment.