[AccessD] Dynamic Crosstab Reports (multi-page)

[Arthur Fuller]

I faced a similar problem recently, too. After much experimentation, I
decided to forget about the Access report side of things and instead
concentrate on the Excel approach. Somebody on this list suggested that I
set a reference to Excel in the Access app, and that kicked open the
floodgates. Suddenly I had Excel-Intellisense from within Access, and that
changed everything. I'm now of the opinion that for complex reporting
needs, Access is simply the wrong tool. Excel was designed for this sort of
task.

On Fri, Jul 22, 2022 at 1:47 PM Ryan W <wrwehler at gmail.com> wrote:

> Hey all,
>   I've got a crosstab report that can have a dynamic amount of columns,
> based on the criteria input.
>
>  Viewing this data in a query or datasheet type view works well,but I'd
> like to put it into a report.
>
>  I've got the Report_Open event adding captions to labels for the column
> headers and the data in the detail view (textbox control source), however
> if the crosstab goes over my 10 labels/control width how can I make sure
> page 2 (or page N, if the report paginates itself because of vertical data)
> has the next set of 10 columns, and so on?
>
> Is this possible or am I better off just exporting the query to Excel?
>
> I tried to google "dynamic crosstab report" but didn't find one that showed
> what to do if you have more columns than control space on a single page.
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Arthur