I have a custom query that JOINs various tables of data and outputs between 1500 and 3000 lines. In a very simplified example, this is what the query outputs…
┌──────┬───────┬───────────────────────┬─────────────────┐
│ line │ co_id │ co_name │ contact │
├──────┼───────┼───────────────────────┼─────────────────┤
│ 1 │ 1 │ A.B.C Repairs │ John Stevens │
│ 2 │ 1 │ A.B.C Repairs │ Fred Truss │
│ 3 │ 2 │ Grove Bodyworks │ James Archibald │
│ 4 │ 2 │ Grove Bodyworks │ Jean Bryers │
│ 5 │ 2 │ Grove Bodyworks │ Tony Flynn │
│ 6 │ 3 │ High Street Car Paint │ Peter Ahmed │
│ 7 │ 3 │ High Street Car Paint │ Kash Ahmed │
│ 8 │ 4 │ London Repair Shop │ Peter Jones │
│ 9 │ 4 │ London Repair Shop │ Robert Jones │
│ 10 │ 4 │ London Repair Shop │ Heath Probert │
│ 11 │ 5 │ Newport ARC │ Steve Abraham │
└──────┴───────┴───────────────────────┴─────────────────┘
My problem, and I am sure there is a very simple answer, is that I want the result to be printed to screen like this…
A.B.C Repairs
John Stevens
Fred Truss
Grove Bodyworks
James Archibald
Jean Bryers
Tony Flynn
High Street Car Paint
Peter Ahmed
Kash Ahmed
London Repair Shop
Peter Jones
Robert Jones
Heath Probert
Newport ARC
Steve Abraham
So the Company Name is like a Category and the Contacts are like Products. I just can’t get my head around how to set-up the Server Connect and the Repeat properties to get this result, can you throw some light on it?
Community Page
Last updated:
Last updated: