Hi, I've created a report using Active Data(TTX). I am passing a recordset to this report form VB. My problem is that the report generates repeated data for fields that have the "same name". Below is my TTX file:
***************************
; Field definition file for table: ADORecordset
Name string 50 John Smith
StreetAddress string 100 13234 - 20 Ave
City string 25 Surrey
StateProvince string 50 BC
ZipPostal string 20 V6V 1X1
Telephone string 25 604 123-4537
Fax string 25 604 202-3330
Email string 50 js @home.com
Name string 50 North America
Name string 50 Canada
***********************************************
The 3 "Name" fields are from 3 different tables.
e.g Agent.Name, Region.Name and Country.Name
The report only displays "John Smith" 3 times and not "North America" or "Canada"
Please help!!
***************************
; Field definition file for table: ADORecordset
Name string 50 John Smith
StreetAddress string 100 13234 - 20 Ave
City string 25 Surrey
StateProvince string 50 BC
ZipPostal string 20 V6V 1X1
Telephone string 25 604 123-4537
Fax string 25 604 202-3330
Email string 50 js @home.com
Name string 50 North America
Name string 50 Canada
***********************************************
The 3 "Name" fields are from 3 different tables.
e.g Agent.Name, Region.Name and Country.Name
The report only displays "John Smith" 3 times and not "North America" or "Canada"
Please help!!