Results 1 to 9 of 9
  1. #1
    rohinikrishna1987 is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jul 2020
    Posts
    36

    Multiple reports as one report

    While I am trying to combine three reports using subform/subreports button, the sub reports didnt show any data. Only a blank report under the main report. How can i solve this issue

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I suggest you review the Similar Threads at the bottom of the page for ideas.

    Perhaps you could post some of your related code for review.
    Good luck.

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    I use subreports all the time.
    Its a blank report, with 3 subrpt boxes.
    Each subRpt is a normal report.

    Is this what you have?

  4. #4
    rohinikrishna1987 is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jul 2020
    Posts
    36
    Yes, its solved..But,....All the sub reports are from parameter queries...Hence when we tried to open the report, Parameter value has to be entered in each time for each sub reports...So open a combined report I have to enter same parameter for five or six times..This is obviously boaring...kindly suggest another methord

  5. #5
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Perhaps you could post a copy of our database with some sample data. And show us your report setup along with a description of your desired outputs. Hard to visualize what your queries and reports really are.

  6. #6
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,860
    Quote Originally Posted by rohinikrishna1987 View Post
    Yes, its solved..But,....All the sub reports are from parameter queries...Hence when we tried to open the report, Parameter value has to be entered in each time for each sub reports...So open a combined report I have to enter same parameter for five or six times..This is obviously boaring...kindly suggest another methord
    Use TempVars() ?

  7. #7
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Are the subreports linked correctly?
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  8. #8
    rohinikrishna1987 is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jul 2020
    Posts
    36
    yes sir its worked no problem thank u

  9. #9
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Yes, its solved..But,.
    Did you resolve the issue of having to input multiple parameters? Or not?
    If solved, what was the solution? It may help someone else.

    If the issue persists, you may need a form to capture/select parameter values, then a button (or after update of all parameters on the form), open the report passing the parameter values as openArgs.

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

Similar Threads

  1. Replies: 3
    Last Post: 09-12-2017, 10:14 AM
  2. Multiple Reports in 1 report
    By 10Pints in forum Access
    Replies: 15
    Last Post: 08-13-2015, 01:31 PM
  3. Exporting Multiple PDF reports from one report
    By dssrun in forum Programming
    Replies: 0
    Last Post: 06-29-2011, 12:16 PM
  4. One main report from multiple reports ?
    By skocev in forum Reports
    Replies: 4
    Last Post: 03-31-2011, 02:30 PM
  5. Multiple Reports within Report
    By jakelufkin in forum Reports
    Replies: 0
    Last Post: 08-31-2009, 08:42 AM

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