Results 1 to 9 of 9
  1. #1
    jim.thornton is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2020
    Posts
    29

    Is it possible to generate custom reports

    Is there a way to generate a custom decorative report in Access? Basically, I want to "present" the data in a very attractive way.

    Basically, I would put in descriptions and decorative images and sprinkle some of the information around. However, I will show some tabular data as well when listing the information that I used for the calculated fields.



    Or, is it only possible to generate tabular reports?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,770
    Can ''customize" with embedded images and rearrange controls however you want.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,026
    As June says you can customize as you wish. And, as a friend of mine used to say -It's just SMOP! The degree of customization has to be tempered with time/cost to customize and the associated benefit to the user/company.


    *S
    mall matter of programming

  4. #4
    jim.thornton is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2020
    Posts
    29
    Awesome! thanks... I assumed that and am spending a ton of time getting this DB going the way I want and thought I should ask if I can even do the types of reports that I want. So good to know.

    SMOP??

    I assume multiple page reports are okay then too? I'm thinking of like 10 pages or so (as one report -- not 10 different ones).

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,770
    Depends what you mean by 10 pages - 10 records, 1 for each page, then yes. Or 9 page break controls.

    Report (and form) has 22 inches width and length available to design within.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    jim.thornton is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2020
    Posts
    29
    Quote Originally Posted by June7 View Post
    Depends what you mean by 10 pages - 10 records, 1 for each page, then yes. Or 9 page break controls.

    Report (and form) has 22 inches width and length available to design within.
    I was referring to a report that is a 10-page PDF that has a bunch of different information compiled from a number of tables. As well as calculated fields (calculated from multiple fields within the tables).

  7. #7
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,770
    I am not sure what you mean by a '10-page PDF' - you want the report to output 10 pages to a pdf? How are those pages defined? Again, 22-inch square design area.

    A report can generate as many pages as needed to output records.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  8. #8
    jim.thornton is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2020
    Posts
    29
    Quote Originally Posted by June7 View Post
    I am not sure what you mean by a '10-page PDF' - you want the report to output 10 pages to a pdf? How are those pages defined? Again, 22-inch square design area.

    A report can generate as many pages as needed to output records.
    I'm not sure how else I can explain this. I want to have multiple pages:

    #1 - Household information
    #2 - Listing Assets & Liabilities
    #3 - Show some graphs based on the assets & liabilities

    etc, etc.

    Each page would be 8.5" x 11"

    I want to be able to click a button and then create a PDF.

    If that doesn't work, then I can probably export a CSV file or something and create a Microsoft Word document with fields to import the data if that is better and then the person can print a report from there (as PDF).

  9. #9
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,770
    Then perhaps you need 10 subreports with page break control between each.

    Or 10 reports and each exports as individual PDF and more code combines the individual PDF files into a single PDF file.

    Or Word merge as you suggest.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. How to generate two reports from one query
    By robertedmundwalker in forum Reports
    Replies: 3
    Last Post: 12-18-2018, 03:42 PM
  2. Generate custom REPORT from FORM elements
    By sud2017 in forum Forms
    Replies: 2
    Last Post: 11-21-2017, 05:13 PM
  3. Replies: 2
    Last Post: 02-24-2017, 03:40 AM
  4. Using reports to generate postcards
    By csmith in forum Reports
    Replies: 2
    Last Post: 09-10-2016, 05:28 PM
  5. Generate reports by frequency
    By MFS in forum Programming
    Replies: 2
    Last Post: 11-18-2010, 08:09 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 - Senior Forums