DBCalc don't work when work on second DataPipeline

rbuser

Good morning

I have two tables a primary and a secondary, I need to make a calculation
operation on the secondary table and the result must be printed on the
report .


I can't use "SELECT ... COUNT.." , i must use only DBCALC component.

I tried to use the DBCalc but I have a problem !

if I use DBCALC on the main table works fine but if I use it on the
secondary datapipeline , don't work

DBCALC value is wrong , The "DataPipelines" is ignored.


Is this a bug ?


------ù

RB 11.07 - Delphi 2010 - Win 7



__________ Information from ESET NOD32 Antivirus, version of virus signature database 4913 (20100303) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

nicocizik

Hi Michela,

The DBCalc needs to be connected to a pipeline that is traversed by a report
in order to make a full dataset calculation such as Count(*). For instance,
you would need to place it inside a subreport connected to your secondary
dataset in order to receive the correct value. See the following
article/example on how this might be done...

http://www.digital-metaphors.com/rbWiki/Delphi_Code/Calculations/How_To...Display_Subreport_Totals_in_the_Main_Report

--
Regards,

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