How to create a dynamic multipage Crosstab report with about 50 - 60

I want create a report based on the crosstab query which normally
returns about 50 - 60 columns. The columns have names of the counties
and they keep changing for every session. Is there a way to program a
dynamic multi-page crosstab report?

Re: How to create a dynamic multipage Crosstab report with about50 - 60 columns

Niranjan wrote:

> I want create a report based on the crosstab query which normally
> returns about 50 - 60 columns. The columns have names of the counties
> and they keep changing for every session. Is there a way to program a
> dynamic multi-page crosstab report?
>

This link is quite excellent. I think you can apply it to your problem.
http://www.fmsinc.com/tpapers/access/Reports/monthly/index.h tml

Jamie's Crying
http://www.youtube.com/watch?v=Du5QB2hcbog

Re: How to create a dynamic multipage Crosstab report with about 50 -

On Jan 30, 3:29=A0pm, Salad wrote:
> Niranjan wrote:
> > I want create a report based on the crosstab query which normally
> > returns about 50 - 60 columns. The columns have names of the counties
> > and they keep changing for every session. Is there a way to program a
> > dynamic multi-page crosstab report?
>
> This link is quite excellent. =A0I think you can apply it to your problem.=
http://www.fmsinc.com/tpapers/access/Reports/monthly/index.h tml
>
> Jamie's Cryinghttp://www.youtube.com/watch?v=3DDu5QB2hcbog

Thanks Salad for your response. I reviewed the web site. But I think I
need a few more questions answered.

1) I will need at least a 3-4 page report. How do I create the left-
side row header (or identifier) on the 2nd, 3rd and 4th pages?
2) Do I need to create all 60 columns and then hide the 10 - 15
columns based on crosstab query results? What is the best way to do
this?
3) How do I bind the columns?

Re: How to create a dynamic multipage Crosstab report with about 50 -

On 30 Jan, 22:42, Niranjan wrote:
> I want create a report based on the crosstab query which normally
> returns about 50 - 60 columns. The columns have names of the counties
> and they keep changing for every session. Is there a way to program a
> dynamic multi-page crosstab report?

If buiding your report in Excel using a Pivot Table is a possibility,
most problems you mention would vanish.
However it is only usable if you only have numeric data in the value
field.

Patrick
www.idevlop.com