I have a database I am building that is for a police department. On the
report I need it to display the following information:
Date of Incident, Offense discription, Narrative, Offender/s, victim/s,
etc.
The problem I am having is that when I run my report, if I have more
than one offender listed and no victim, it displays the offender info
correctly. If I have more than one offender and victim it seperates the
data and displays 2 reports each with only a single offender and victim
on it.. How can I get it to list like this:
Offense---------------Date---------------Report Number(Report Number
header)
Offender(Offender Header)
Offernder1
Offender2
Victim(Victim Header)
Victim1
Victim2
Narrative(Detail)
Red - 04 Jan 2006 22:14 GMT
How is/are your table(s) setup?
This is just a suggestion..... normalize your tables, then try again =)
(No offense meant.... lord knows I'm horrible at normalizing tables
until I really really hafta ;) )
I would do like this:
Table: Offenders
OffenderID - Number (make your own, or use some sort of ID)
OffenderLName - Offender Last Name
OffenderFName - Offender First Name
Table: Victims
VictimID - Number (make your own, or use some sort of ID)
VictimLName - Offender Last Name
VictimFName - Offender First Name
Table: Incidents
IncidentID - Number (make your own, or use some sort of ID)
IncidentDate - (Duh)
IncidentNarrative - Details of what happened?
Table: IncidentDetails
IncidentID
OffenderID
VictimID
Then you can make much easier reports, and your information is easier
to search and sort =)
~Red
Bart Swisher - 04 Jan 2006 22:19 GMT
No offense taken.. That is exacty how I have my tables setup. What is
happening on the report at the moment is.
Offender1
Victim1
Victim2
Offender2
The report grouping is setup with a report number header, a offenderID
header, and a VictimID header.. I have the victims grouping together
but the offenders seperate for some reason. I have both groupings
identical and both are set to can grow= yes.
I am stumped
Bart Swisher - 04 Jan 2006 22:22 GMT
No offense taken.. That is exacty how I have my tables setup. What is
happening on the report at the moment is.
Offender1
Victim1
Victim2
Offender2
The report grouping is setup with a report number header, a offenderID
header, and a VictimID header.. I have the victims grouping together
but the offenders seperate for some reason. I have both groupings
identical and both are set to can grow= yes.
I am stumped