multicolumn report

[Laura]

Hi,

I have data that I would like to present in the following
manner in a report:

LOCATION LOCATION 1 LOCATION 2
Date xx/xx/xxxx yy/yy/yyyy zz/zz/zzzz
parameter1 xxx yyy zzz
parameter2 xxx yyy zzz
parameter3 xxx yyy zzz
etc

I can get it to print out in columns, that isn't a
problem. What I AM having trouble with is that the column
labels (Date, parameter1, parameter2, etc) keep repeating
between the results column. I would really like these to
only show up on the left hand side of each page. Is there
a way to do this easily? Do I need to make subreports for
this?

Please help!

Laura

 

[Gary Miller]

Laura,

Depending on exactly what your data is, this may be a
candidate for a 'crosstab' ( or pivot ) query. Check out
Help on this. The query wizard can help you build it.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[Guest]

Hi Gary,

I'm not sure if a cross-tab report would work. Maybe if I
explain the data a little better it might help?

I have a table that has information set up under column
headings location, date, and various parameters - we'll
use shirts, shorts, and socks as parameters. I have more
than one date per location. I have a query that tests the
table and selects only the parameters I'm interested in.

Right now, I have it set up in a multi-column report that
looks like this:

(labels) [textboxes]
Location [Location]
Date [Date]
Shirts [Shirts]
Shorts [Shorts]
Socks [Socks]

and it's set to print as a multicolumn report on an 8 1/2
x 11 page, so that I can get the information repeated
across the page. This part works fine, except that it
keeps repeating the labels at the beginning of each
column, when really I just want the labels as indicators
on each page. I'm not running any sums, etc on the data.
Just want to display all data for each location for each
date for each parameter.

Is there a way to do this using cross-tab queries? I've
looked at those, but they don't seem to be able to help
me. If I'm just crazy (quite likely), can you give me
some more direction? Thanks again.

Laura

 

[Gary Miller]

I am not sure if it would work yet as I am not clear the
relationship between the locations and dates. Are there
multiple dates per location or multiple locations per date?
If so, it may not. In your example here...

LOCATION LOCATION 1 LOCATION 2
Date xx/xx/xxxx yy/yy/yyyy zz/zz/zzzz
parameter1 xxx yyy zzz
parameter2 xxx yyy zzz
parameter3 xxx yyy zzz
etc

I can't really tell if the x's and y's are different dates.
A crosstab would definitely work if there were just date or
just location and still may depending on the relationships.

Here is another thought on the side. You seem to be saying
your report is basically serving well and it is only the
labels that are annoying as they repeat. This may be a
method to lose them and still have it very understandable.
One of the drawbacks on totally losing the labels on all the
columns except for the first is that the way columns work,
parameter1 in col1 is often going to be at a totally
different line than a parameter1 in the 2nd or 3rd column.

Would this work in all the columns?...

Location1
11/1/2003
23 Shirts
52 Shorts
122 Socks

If so, lose the labels totally and for the location and date
the controls remain the same. For the others you would need
to change the control source from Shirts to =[Shirts] & "
Shirts", etc... for the other categories. You would now get
the identical output in each column. Another option would be
to group the report by location and show the dates or by
dates and show the locations.

I am sure that there are some subform solutions as well.
--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

Hi Gary,

I'm not sure if a cross-tab report would work. Maybe if I
explain the data a little better it might help?

I have a table that has information set up under column
headings location, date, and various parameters - we'll
use shirts, shorts, and socks as parameters. I have more
than one date per location. I have a query that tests the
table and selects only the parameters I'm interested in.

Right now, I have it set up in a multi-column report that
looks like this:

(labels) [textboxes]
Location [Location]
Date [Date]
Shirts [Shirts]
Shorts [Shorts]
Socks [Socks]

and it's set to print as a multicolumn report on an 8 1/2
x 11 page, so that I can get the information repeated
across the page. This part works fine, except that it
keeps repeating the labels at the beginning of each
column, when really I just want the labels as indicators
on each page. I'm not running any sums, etc on the data.
Just want to display all data for each location for each
date for each parameter.

Is there a way to do this using cross-tab queries? I've
looked at those, but they don't seem to be able to help
me. If I'm just crazy (quite likely), can you give me
some more direction? Thanks again.

Laura

-----Original Message-----
Laura,

Depending on exactly what your data is, this may be a
candidate for a 'crosstab' ( or pivot ) query. Check out
Help on this. The query wizard can help you build it.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________



.