[AccessD] Dynamic Crosstab Reports (multi-page)

[David Emerson]

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