467,890 Members | 1,593 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,890 developers. It's quick & easy.

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


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?

Jan 30 '08 #1
  • viewed: 3212
Share:
3 Replies
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...hly/index.html

Jamie's Crying
http://www.youtube.com/watch?v=Du5QB2hcbog
Jan 30 '08 #2
On Jan 30, 3:29*pm, Salad <o...@vinegar.comwrote:
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...hly/index.html

Jamie's Cryinghttp://www.youtube.com/watch?v=Du5QB2hcbog
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?
Jan 31 '08 #3
On 30 Jan, 22:42, Niranjan <nhi...@gmail.comwrote:
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
Jan 31 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Don Lee | last post: by
3 posts views Thread by deejayquai | last post: by
reply views Thread by Orchid | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.