I would like to create columns in a report, but in the detail section only (allowing the Group Header control to be any size I like and to be above the detail section) Is there a way to do this? I am using both A2003 and A2007 with W7 OS.
I would like to create columns in a report, but in the detail section only (allowing the Group Header control to be any size I like and to be above the detail section) Is there a way to do this? I am using both A2003 and A2007 with W7 OS.
my interpretation of your post - is that what you describe is the normal layout of a report.
so probably I don't understand. are you having difficulty in getting this layout? or are you just beginning to explore the capability of the reports features?
when you say 'create columns' - the fields of the detail section are the fields from the underlying table/query; that can be placed side by side to create columns - so to speak. obviously I don't totally follow what you are saying ....
Another way of saying it is that when I set the page layout for columns, Access includes the Group Header in the columns. I want the group header to be independent of the column setup. I am striving for a format basically like an outline format below, but the group header "insists" on being in the first column and is limited by the width chosen for the column. This is what I am trying for. Possible?
I guess still another way of saying it is that I want the group header to act like a report header would act in a columned report.
My Group header text at any length I want
xxxxx xxxxx xxxxx xxxxx xxxx
xxxxx xxxxx xxxxx xxxxx xxxx
xxxxx xxxxx xxxxx xxxxx xxxx
My Group footer text
Next group header text etc.
I must be thick this a.m. - as what you display is the norm......
when you say "Access includes the Group Header in the columns" - - -if you used the report wizard during set up then this would not be the case. but in any case one can move/delete a field from the detail section and put it in the header section....
hope this helps.
Hi we probably are not comunicating yet. I just found a posting by Coolpapabell (08- 21 2009) that asked the same thing but got no replies, so maybe there is no answer. If start with a simple table like this.
Header Item
headerA alpha
headerA beta
headerA charlie
HeaderA delta
Then try to generate a columend report that looks like this:
HeaderA
alpha beta
Charlie delta
Access shows no header position but puts "HeaderA" where alpha is and restrcts its length to the field size of item
In other words, you get this when asking for columns
Heade alpha
beta charlie
delta
I tried the wizard in a2007, there was no option for columns, so got the same result with the additional frustration that it creates a big blank section before the first line of text..
I too would like an answer to this question... anyone have any luck?
I want to turn
Header 1
detail 1a
detail 1b
detail 1c
Header 2
detail 2a
detail 2b
detail 2c
into
Header 1
Detail 1a detail 1b detail 1c
Header 2
detail 2a detail 2b detail 2c
... currently I get something along the lines of
Header 1 Detail 1c Detail 2b
Detail 1a Header 2 Detail 2c
Detail 1b Detail 2a
try cross tab - that is fundamentally what you are transforming toward...
Thanks for the response.
Unfortunately, I wanted the formatting etc. provided by a report rather than a query.
I ended up taking another approach on this task. (Basically hard-coded all the columns and each row).
Probably a bit late, but does this help:
http://office.microsoft.com/en-us/ac...001156534.aspx
Thanks. I solved it, but don't remember now what I did. Access is a never ending learning experience and help from this site is the only thing that saves me.