dbcalc problems

rbuser

Report Builder Standard Edition 6.03
Delphi Pro v6.0 (Build 6.240) Update Pack 2

I have report with the following
qryMain (selects from a view and returns 2 records)
qryCheckItems (detail query to qryMain; selects from a different view, selects 178 detail
records for master record 1 and selects 232 detail records for master record 2)
each qry has an associated TppDBPipeline
the report's DataPipeline is set to plMain
all the dbtext components on the detail band have plCheckItems as their DataPipeline
in the Summary Band I have a TppDBCalc: DataPipeline = plMain and ParentDataPipeline =
true and dbcalctype = dcCount;

Why is it counting the plCheckItems records, when from all appearances, I've told it to
count plMain records?

sorry if this is old issues to all of you...

TIA,
Matt

nicocizik

Hi Matt,

Are you traversing the detail data inside a subreport? Is the dbCalc
component inside the subreport or in the main report? Be sure that the main
report is connected to the plMain pipeline. It may be changing it when you
assign a different pipeline in the detail band. I assume the expected
output of the dbcalc is "2"?

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Nico,
Sorry I didn't make that clear.

There are no subreports or regions.
The dbcalc in the summary band is reading "410" (i'm guessing because the detail band is
traversing plCheckItems)
But I really want it to show "2", which it's not doing, *even though* TppDBCalc.DataPipeline
= plMain and TppReport.DataPipeline = plMain

Essentially, does traversing mutliple pipelines w/o subreports render null and void any
TppDBCalc functionality?

tks again,
Matt

nicocizik

Hi Matt,

Please download a trial copy of ReportBuilder 7.04 and test with that. If
the problem still occurs, please send a small example demonstrating this
behavior to support@digital-metaphors.com in .zip format and I'll take a
look at it for you.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com