drill-down filters out recs on main report

rbuser

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?

nardmoseley

Try setting SkipWhenNoRecords to True for the detail datapipeline.



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

rbuser

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.

nardmoseley

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