I need help with the crystal report design and implementation. I want to show accident related information on the report. The report will look like below: All the information is grouped on accident id in the database. One accident will have only one site and can have one or more than one comments and injured persons.
From sql query point of view the query will return 4 records. I am thinking I should create one subreport to show comments info and one to show injured person information.
So in total there would be 3 reports needed to output one report.
Is way to implement this without using subreports ??? or subreports is the only way.
Accident ID Site Location
A1 Downtown Arch street
|
CommentId Descr
1 negligence on driver
2 poor visibility
|
Injured_person_name Injured_person city
Mike philadelphia
Steve newyork
|