Hi,
Hoping someone can help me find better approach to a custom report.
I found detail data that would work but.... in three tables without common indexes the report is so slow - it's not useable.
Below is the source data I've been using - to get invoices and any payments.
Rpt Name.......From Table......From Field
Name...........ARHistHead......BillToName
CustID.........ARHistHead......CustomerNo
Address........ARHistHead......BillToAddress
City...........ARHistHead......BillToCity
State..........ARHistHead......BillToState
Zip............ARHistHead......BillToZipCode
InvoiceNo......ARHistHead......InvoiceNo
InvoiceType....ARHistHead......InvoiveType
TermsCode......ARHistHead......TermsCode
TermsCodeDesc..ARTerms.........TermsDescription
InvoiceDate....ARHistHead......InvoiceDate
TranDate.......ARHistHead......TransactionDate
InvcAmt........ARHistHead......TaxableSalesAmt + NonTaxableSalesAmt+ FreightAmt + SalesTaxAmt
OpenAmt........ARCashRcpt......InvoiceBalance
PayDate........ARCashRcpt......PostingDate
PayType........ARCashRcpt......TransactionType
PayAmt.........ARCashRcpt......CashAmountApplied
DiscAmt........ARCashRcpt......DiscountAmountApplied
I've tried the report Wizard and ODBC, but as soon as I start joining the tables it gets slow like a glacier.
Just to get by, I've been dumping the tables individually and building a temporary report inside MS Access.
Thanks in advance for any ideas...
bordway
Bruce O
Hoping someone can help me find better approach to a custom report.
I found detail data that would work but.... in three tables without common indexes the report is so slow - it's not useable.
Below is the source data I've been using - to get invoices and any payments.
Rpt Name.......From Table......From Field
Name...........ARHistHead......BillToName
CustID.........ARHistHead......CustomerNo
Address........ARHistHead......BillToAddress
City...........ARHistHead......BillToCity
State..........ARHistHead......BillToState
Zip............ARHistHead......BillToZipCode
InvoiceNo......ARHistHead......InvoiceNo
InvoiceType....ARHistHead......InvoiveType
TermsCode......ARHistHead......TermsCode
TermsCodeDesc..ARTerms.........TermsDescription
InvoiceDate....ARHistHead......InvoiceDate
TranDate.......ARHistHead......TransactionDate
InvcAmt........ARHistHead......TaxableSalesAmt + NonTaxableSalesAmt+ FreightAmt + SalesTaxAmt
OpenAmt........ARCashRcpt......InvoiceBalance
PayDate........ARCashRcpt......PostingDate
PayType........ARCashRcpt......TransactionType
PayAmt.........ARCashRcpt......CashAmountApplied
DiscAmt........ARCashRcpt......DiscountAmountApplied
I've tried the report Wizard and ODBC, but as soon as I start joining the tables it gets slow like a glacier.
Just to get by, I've been dumping the tables individually and building a temporary report inside MS Access.
Thanks in advance for any ideas...
bordway
Bruce O