Alligning data in table format

32 Views

I have a SQL view that contains a Land Plot Number, Person id's along with their details and any associated land Interests, which can be 1 or many and Interest Type boolean field(Freehold, Leasehold, Occupier). If the person is associated with more than one piece of land the view contains repeated person details with new land details. I have designed the report to look like a table by using boxes which span the page header to a group footer. The report is grouped by the Plot Number, I have created 3 formulaes that check for the type of interest and concat the address detail, and inserted them into the detail line. The report works OK the only problem I have is that I need to show the information in the following format (Alligned to top): -

ID Address Type 1 Address Type 2 Address Type 3

1 XXXXXXXX XXXXXXXX XXXXXXXX

XXXXXXXX XXXXXXXX XXXXXXXX

2 XXXXXXXX XXXXXXXX XXXXXXXX

XXXXXXXX XXXXXXXX XXXXXXXX

XXXXXXXX

AND NOT AS IT CURRENTLY RETURNS (Gaps): -

ID Address Type 1 Address Type 2 Address Type 3

1 XXXXXXXX

XXXXXXXX

XXXXXXXX XXXXXXXX

2 XXXXXXXX

XXXXXXXX

XXXXXXXX XXXXXXXX

Hope this makes sense, any advice would be greatly appreciated.

Thanks