Hi,
For my aircraft spotting hobby I compiled a list of aircraft I've seen or still need to see for certain Airlines. Now I want to print a report on special sized paper for aan Success Agenda. The report is based on this query:
The report is grouped on fldAirlineName (left red left in image below)and then on fldAircraftType (blue in left image below). As I don't want airlinename and aircraft type to be included in the colum I designed a subreport. I now base the number of columns (7) in the subreport on the longest registration. Like the ones from Belavia (on right image below). But most registrations have length like the one from Austrian and can fit in 8 columns and few even in 9 columns. Is there a way to make the number of colums variable in the subreport? E.g. default to 8 colums, but if airline name is 'Belavia' make it 7 or when name is 'Cathay Pacific' make it 9 columns? Because as it is now it takes about 10 more pages to print as when I had it in Word with 7, 8 and 9 registrations per row.