Report on Crosstab query

Thanks for taking the time to read my question.

I want to make a report that is based on a crosstab query. My only problem
is that I will never know how many columns I will have. I am not sure how to
make a dynamic report like this. Is it possible in Access?

Thanks,

Brad

There are several examples of crosstab style reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. Check the Crosstab.mdb.

--
Duane Hookom
MS Access MVP
--

"Brad" wrote in message
...
Thanks for taking the time to read my question.

I want to make a report that is based on a crosstab query. My only
problem
is that I will never know how many columns I will have. I am not sure how
to
make a dynamic report like this. Is it possible in Access?

Thanks,

Brad

Man, you're all over the place! Thanks so much for the quick reply, and for
all your help on this Forum.

Brad

"Duane Hookom" wrote:

There are several examples of crosstab style reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. Check the Crosstab.mdb.

--
Duane Hookom
MS Access MVP
--

"Brad" wrote in message
...
Thanks for taking the time to read my question.

I want to make a report that is based on a crosstab query. My only
problem
is that I will never know how many columns I will have. I am not sure how
to
make a dynamic report like this. Is it possible in Access?

Thanks,

Brad

Hi Duane,

I took a look at those examples. They both use a predetermined number of
columns. One db was based on the number of months in a year (Max 12) for
number of columns, and the other one had a limit of A-H, or 8 columns max.

Do I just make a really large limit, and then try to hide the column if
there is no data for the category? Then if the user goes over that, then
that's just a limit of the program?

Thanks again.

Brad

"Duane Hookom" wrote:

There are several examples of crosstab style reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. Check the Crosstab.mdb.

--
Duane Hookom
MS Access MVP
--

"Brad" wrote in message
...
Thanks for taking the time to read my question.

I want to make a report that is based on a crosstab query. My only
problem
is that I will never know how many columns I will have. I am not sure how
to
make a dynamic report like this. Is it possible in Access?

Thanks,

Brad

The sample you think had only 8 is designed to show 8 in the report. If
there are over 8, the next group of 8 will "wrap" under the first 8. That
makes up to 16. This will continue to about as many "wraps" as you would
ever need.

I chose 8 columns because that was the maximum number that would fit across
a page. If your data will allow more than 8, you can modify the code and
crosstab to display any number across until you need to wrap.

If you look close, the columns may vary from group to group.

--
Duane Hookom
MS Access MVP
--

"Brad" wrote in message
...
Hi Duane,

I took a look at those examples. They both use a predetermined number of
columns. One db was based on the number of months in a year (Max 12) for
number of columns, and the other one had a limit of A-H, or 8 columns max.

Do I just make a really large limit, and then try to hide the column if
there is no data for the category? Then if the user goes over that, then
that's just a limit of the program?

Thanks again.

Brad

"Duane Hookom" wrote:

There are several examples of crosstab style reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. Check the
Crosstab.mdb.

--
Duane Hookom
MS Access MVP
--

"Brad" wrote in message
...
Thanks for taking the time to read my question.

I want to make a report that is based on a crosstab query. My only
problem
is that I will never know how many columns I will have. I am not sure
how
to
make a dynamic report like this. Is it possible in Access?

Thanks,

Brad

Hi Duane,

I wanted to try this on another DB, but was unable to download the examples
again. Does that link still work, oris there another link now?

Thanks,

Brad

"Duane Hookom" wrote:

There are several examples of crosstab style reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. Check the Crosstab.mdb.

--
Duane Hookom
MS Access MVP
--

"Brad" wrote in message
...
Thanks for taking the time to read my question.

I want to make a report that is based on a crosstab query. My only
problem
is that I will never know how many columns I will have. I am not sure how
to
make a dynamic report like this. Is it possible in Access?

Thanks,

Brad

The link is no longer available. Is there another link?
--
Amanda Kelly


"Brad" wrote:

Hi Duane,

I wanted to try this on another DB, but was unable to download the examples
again. Does that link still work, oris there another link now?

Thanks,

Brad

"Duane Hookom" wrote:

There are several examples of crosstab style reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. Check the Crosstab.mdb.

--
Duane Hookom
MS Access MVP
--

"Brad" wrote in message
...
Thanks for taking the time to read my question.

I want to make a report that is based on a crosstab query. My only
problem
is that I will never know how many columns I will have. I am not sure how
to
make a dynamic report like this. Is it possible in Access?

Thanks,

Brad

I have never found one. Sorry

Brad

"Amanda Kelly" wrote:

The link is no longer available. Is there another link?
--
Amanda Kelly


"Brad" wrote:

Hi Duane,

I wanted to try this on another DB, but was unable to download the examples
again. Does that link still work, oris there another link now?

Thanks,

Brad

"Duane Hookom" wrote:

There are several examples of crosstab style reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. Check the Crosstab.mdb.

--
Duane Hookom
MS Access MVP
--

"Brad" wrote in message
...
Thanks for taking the time to read my question.

I want to make a report that is based on a crosstab query. My only
problem
is that I will never know how many columns I will have. I am not sure how
to
make a dynamic report like this. Is it possible in Access?

Thanks,

Brad

I have a same question as below. Your help are very much appreciated.

Zj


"Brad" wrote in message
...
Thanks for taking the time to read my question.

I want to make a report that is based on a crosstab query. My only
problem
is that I will never know how many columns I will have. I am not sure how
to
make a dynamic report like this. Is it possible in Access?

Thanks,

Brad

Have you seen this site?
http://www.blueclaw-db.com/report_dy...stab_field.htm
It took quite a bit of work but I finally got a really great looking report.
Mich

"Zj" wrote in message
...
I have a same question as below. Your help are very much appreciated.

Zj


"Brad" wrote in message
...
Thanks for taking the time to read my question.

I want to make a report that is based on a crosstab query. My only
problem
is that I will never know how many columns I will have. I am not sure
how
to
make a dynamic report like this. Is it possible in Access?

Thanks,

Brad