ACCESS FEED: RE: [MS_AccessPros] Help required on Report Design

Senin, 05 Januari 2015

RE: [MS_AccessPros] Help required on Report Design

Khalid,

It's really difficult to determine exactly what you have and what you need. Generically, you can render/display data in a report via several different methods:

1) the report's Record Source
2) subreports to display related data from other record sources
3) Domain aggregate functions such as DLookup() and DSum() which have their own domain/recordset
4) VBA code to pull data from anywhere and display in unbound controls

Some complex reports work better if you populate temporary reporting tables.

If you continue to need assistance, you really should upload a file with the data and a detailed layout as required by your specifications.

Duane Hookom MVP
MS Access

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 5 Jan 2015 09:40:40 +0000
Subject: [MS_AccessPros] Help required on Report Design

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: Duane Hookom <duanehookom@hotmail.com>

Reply via web post

•

Reply to sender

•