I have an ADO Record set which I am binding to a data report at run time. For example I have a query like: SELECT n.index, n.name, p.phonenumbers FROM names n, phones p WHERE n.index=1 and p.index=n.index
I have binded the resulting recordet with textboxes on the data report(index, name, phoneNumber). Since there are multiple phone numbers against an index I am getting multiple records for same index.
I want the phone numbers for each index to be displayed in a single record like:
PhoneNumber: 1234, 5678
How can I do this in a report. I certainly want to use data report since I want printing and export functionality. If I do it as in the first case it will generate m * n records if there are 2 multivalued fields with m and n values for each field respectively. I am new to VB and any ideas are welcome.