Results 1 to 2 of 2
  1. #1
    SWG is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    8

    Only want the Sub-Report to be printed ( Access 2007)

    I have created a Report & a Sub-Report for the same query, but i would like to see only the Sub-report summary (results) on the Report View. I have try to delete the main Report part of it but the Sub-Report result is not moving to the top of the Report View ( Sub-Report results appearing it below middle of the page).

    Basically, I am trying to only print out the Summary (stats) , such as Average,Max, Min, Total,etc. from the Query that i created. I don't want to include any of the columns and rows.



    I also try to make Report part to be Invisible, Which making the top part of the Report View to be blank space.


    Please tell me if know how to solve this issue, Thanks for your time.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,619
    If report and subreport use the same query as source why have subreport? Use report grouping & sorting with aggregate calcs instead of doing aggregate calcs in query. Aggregate calcs in group or report footer. Set the Detail section to not visible.
    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. Hiding Subtotals in Access 2007 Report
    By kristyspdx in forum Reports
    Replies: 8
    Last Post: 11-30-2011, 11:46 AM
  2. Ms Access 2007 report export to excel 2007
    By Stan2man in forum Access
    Replies: 6
    Last Post: 11-23-2011, 01:24 PM
  3. Replies: 1
    Last Post: 08-25-2011, 06:50 PM
  4. Replies: 1
    Last Post: 08-16-2011, 10:24 AM
  5. Access 2007 Report footer
    By mab in forum Access
    Replies: 1
    Last Post: 05-16-2011, 09:49 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