CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Hybrid View

  1. #1
    Join Date
    Jun 2012
    Posts
    2

    Don't show records in main if subreport for the record shows no data

    So here is a problem I have that I can't figure out.
    I have a main report, one record pr line, place in a group footer.At the end of that same record line is a subreport. Is there any way to not show records in Main if the Sub does not contain Record? If Main returns 20 records, but 10 of them don't return anything in the Sub, I don't want those records included. I can't for the life of me see any way to do this. Any hints and ideas?

  2. #2
    Join Date
    Jul 2005
    Posts
    1,083

    Re: Don't show records in main if subreport for the record shows no data

    You should give more details about the tables from where the data is coming
    Describe the tables for the main report and the tables for the subreport
    Is there a relationship among them?
    JG


    ... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...

Posting Permissions

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





Click Here to Expand Forum to Full Width

Featured