Page 1 of 2 12 LastLast
Results 1 to 15 of 16

Thread: Report Question

  1. #1
    Join Date
    Jun 2009
    Posts
    95

    Unanswered: Report Question

    I have a layered report that is set up to be like a letter.

    It has all of the information repeating one time and in the middle it displays certificate numbers, and each letter has a different number of certificate numbers.

    However, these certificate numbers are displayed and printed vertically, causing a new letter to be made when there is no more room. How do I make this field display the certificate numbers horizontally?

    Thanks,
    CT

  2. #2
    Join Date
    Jun 2009
    Posts
    95
    Anybody have any ideas on this?

    Thanks,
    CT

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    What is a "layered report" ?

    You might be able to use columns, but ultimately, vertical listings are normal for database reports, so it will not be easy to make it go horizontal.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Jun 2009
    Posts
    95
    Ignore the layered report comment.

    Does anybody have any ideas on how to make a vertical listing go horizontal?

    Thanks so much,
    CT

  5. #5
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Are you using a sub report?

    Sounds like you have a one-to-many relationship with these "certificates". I assume you're displaying all of them for a given record by way of a sub report?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  6. #6
    Join Date
    Jun 2009
    Posts
    95
    I do not have a subreport, in the detail section, all there is is the certificate number. Based on a unique ID, some reports have 1+ certificate numbers. For IDs that have 15+ certs, the report doesnt wrap the numbers, it creates a new report.

    Make sense?

    Thanks,
    CT

  7. #7
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by CTChris
    I do not have a subreport, in the detail section, all there is is the certificate number. Based on a unique ID, some reports have 1+ certificate numbers. For IDs that have 15+ certs, the report doesnt wrap the numbers, it creates a new report.

    Make sense?

    Thanks,
    CT
    no, it doens't
    I'd rather be riding on the Tiger 800 or the Norton

  8. #8
    Join Date
    Jun 2009
    Posts
    95
    In the header, I have the header for a letter. In the detail I have a text box that displays certificate numbers based on a unique ID assigned to various companies. In the footer, I have the letter.

    The certificate number text box displays the certificate numbers associated with the unique ID/company.

    Each ID/company has a letter generated with this report. Some IDs/companies have multiple certificate numbers. When there are multiples, the certificate numbers are displayed one after another vertically.

    My goal is to get these numbers to display horizontally b/c when there are more than 8 certificate numbers, it generates a new report. I want all certificates for a certain ID/company to be on the same, single report.

    Is that more clear?

    Thanks,
    CT

  9. #9
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    You can do this with a subreport.

    Look in to how the address label wizard is setup. constricting the dimensions of the report can cause it to fill in horizontally as you wish.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  10. #10
    Join Date
    Jun 2009
    Posts
    95
    Would you be able to go into more detail as to how I go about setting that up?

    Thanks a lot,
    CT

  11. #11
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    or create a function which appends all certificate numbers into a single SQL expression
    I'd rather be riding on the Tiger 800 or the Norton

  12. #12
    Join Date
    Jun 2009
    Posts
    95
    How do I go about creating a function that does such a thing?

    Thanks,
    CT

  13. #13
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    private function appendCertificatesIDs(myuniqueidentifier) as string
    'open a recordset based on the specified unique identifier
    that will require some SQL
    eg select certificateID from my table where cusotmerid = blah and invocie period = blahdiblah
    iterate through the recordset (till 'eof reached)
    append any certificate id's t0 the variable appendCertificatesIDs
    I'd rather be riding on the Tiger 800 or the Norton

  14. #14
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    Or you can put the static data in the report header and footer sections, instead of in the group header and footer. Experiment with the "Can Shrink" properties, too. You might end up with one letter spanning multiple pages, but it'll look better.
    10% of magic is knowing something that no-one else does. The rest is misdirection.

  15. #15
    Join Date
    Jun 2009
    Posts
    95
    Thanks for your idea weejas, but I was unsuccessful in my attempts to get that to work.

    Also, healdem, I am extremely new to SQL and any kind of coding. Could you maybe get a little more detailed into what you are suggesting?

    If anybody has any other ideas, please let us all know, this has been a problem for a number of days now for my database.

    Thanks so much,
    CT

Posting Permissions

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