Hi Guys,
i need some assistance concerning reports.
the issue is that i have about ten tables which are related. from the tables i have created a report called Management but only the field names shows on the Report output without the actuall data.
when i check the table data from where i get the report, they all contain data. i even tried creating a query with all the fields i need on the report but also does not show contents, though the query opens blank. when i create reports from indivual tables in the same data base it works well
kindly assist,
Regarsd gerry.
below is sample report details,
Management Report
Clearing ID File Number Date Requested Agent Proforma Invoice TZDARN0 IDF N0
Order Inoice N0 Item Supplier Process Level Proforma Invoice date Date Proforma Invoice Amount Invoice
Total Invoice Amount PCVR N0 B/L N0 PCVR Status Accepted Date of PCVR Return CVR N0
Estimated Duty & Tax Assesment ID Date Returned FOB Value Value for Customs Assesment Lodged Total Estimated Tax Duty Date Assessment Lodged
Assesment Additonal Duties Assessment Payment Settled Payment ID Portcharge Settled Date of Settlement Payment Method Payment Amount
Permit Granted Port charges Paid To Release ID Release Type Shipline Date of Submission Expected Arrival Date Actual
Container Deposit Charges Shipline Charges Transport ID Date of Transportation From port Numbe of Containers Type of Container
Transport Charges Tsh Clearing Agent Fee Tsh Paid Date of Payment
i need some assistance concerning reports.
the issue is that i have about ten tables which are related. from the tables i have created a report called Management but only the field names shows on the Report output without the actuall data.
when i check the table data from where i get the report, they all contain data. i even tried creating a query with all the fields i need on the report but also does not show contents, though the query opens blank. when i create reports from indivual tables in the same data base it works well
kindly assist,
Regarsd gerry.
below is sample report details,
Management Report
Clearing ID File Number Date Requested Agent Proforma Invoice TZDARN0 IDF N0
Order Inoice N0 Item Supplier Process Level Proforma Invoice date Date Proforma Invoice Amount Invoice
Total Invoice Amount PCVR N0 B/L N0 PCVR Status Accepted Date of PCVR Return CVR N0
Estimated Duty & Tax Assesment ID Date Returned FOB Value Value for Customs Assesment Lodged Total Estimated Tax Duty Date Assessment Lodged
Assesment Additonal Duties Assessment Payment Settled Payment ID Portcharge Settled Date of Settlement Payment Method Payment Amount
Permit Granted Port charges Paid To Release ID Release Type Shipline Date of Submission Expected Arrival Date Actual
Container Deposit Charges Shipline Charges Transport ID Date of Transportation From port Numbe of Containers Type of Container
Transport Charges Tsh Clearing Agent Fee Tsh Paid Date of Payment
Comment