Hi all,
I have one item with Header and many line items.
I want to export to xml.
I need to use header as root in .xml because there is a possibility whereby no line item at all.
When i export out the data, only one header together with one line item can be exported.
I want to do loop to get all details.
I just need an idea. please help.
0
Answers
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
I got add the count message the onafterrecord field.
it shows correct reading. but when export its print out one item line only.
******************************************************************
GPOTenderLine.SETCURRENTKEY(GPOTenderLine."Generic Code");
GPOTenderLine.SETRANGE(GPOTenderLine."Generic Code","GPO Tender".Code);
I := GPOTenderLine.COUNT;
MESSAGE(FORMAT(I)); // shows 3,1,2,3..etc
IF GPOTenderLine.FIND('-') THEN
REPEAT
Item_No := GPOTenderLine."Item No";
Internal_Reference := GPOTenderLine."Internal Reference" ;
Description := GPOTenderLine.Description ;
BUOM := GPOTenderLine.BUOM ;
Registration_No := GPOTenderLine."Registration No." ;
UNTIL GPOTenderLine.NEXT = 0;
Anything wrong with this code?
didn't you add lines as dataitem in xmlport and link between header and lines?
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
Could you assist me?
check properties LinkTable and Link fields
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
So i tried to create new table and insert all data into new table and export
it thru xml.
My xml report should like like this
-<GPOTender>
<Generic_Code>G0003</Generic_Code>
<Generic_Name>BioCon</Generic_Name>
<Prefer_Pack_Size>10 X 10</Prefer_Pack_Size>
<Prefer_Pack_Type>BOX</Prefer_Pack_Type>
<Country>SG</Country>
<Able_to_Quote>Yes</Able_to_Quote>
<Item_Category/>
<Item_No>FP-112-234</Item_No>
<Internal_Reference/>
<Description>Metanone</Description>
<BUOM>BOX</BUOM>
<Registration_No/>
<Shelf_Life/>
<Stability_Data>BE study/or clinical studies</Stability_Data>
<Batch_Size/>
<Lot_Size>0</Lot_Size>
<Formula>Different</Formula>
<Packing_Size/>
<Packaging_Type/>
<Remarks>Formula - MPE</Remarks>
</GPOTender>