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:
01419615
Views:
49
>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.
Jon Rosenbaum
Devcon Drummer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform