Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Expanding Columns in a Report (Access 2000)

    I have a category report that seems to subtract a column after you select more than 6 of the categories. I've attached a sample. So if you open up the "frmSelectCategories" form, then select six categories, click "Next", then select option "Category Report - Crosstab", and click "run report"--now you can see that only five categories are listed there even though there is room on the page for another column or two. I don't know why it's doing this.

    One other thing...is there any way to make this report continue on the next page with the columns if you select more than will fit horizontally on the page? And I guess I have one more question...can the headings be set up to print on the next line if they are longer than a certain number of characters? You should be able to see that some of the headings of the columns are cut off because the name is too long. Can you make it go down a line if the characters are longer than the field box, but have it break at a space? I hope I'm being clear enough.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Expanding Columns in a Report (Access 2000)

    Your tables are attached tables and are not in the attached db.
    Can you provide a db with sample data ?
    Francois

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Expanding Columns in a Report (Access 2000)

    You will need to provide the BE database as well.

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Expanding Columns in a Report (Access 2000)

    Oops! Sorry. Here's the tables.

  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Expanding Columns in a Report (Access 2000)

    It works for me for up to 8 chosen categories.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Expanding Columns in a Report (Access 2000)

    The report as currently designed has room for 8 categories (plus the total).
    Not all categories have data in the database you attached, for example there are no records in tblInvoiceDetails for Refund ECS (FeeID=11). So if you tick the check box for Refund ECS in frmSelectCategories, there will be no column for it in the report, so you get one column less than you expected.

    See <post#=35485>post 35485</post#> for an example of a report based on a crosstab query with an unlimited number of columns.

    You can increase the height of the labels in the page header section of the report, long captions will wrap automatically. A height of about 0.3 inches is enough for 2 lines of text. Don't forget to move the line under the labels down.

Posting Permissions

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