Issue in Report

chandrurec

Hi all,

I have done a report to show item by location.

For this the report design looks like this

Item
Location

Location is indented below item and there is no link between Item and Location.

i am displaying the Item no and description in the location header section.

My doubt is Item no and Description is not getting displayed for the records whose location code does not start with Blue.

what may be the reason ?

its urgent. so if anyone knows where the mistake lies please help me in solving this issue.

Thanks in advance

Regards,
chandru.

DaveT

Hi,

Not sure what you're tring to acheive - if there is not link between the Item and Location dataitem the report will loop all item and for each item loop all locations. Can you expand on the explaination and/or post the code

chandrurec

Hi Dave,

My report should look like this


Item nO Item Desc LOcation Code Inventory Qty Sales ORder Qty Purch Qty
1000 Bicycle Red 10 50 20
Blue 20 60 70
Green 30 100 20

1100 Spoke Yellow 20 40 10
White 15 16 17

In this Item No should be displayed only once How to achieve this ?

Regards,
chandru.

DaveT

Hi,

The easiest to explain it to have the report structured as is (Item -> Location)
Put the print of the item no. and description in the body on the item and set the "Print only id details" property to true.

In the location dataitem declare an Item record variable and use the code

ItemRec.Setfilter( "Location Filter", location.code );
ItemRec.calcfields( "Inventory", "Qty. on sales Order", "Qty. on pruch. order" );
if ( itemrec.Inventory = 0 ) and ( itemrec."qty. on sales order" = 0 ) and ( itemrec."qty. on purch. order" = 0 ) then
currreport.skip;

printing the value of the ItemRec in the body section