Hi All,
I am stucked in the design of a report and getting data according to the design of a form made in word format.
The requirement is that many contols are to be displayed on the front page with heading (GD-I). (which i am trying to display on report header)
On the same first page need to get ONLY two items with some controls in three rows for each item. (These i am displaying on ItemNo Header.)
First row:
ItemNo,38aQuantityUnitType,38bNoOfUnits,CoCode,HSCode
Second row:
42ItemDescriptionOfGoods
Third row:
43UnitValueDeclared,UnitValueName, (twice), TotalValueDeclared,TotalValueDeclaredUnit, (twice), CustomValuePKR, (twice)
Then there are some other controls which i assume should come on report footer.
If items are more than TWO then from itemNo 3 onwards should go on the next page which has heading GD-II, and FIVE items should display on this page with three rows for each item and with a different footer.
At present what i have worked for only TWO items the output of report is showing me report footer moving to next page, which i need to remain on first page.
Record Source of Report "Goods Declaration" is "qryGD-I" having sql as under:
SELECT [GD-1].ConsignmentNo, [GD-1].Exporter, [GD-1].ExporterTele, [GD-1].DeclarationType, [GD-1].ValuationMethod, [GD-1].Page, [GD-1].PageOfPage, [GD-1].CustomOffice, [GD-1].BankCode, [GD-1].BankSuffix, [GD-1].Importer, [GD-1].ImporterTele, [GD-1].Declarant, [GD-1].DeclarantCityCountry, [GD-1].DeclarantTele, [GD-1].ChalNo, [GD-1].JobNo, [GD-1].NTN, [GD-1].StrNo, [GD-1].CountryOfDestination, [GD-1].EFormNo, [GD-1].EFormDate, [GD-1].CurrencyName, [GD-1].CurrencyCode, [GD-1].ExchangeRateUnit, [GD-1].ExchangeRate, [GD-1].VesselMode, [GD-1].PortOfShipment, [GD-1].PaymentTerms, [GD-1].PortOfDischarge, [GD-1].PlaceOfDeleivery, [GD-1].DeliveryTerms, [GD-1].[31NumberOfPackages], [GD-1].[32TypeOfPackage], [GD-1].GrossWeight, [GD-1].GrossWeightUnit, [GD-1].[35GeneralDescriptionOfGoods], [GD-1].ItemNo, [GD-1].[38aQuantityUnitType], [GD-1].[38bNoOfUnits], [GD-1].CoCode, [GD-1].HSCode, [GD-1].[42ItemDescriptionOfGoods], [GD-1].[43UnitValueDeclared], [GD-1].UnitValueName, [GD-1].TotalValueDeclared, [GD-1].TotalValueDeclaredUnit, [GD-1].CustomValuePKR
FROM [GD-1] INNER JOIN [Consignment Number] ON [GD-1].ConsignmentNo = [Consignment Number].ConsignmentNo
WHERE ((([GD-1].ConsignmentNo)=[Forms]![Dialog Goods Declaration]![cmbConsignmentNo]))
ORDER BY [GD-1].ItemNo;
I need help on the issue.
Regards,
Khalid
__._,_.___
Posted by: Khalid Tanweer <khalidtanweerburrah@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar