Results 1 to 10 of 10
  1. #1
    Star Lounger
    Join Date
    Feb 2008
    Location
    philadelphia, Pennsylvania
    Posts
    72
    Thanks
    11
    Thanked 0 Times in 0 Posts

    subreport not working (2003)

    I have a report that has four sub reports, all linked to a date.... it worked fine until Friday, when I requested the report, and two of the sub reports did not appear... I then requested the day before, and the report and all sub reports appeared... I checked the data, and there is definitely data related to the sub reports on the first requested date.... I randomly did several other dates, and they all worked - I tried Friday a few more times, and the subreports would not appear...
    I cant figure it out - I did not see this particular problem when I searched the site - thoughts would be appreciated!

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: subreport not working (2003)

    Are there calculated fields on the subreports (or in their record sources) that may not work with the data from last Friday?
    Is there anything unusual about that data from that day - null values where you don't normally get them, unusual values?

    What do you see if you open the queries?
    What do you see if you the open the subreports directly - as reports rather than subreports?
    Regards
    John



  3. #3
    Star Lounger
    Join Date
    Feb 2008
    Location
    philadelphia, Pennsylvania
    Posts
    72
    Thanks
    11
    Thanked 0 Times in 0 Posts

    Re: subreport not working (2003)

    Thanks for the info, but there is nothing unusual with 4/11/08 data
    there are calculated fields on the sub reports, but I dont see why they would not work on that particular date...
    the queries run fine
    the sub report works correct as a report
    ??

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: subreport not working (2003)

    Could you post a stripped down copy of your database? See <post#=401925>post 401925</post#> for instructions.

  5. #5
    Star Lounger
    Join Date
    Feb 2008
    Location
    philadelphia, Pennsylvania
    Posts
    72
    Thanks
    11
    Thanked 0 Times in 0 Posts

    Re: subreport not working (2003)

    I would love to, but I cant make it anonymous enough to post and have it still work.... <img src=/S/sad.gif border=0 alt=sad width=15 height=15>

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: subreport not working (2003)

    If you open one of the subreports by itself, does it display records for April 11?

    Do you have code behind the main report to hide the subreports under some circumstances? If so, what happens if you temporarily comment out this code?

  7. #7
    Star Lounger
    Join Date
    Feb 2008
    Location
    philadelphia, Pennsylvania
    Posts
    72
    Thanks
    11
    Thanked 0 Times in 0 Posts

    Re: subreport not working (2003)

    Yes, if I open the subreport by itself, the flights from 4/11/08 appear... I just reqeusted another date and one of the affected subreports does not appear - when I look at the raw data for that date, I see there is no "subreport criteria" to pull.... is it normal for a sub report not to appear at all if there is no related data?

    I am not aware that there is any code behind the main report...

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: subreport not working (2003)

    Yes, if there are no data for a subreport, it will not be displayed.

  9. #9
    Star Lounger
    Join Date
    Feb 2008
    Location
    philadelphia, Pennsylvania
    Posts
    72
    Thanks
    11
    Thanked 0 Times in 0 Posts

    Re: subreport not working (2003)

    Ok, so that explains why the other date is missing a subreport, but not why 4/11/08 is... when I open the 4/11/08 subreport by itself, all the data is displayed, but when I request the main report, that subreport is not there... could you give me a hint as to what to look for about the code on the main report?
    Thanks

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: subreport not working (2003)

    Open the main report in design view. Don't click on the report.
    Activate the Other tab of the Properties window.
    If the Has Module property is set to Yes, there will (probably) be VBA code associated with the report. You can see the code by selecting View | Code.
    If Has Module is No, the report doesn't have code.

Posting Permissions

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