Results 1 to 8 of 8
  1. #1
    Join Date
    Oct 2010
    Posts
    6

    Unanswered: Crosstab, Pivot Table, Transposing Record Sets

    Here we go again. Does Microsoft provide a way within Access 2007 to accomplish crosstab reporting of a record set? I am not looking to report calculated fields. I want to report transposed selected fields of a record set.

    A typical record set is comprised of six (6) records. Let us say that each record consists of three fields. I want to transpose (crosstab) the record set and achieve a horizontal listing of at least one of the fields from each record; thus, the chosen field from each record becomes a new field in a transposed record. And in the end, we have transposed six(6) records into one(1)record for reporting purposes.

    This transposed record will be used in list the fields from the original six(6) records from left to right on a single line within the Detail Area in a standard report.

    I can achieve this in a Pivot Table View available in Access 2007 at least I think I have; however, I cannot get the view in the Detail Area of the standard report.

    If at all possible, I do not want to start programming to achieve this.

    Any ways out for me? I can explain more but it already a long post.
    Last edited by hmross; 10-14-10 at 13:23.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Moved to Access forum.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Oct 2010
    Posts
    6

    Moved to Access Forum

    Thanks, although I thought that is where I posted it in the first place. Hope I explained it correctly for someone to help. I have read the FAQ and other threads for posting.

  4. #4
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    Create a Cross Tab query and use it as the report's datasource. When you create the Cross Tab query you have to choose which fields will continue to be Row Headings, which become Column Headings and which are Data Values. But it definitely should be possible. I use Cross Tab queries all the time.

  5. #5
    Join Date
    Oct 2010
    Posts
    6

    Cross Tabing

    I tried that method and I will try again because I do not claim to be an expert. It was my understanding that I had to use a function to have the data show up in the cross-tab cell.

    Thanks

  6. #6
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    If you want to share a few records with the before and after I can take a look at it and let you know if it will work.

  7. #7
    Join Date
    Oct 2010
    Posts
    6

    Cross Tabing

    Ok, you are on. I will prepare something and send but I will likely not get to it today--early next week. I have a work around in place but want to get back to cross tabbing with non numerical fields.
    Last edited by hmross; 10-14-10 at 18:19.

  8. #8
    Join Date
    Oct 2010
    Posts
    6

    cross tab

    I have been directed to get a few other tasks done prior to revisiting this one; however, I was able to use report page formatting to arrange the data across the page instead of down the page by using the column options in page layout. This record report arrangement will not show when viewing the output in "Report" view but does show under "Print" preview mode. I will try a sub-report method and embed the sub_report into the main report-hope the page layout will hold true when doing this. I also hope this will provide a work around until I have more time. I don't like it much since I use the "Report View" when working with data and report writing.

    Thanks for the help "I will be back"

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •