Sub report

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • roshnair
    New Member
    • Oct 2006
    • 6

    #1

    Sub report

    i am using ms access 2003 & VBA .i have one main report and 3 sub reports embeddedd in the main report. if i am running teh subreport alone it is dispalying teh data.but if i am running teh main reoport all teh three subreports are not displaying any data? do i need to set anything programatically to dispaly it.and one more thing when i am running this main report it is asking for an unknown parameter .if i am cancellin g that pop up also main report is showing .how to avoid that?

    Please let me kmow if anyone knows how to correct these 2 error.
  • NeoPa
    Recognized Expert Moderator MVP
    • Oct 2006
    • 32669

    #2
    Try running the query that the report is based on and see if the unknown parameter comes up.
    The unknown parameter is something you've asked it to use in the query which it doesn't recognise.

    Comment

    • MMcCarthy
      Recognized Expert MVP
      • Aug 2006
      • 14387

      #3
      Originally posted by roshnair
      i am using ms access 2003 & VBA .i have one main report and 3 sub reports embeddedd in the main report. if i am running teh subreport alone it is dispalying teh data.but if i am running teh main reoport all teh three subreports are not displaying any data? do i need to set anything programatically to dispaly it.and one more thing when i am running this main report it is asking for an unknown parameter .if i am cancellin g that pop up also main report is showing .how to avoid that?

      Please let me kmow if anyone knows how to correct these 2 error.
      What is the common link between the subreports and the main report.

      Have you set master/child links or are you using filters.

      Comment

      Working...