Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Report with multiple subreports - complex problem
Message
General information
Forum:
ASP.NET
Category:
Reporting
Environment versions
Environment:
C# 3.0
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01419224
Message ID:
01419636
Views:
34
>>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.

Here is a link of implementing the concatenation idea - http://forums.asp.net/p/1442148/3269215.aspx#3269215
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform