I need to create a subreport (the second of two in the detail section) that contains four columns. I want to use the down/across option.
So far, the subreport will not create four columns. It creates only one UNLESS I change the CanGrow property of the subreport control to No to limit its size to what I have actually drawn on the detail section. The problem with this is that Access limits the number of records that are displayed and will not produce additional pages. So if I set the height to accommodate 6 rows by 4 columns, I see 24 records. But if the client has 25, I'm SOL so that doesn't work. I tried changing to the across then down which does produce the four columns and will paginate correctly but it confuses the user. He has been using a FoxPro report for 15 years and doesn't want to change how it looks.
Does anyone have any ideas for another alternative? I was thinking about trying to use Excel but my head started spinning. I might give it a whirl if I had only the one subreport but I have two so getting it to populate correctly is well beyond my ability to automate Excel.