Archives of the TeradataForum

Message Posted: Tue, 18 Jun 2002 @ 16:18:44 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

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!!!

Ganesh

	<Prev	Next>		<<First	<Prev	Next>	Last>>