[AccessD] Dynamic Crosstab Reports (multi-page)

[Ryan W]

I managed to fit 40 columns on the report, the labels are vertical and the
columnar data is simply an X to show this specific thing applies to that
row/column combo.

If the data generated has less columns, the looping code doesn't run for
the columns above rst.fields.count -1 to set them visible or set a
controlsource.

The form that runs the report does have some logic that IF there were a
query with more than 40 columns/fields, it would simply bring up the query
in a query view/datasheet view, otherwise it brings the report up.



On Sat, Jul 23, 2022 at 4:59 PM David Emerson <newsgrps at dalyn.co.nz> wrote:

> Another option is to have two versions of the report in Access.  One with
> 10
> columns, 1 with 20.  Check how many columns you have and select the report
> that fits.
>
> Regards
>
> David Emerson
> Dalyn Software Ltd
> Wellington, New Zealand
>
>
>
> -----Original Message-----
> From: AccessD <accessd-bounces+newsgrps=dalyn.co.nz at databaseadvisors.com>
> On
> Behalf Of John Colby
> Sent: Sunday, 24 July 2022 12:51 am
> To: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
> Subject: Re: [AccessD] Dynamic Crosstab Reports (multi-page)
>
> 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
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>