Results 1 to 4 of 4
  1. #1
    aSHLEYBECK is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2019
    Posts
    6

    Unhappy Suggestion for only displaying relevant data on a report, shrinking report layout accordingly

    Hello,
    I'm designing a report, that is generated based on a user selection form.
    This form is comprised of multiple subforms.
    Each subform has categories that may or may not be applicable.
    I want to generate a final clean report, that is a formal document, that only shows what is applicable.
    I'm relatively new to access and wanted to get feedback on the best way to do this, if anyone could offer a suggestion I'd be extremely grateful.
    For example:
    Form MAIN has form a and form b.


    Form a has 3 categories. Two of these categories have values (Category FormA-1, Category Form A-2). one is null, as it is not applicable. Then imagine a similar scenario for form b.
    On the report that is generated, all tied together by a corresponding certificate ID through the main and subforms, I only want it to show exactly what is applicable and nothing more. I primarily want the spacing on the report to be reduced so just making "is visible" via VBA won't help as I need it to shrink to only show relevant data.
    Thank you so much for any suggestions.
    Respectfully,
    Ashley

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Not sure I understand issue. If field is not required, don't include it in report design. If records are not relevant then apply filter criteria to exclude.
    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
    aSHLEYBECK is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2019
    Posts
    6
    By default the template will have options for certain criteria, which is applicable to some certificates generated, not to others.

    I guess I don't understand how to exclude not applicable criteria to a report. So if the first item has say "water testing", but the second item doesn't, I only want the first report to show water testing, not the report for the second item. Reports are generated on a per item basis if this helps.

    I'm very sorry for my stupidity on this.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Controls can grow/shrink vertically, but not horizontally.

    If you want to provide db for analysis, follow instructions at bottom of my post.

    I suspect your data structure is not normalized.
    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. Help Displaying Data Horizontally In Report
    By bgwool in forum Reports
    Replies: 10
    Last Post: 09-04-2014, 03:32 PM
  2. Report Layout Issue - Listed data??
    By jcjanssen in forum Reports
    Replies: 2
    Last Post: 04-21-2013, 02:50 AM
  3. Replies: 6
    Last Post: 06-26-2012, 12:16 PM
  4. Displaying Data in a Report
    By im_eric in forum Reports
    Replies: 3
    Last Post: 01-20-2012, 04:43 PM
  5. problem displaying data in report
    By dreamweaver547 in forum Reports
    Replies: 4
    Last Post: 10-15-2010, 04:26 PM

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
  •  
Other Forums: Microsoft Office Forums