Archives of the TeradataForum
Message Posted: Tue, 18 Jun 2002 @ 16:18:44 GMT
Following approaches can be taken regards to building reports from MS Access:
1: Using ODBC to connect to Teradata tables (Link table) and write your reports. If there is any aggregations or MS function applied to the data set, then the large set of data will be transferred to the user pc before functionality been applied. This often results in poor performance.
2. Create pass-through query in access using Teradata SQL, this will only bring back the rows that displayed on the report and much of the processing will be done in Teradata. This would be author recommended option.
3. Use ADO record set make snapshot of the data required for report and manipulate the data with vba code for report presentation.
Hope this helps!!!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|