>
>The report lists jobs. Each job can have multiple customers (so customers and some other info is in subreport). Each customer can have multiple phones but only one address.
>>
>>See attached for the report layout.
>>
>>I need to show phones close to the Address (the SubReport).>
>Now I see what the issue is. Unfortunately, I cannot think of any ideas within Crystal that would solve it. The only idea I came up with was to create a local view in the database that joins the customer and phone tables so that the subreport can work off of the view instead.
The report uses datasets.
I can not think of any idea either except for pivoting the phones (assuming 5 phones as the maximum) and use these 5 fields in the report. That actually was the original data structure.
Alternatively, I may try to create a CHAR(13) delimited AllPhones field using concatenation idea in SQL Server - this actually looks like a promising solution and should work well for my purposes - since I currently don't have extra DataSet for phones. This way I can simply add an extra field to Customers dataset.
Thanks again - sounds like a plan.
If it's not broken, fix it until it is.
My Blog