By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,471 Members | 2,192 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,471 IT Pros & Developers. It's quick & easy.

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

P: n/a

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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.