I have a set of core data that has a one to many with 3 other tables. I need to put together a report that shows the core data followed by each of the other 3 sets of data, each in it's separate space.
In an old MS Access world, I would create the main report and a subreport for each of the 3 tables all related by core ID and combine into a single report. Can anyone offer suggestions on how I would accomplish this with ASPRunner?
Thanks in Advance!
Stan
Example:
This is generated in one report
[Core Data]
Postion Number1 Date Department Funding
[Advertisement Table] (linked by Position Number to Core Data)
Advertisement1 Date Type Cost
Advertisement2 Date Type Cost
Etc.
[Interview Table] (linked by Position Number to Core Data)
Interview1 Date Candidate Name
Interview2 Date Candidate Name
Etc.
[Offer Table] (linked by Position Number to Core Data)
Candidate Name Offer date Status
____
[Core Data]
Postion Number2 Date Department Funding
[Advertisement Table] (linked by Position Number to Core Data)
Advertisement1 Date Type Cost
Advertisement2 Date Type Cost
Etc.
[Interview Table] (linked by Position Number to Core Data)
Interview1 Date Candidate Name
Interview2 Date Candidate Name
Etc.
[Offer Table] (linked by Position Number to Core Data)
Candidate Name Offer date Status
___
Etc.
