Home Subreports
New Blog Posts: Merging Reports - Part 1 and Part 2

drill-down filters out recs on main report

edited February 2003 in Subreports
Hi, I love ReportBuilder.

I have a report which uses drill-downs.
The dataset I use for the main report is not showing every row, but only
those who satisfy the drill-down querys with records.
If a row on the report has no data in the subquery, it not showing on report
at all.

Is there a work-around?

Comments

  • edited February 2003

    Try setting SkipWhenNoRecords to True for the detail datapipeline.



    --
    Nard Moseley
    Digital Metaphors
    http://www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited February 2003
    SkipWhenNoRecords did not help to prevent linked subreport queries (or
    pipelines) from filtering records out of the master recordset when they do
    not satisfy the subreport query.
    What did work was to completely disconnect the subreport's query from the
    master query as well as the subreport's pipeline from the master pipeline.
    Now, with the subreport fully detached from the master, all records show for
    the master query. The drill down functions perfectly when I put code to
    reset the parameters and requery for the subreport in the master query's
    datasource.OnDataChange event.
    Perhaps you might consider adding this angle to your repository of tips and
    tricks for subreports and drill downs.
    Thanks again for the best reporting product for Delphi.
    :)

  • edited February 2003

    Glad to hear you found a solution.

    I realize now that I made a mistake in my post. What I should have said was
    try setting SkipWhenNoRecords to False. However I do not know whether this
    will work either, you can give it a try.

    We have an example of manually performing drill down in which the detail
    dataset is manually fired. It uses a slightly different approach than what
    you describe - download it if want to compare.

    http://www.digital-metaphors.com/tips/DrillDownManualDetail.zip



    --
    Nard Moseley
    Digital Metaphors
    http://www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.