Skip to Content
avatar image
Former Member

Subreport

I created s report with a total of 9 subreports. I would like to filter the subreports based on a variable in the main report . The problem is that I would like to filter if it meet certain criteria (it contains "methylati") Also reports that doesn't contain information I would like to remove it.

thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 13, 2010 at 01:39 PM

    For the filtering part, add parameter(s) to the subreport, then use the Change Subreport Links (right-click on the subreport in the main report) to pass the field from the main report to the subreports. Use record selection in the subreports based on the new parameter(s).

    For not showing a blank subreport, right click on the subreport, click Format Subreport, Subreport tab, Suppress Blank Subreport checkbox.

    HTH,

    Carl

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      The information indicated previously was working, the only problem is that I have 2 queries. These queries are located in the main report and in each individual subreport. Apparently when I do the link I lost the filter created in the subreport.

      thanks

  • avatar image
    Former Member
    Apr 13, 2010 at 01:41 PM

    (dup; sorry; forum issue)

    Edited by: Carl Sopchak on Apr 13, 2010 9:50 AM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 13, 2010 at 01:41 PM

    (dup; sorry; forum issue)

    Edited by: Carl Sopchak on Apr 13, 2010 9:51 AM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 13, 2010 at 01:42 PM

    (dup; sorry; forum issue)

    Edited by: Carl Sopchak on Apr 13, 2010 9:51 AM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 13, 2010 at 01:43 PM

    (dup; sorry; forum issue)

    Edited by: Carl Sopchak on Apr 13, 2010 9:51 AM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 13, 2010 at 01:44 PM

    (dup; sorry; forum issue)

    Edited by: Carl Sopchak on Apr 13, 2010 9:51 AM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 13, 2010 at 01:44 PM

    (dup; sorry; forum issue)

    Edited by: Carl Sopchak on Apr 13, 2010 9:51 AM

    Add comment
    10|10000 characters needed characters exceeded