Sorting a report

Business Central/NAV User Forum
1

Hello, all.

I have a feeling that the answer to this is right under my nose, but maybe one of you could point me in the right direction.

I have a report that has the following dataitem structure:

Item Table

Item UPC Table

Nonstock Item Table

Nonstock UPC Table

I need the report to be sorted by UPC, but the UPC’s are only stored in the UPC Table. How would I go about doing that? In some other posts I have seen it suggested to use the Integer table or a temp table … but I can’t quite figure out how to do that.

Thanks in advance!

2

Not sure why you need the Item table when you have the Item No. in Item UPC. If the Item table is used only to display the item number and description then I would suggest to use only the UPC tables and group on Item No. …

Hope it solves ur problem…

Anup