[AccessD] Dynamic Crosstab Reports (multi-page)

[John Colby]

I third the motion.  Excel does stellar crosstabs.

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
>


-- 
John W. Colby
Colby Consulting