The results of my query display the output in rows. Each row of data belongs to an entity and contains about 12 fields. I would like to generate a report that lists the entity and its corresponding data below it, in a column format.
Instead of:
companyname1 contact1 phone1 email1 address1
companyname2 contact2 phone2 email2 address2
companyname(n) contact(n) phone(n) email(n) address(n)
I would like to have the info reported as follows:
companyname1
contact1
phone1
email1
address1
companyname2
contact2
phone2
email2
address2
How do I do this? If I can get the query data displayed this way, I can export it to another program to do the last of the formatting. I also have tried using Microsoft SQL Server Report Builder with the table/matrix format and with the list
option. The list option sort of works, but doesn't look very good. Any ideas?
View Complete Post