Dear all,
We created two new tables in Navision some years ago. In the header one we fill manually some fields (date, type of material..) and line table is automatically filled with purchases/sales entries. We have a report on reporting services that need these tables.
Now we are using jetreports to get this report but we continue using the table header in Navision because we need to add new data each month in this table. I wonder if we can fill an excel instead of that table on Navision and prepare the report that captures data from this excel file and navision's tables.
Thank you for your comments.
Regards,
NACHO
Date
Votes
4 comments
-
Jet Reports Historic Posts I have some advances about this but i continue needing your help…
I have prepared this:
In Sheet 1:
d18 i have this function –> =nf(C18;"No.") –> this give me a number of item.
E18–> if this item exist on a table in sheet 2, it shows me column 2 field of that table –>=IF(D18="";"0";IFERROR(VLOOKUP(D18;Sheet2!D$4:E$15;2;);"0"))
if it does not exist in the table, it shows me 0.
In Sheet2 i have some items in column d and quantities in column E.
I do not understand why the results are always 0 (and the item no_ exists on the table!!). If i write manually the item no_ on D18. It shows ok the quantity.
why??
thank you again! -
Jet Reports Historic Posts Hi,
what is in "C18" ?
Can you upload an excelsheet with the function?
regards
Michael -
Jet Reports Historic Posts Thank you Michel. In C18 is a row function about items. The result of d18 is an item no. I 've already found the problem and how to solve it. It was a problem of the format.
I have added another column: "F" . In f18, I wrote =d18*1 –> doing this excel it converts the cell as a number.
and in the old function i changed D by F column: IF(f18="";"0";IFERROR(VLOOKUP(f18;Sheet2!D$4:E$15;2;);"0"))
thank you again to everybody. -
Jet Reports Historic Posts Thanks for your feedback ;)
Please sign in to leave a comment.