Hi. I am working in Crystal and I have some existing reports of ours that have been a great learning tool but I have a question what is the best way to do this.

I want to generate a report of a customer and all their contacts. So this can be anywhere from 1 to an unknown number of contacts, but practically just a handful, let's say 5 or less. There will be a lot of other data on the report. The way I see we are doing this currently is with a subreport. For example, one existing main report we have wants to list a customer's systems so that is a subreport, and the subreport has a Page Header which is the names of the systems columns and Details which are the unknown number of systems rows. The subreport is pulled into the main report.

I can't see another way to take a section and format it this way. In other words, if you run a query in SQL and say select * from tblCustomerContacts, I want the column names and then all the rows just like the resultset is displayed in SQL.

I have no problem doing this as a subreport, just wanted to know this is the best way. I am not pivoting the data or anything, it's very straightforward, just a simple SELECT query. I don't think it's a cross tab.

Thanks!