How do this in a report

DarkHorse

Dear folks; I think this is easy. I've a report with "Bom component" table as Dataitem, and I want to show the Inventory field from Item table linked on "No." Bom Component table field in sections. If I put Item table as DataItem it runs, but I need to do it in "Bom component" body section. I've tried:
product.RESET;
product.GET("No.");

But in doesn't works. Any idea please?.
Thanks in advance for help.

Marije_Brummel

CALCFIELDS(Inventory)

?

DarkHorse

#-o , That's it!, Thank you very much for your help and time.

manishgoyal

Inventory is FlowField in Item table. so first you use Calcfields function. then by applying setrange or get() function you easily get inventory from Item table.