how to show record is null?

Business Central/NAV Developers Forum
1

Hi, I would like to show record which filter by routhing link code = ‘’ before other record that have values. I create new report called “BOM Routing Link”. I use Item, Routing Line and Production BOM Line Dataitem. Item Section Header - show detail of item. Production BOM Line Header - show detail of routing line. Production BOM Line Body - show detail of production bom line. Now data of routing line which filter by routhing link code = ‘’ they’re not show Brick wall How i should to do? I insert new dataitem is routing line1 and Production BOM Line1 for show detail of production bom line that empty only. thank in advance klum

2

THis is pretty hard to understand. Can you make it clear what you are trying to print onthe report such as: Item A details BOM Line 1 Routing <blank> details Routing 001 details Routing 020 Details BOM Line 2 Routing .... remember to use to make it readable. In simple terms, which element are you trying to sort and filter by routing link code? The example above is obviously wrong, but what do you actually need. At fist guess its either a key error or you have your levels structured wrongly.

3

Hi David, DataItem Item Routing Line Production BOM Line Property each dataitem is Routing Line dataitemlink property ---> Routing No.=FIELD(No.) Production BOM Line dataitemlink property ---> Routing Link Code=FIELD(Routing Link Code) I would like to show Item which replenishment system is prod. order in item header show detail of item in production bom line header show detail of routing line in production bom line body show detail of production bom line on above that i try to explain it’s work but what i stuck is i would like to show detail of production BOM line which use filter is WHERE(Routing Link Code=FILTER(’’)) what dataitem i should to insert new and what section i should to place field which must be show before section production bom header. thanks klum

4

quote:

I would like to show Item which replenishment system is prod. order in item header show detail of item in production bom line header show detail of routing line in production bom line body show detail of production bom line on above that i try to explain it’s work but what i stuck is i would like to show detail of production BOM line which use filter is WHERE(Routing Link Code=FILTER(‘’)) what dataitem i should to insert new and what section i should to place field which must be show before section production bom header.

OK, I think I see what you are trying to do, try this… DataItem Item Routing Line **Production BOM Line (Name this ProdBOMLine2)** Production BOM Line Property each dataitem is Routing Line dataitemlink property ---> Routing No.=FIELD(No.) **ProdBOMLine2 dataitemlink property ---> Routing Link Code=FILER('')** Production BOM Line dataitemlink property ---> Routing Link Code=FIELD(Routing Link Code)

5

Hi David, [;)] It’s work now. Thank a lot Wanvisa K.

6

[:)] You’re welcome.