troubleshooting Question

how to bind multiple values to a data report field?

Avatar of palakala
palakalaFlag for United States of America asked on
Visual Basic Classic
15 Comments1 Solution201 ViewsLast Modified:
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.

index: 1
name: Tom
phoneNumber: 1234

index: 1
name: Tom
phoneNumber: 5678
  I want the phone numbers for each index to be displayed in a single record like:

index:1
name: Tom
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.
 
ASKER CERTIFIED SOLUTION
Éric Moreau
Senior .Net Consultant
Join our community to see this answer!
Unlock 1 Answer and 15 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros