Putting sections side by side

[FionaCondon]

I'm using CR 9. I am doing a report of pupils applying to high schools. The first section is their name, address, date of birth and so on. I have put this in a group header. Then their contacts. They may have more than one, so I have put them in the detail. Then come the names and addresses of the of schools that they are applying to. I have done this in a sub-report in the group footer. For each school they may be several reasons and I want to show these to the right of the name and address:
Name Reason1
Address1 Reason2
Address2 Reason3
Address3 Reason4
Address4 Reason5
I can't do this as a sub-report because I am already in a sub-report. I have tried doing it as a multiple column report but I can't get that to work.
I tried doing the reasons in a separate sub-report but then I could get it to line up properly because I don't know how many there are going to be.

I would be very grateful for any suggestions
Thanks
Fiona

 

[synapsevampire]

What are you demonstrating in the bove example, the entire report or the subreport?

The relationships between the tables is critical to finding the best solution, so try posting technical information:

Crystal version
Database/connectivity used
Example data (show the tables and fields and relationships)
Expected output

It may be that you can join this data in a Union query or some such.

Or you may be able to place anotehr subreport in the name group header and use underlay following sections, or do that to the name field, but it's difficult to say here.

In general subreports should be avoided, but sometimes it's difficult to avoid.

-k

 

[FionaCondon]

Thanks - but apologies for the length of this post:
Crystal Reports V9.0
MSSQL database - it's a 3rd party product so I'm stuck with the structure as it is.

Tables (I have only inlcuded the relevant fields):
tblPupil
PUP_ID
PER_ID

tblPerson
PER_ID
tblLU_PER_TITLE
PER_FNAME
PER_MNAME
PER_SNAME
PER_SEX

tblPUPIL_CONTACT
PUPCON_ID
tblPUPIL
tblCONTACT

tblCONTACT
CONTACT_ID
tblLU_PER_TITLE
CONTACT_FNAME
CONTACT_MNAME
CONTACT_SNAME
CONTACT_SEX
tblLU_CONTACT_TYPE
CONTACT_TEL_DAY
CONTACT_XDIR_DAY
CONTACT_TEL_NIGHT
CONTACT_XDIR_NIGHT
CONTACT_MOBILE
CONTACT_EMAIL

tblCONTACT_ADDRESS
CAD_ID
tblCONTACT
tblADDRESS

tblADDRESS
ADR_ID
ADR_NUMBER
ADR_STREET
ADR_LOCALITY
ADR_TOWN
ADR_COUNTY
ADR_POSTCODE

tblPUPIL_ADM
ADM_ID
tblPUPIL
tblSCHOOL
tblLU_ADM_PrefType

tblLU_PUP_ADMREASON
rcd_id
tblPUPIL_ADM
tblLU_ADM_REASON

tblLU_ADMREASON
RC_ID
RC_DESC

tblLU_ADM_PrefType
PT_ID
PT_DESC
PT_RANK

tblSCHOOL
SCH_ID
tblADDRESS
tblLU_SCH_LEA
SCH_NAME

Output - two pages for each pupil:
Pupil details
Name
Date of birth
Address
Address
Address
Postcode
Phone nos
etc

Contact name
Contact address
Contact phone nos
etc

Contact name
Contact address
Contact phone nos
etc
(repeated for as many contacts there are)

Preference rank (sorted on preference rank)
School name Reason1
School address1 Reason2
School address2 Reason3
School address3 Reason4
School address1 Reason5

Preference rank
School name Reason1
School address1 Reason2
School address2 Reason3
School address3 Reason4
School address4 Reason5
(repeated up to 6 times for each preference school)
There could be any number of reasons for each school but in practice not more than about 3. I could live with it being out of alignment in the unsusual circumstance of there being more than 5.

Hope this helps
Fiona