We are using JET reports 2010 with Navision 5 in Excel 2007
I am trying to create a BOM explosion report. Attached you will find the report I have build so far. With the first two levels of the BOM I have no problem, but starting at level 3 the report generates only the first article of the BOM.
What am I doing wrong.
Important to know is that in our database the BOM number is the same as the Item number.
The tablenames are dutch, on our company database.
Date
Votes
5 comments
-
Jet Reports Historic Posts Official comment Hi,
You can't wrap an NL(Rijen) formula with an Excel IF function. The =NL("Rijen must be the first thing in the cell. You can get around this by putting your IF function around the table argument of the function like this:=NL("Rijen=5",IF(K5="",{""},"Productiestuklijstregel"),,"Prod.-stuklijstnr.",K5)
Another thing you can do which will work the same way assuming that there are no blank values for the "Prod.-stuklijstnr." field in the table is this:=NL("Rijen=5","Productiestuklijstregel",,"Prod.-stuklijstnr.","@@"&K5)
Does one of these solutions work for you?
Regards,
Hughes -
Jet Reports Historic Posts Hello Hughes,
The second suggestion solves my problem.
Thank you for your support!
Regards,
Elmer -
Jet Reports Historic Posts Just so that you know, this topic has helped me greatly. I now have the ability to create a range of very useful reports.
-
Jet Reports Historic Posts Can anyone suggest how I could go about having JET create a new sheet for every assembly within a top level BOM?
This would be a great help when creating our user manuals amongst other things.
Thanks. -
Jet Reports Historic Posts Hi,
Please post this as a new thread since it doesn't really have anything to do with this thread and the question in this thread is already answered. Thanks!
Regards,
Hughes
Please sign in to leave a comment.