Results 1 to 11 of 11
  1. #1
    gg80 is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Posts
    328

    Columns in Report Detail Section only


    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.

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    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 ....

  3. #3
    gg80 is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Posts
    328
    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.

  4. #4
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    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.

  5. #5
    gg80 is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Posts
    328
    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..

  6. #6
    Dunro is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2011
    Location
    Toronto, Canada
    Posts
    39
    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

  7. #7
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    try cross tab - that is fundamentally what you are transforming toward...

  8. #8
    Dunro is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2011
    Location
    Toronto, Canada
    Posts
    39
    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).

  9. #9
    ccordner is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Nov 2011
    Posts
    65
    Probably a bit late, but does this help:

    http://office.microsoft.com/en-us/ac...001156534.aspx

  10. #10
    SteveFish is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jul 2014
    Posts
    1
    Quote Originally Posted by gg80 View Post
    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.
    In page setup > columns uncheck 'Same as Detail' then make the report as wide as you need while still having set column widths.


    Click image for larger version. 

Name:	pagesetup.PNG 
Views:	11 
Size:	32.7 KB 
ID:	17435

  11. #11
    gg80 is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Posts
    328
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 26
    Last Post: 11-06-2009, 10:16 AM
  2. Replies: 1
    Last Post: 10-11-2009, 08:31 PM
  3. report detail duplication
    By archie in forum Reports
    Replies: 5
    Last Post: 09-17-2009, 08:51 PM
  4. columns for group detail but not group header?
    By Coolpapabell in forum Reports
    Replies: 0
    Last Post: 08-21-2009, 08:53 AM
  5. Space Between Header and Detail in Report
    By tigers in forum Reports
    Replies: 3
    Last Post: 06-23-2009, 12:01 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums