TDBCalc

rbuser

second try....

Here's my problem...

I have a report using a DBCalc to count (using DBCalcType property) all
record per group footer (break). Everything work fine. BUT if I use a
customer with 7 millions record (don't ask why that customer want to see 7
millions records in a report) sometime the count work and others don't.
WHY???

Thanks,

Michel

digitalmetaphors

Could you provide some more information about how it doesn't work? Does the
count print zero or is it short one value? You can also use a TppVariable
and code its OnCalc event to perform the count.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

I have a count(*) in the Summary footer that should return the number of
record (total) display on the report. it retrun 40 record instead of around
7 millions.

I'm already looking into to use a TppVariable instead of DBCalc.

Thanks for you help

rbuser

An other thing is using OnCalc instead of a DBCalc will put more process on
the system. Right????

Michel.

digitalmetaphors

No, the TppDBCalc calculates on every forward record traversal of the data
pipeline. It will fire just as often for the TppDBCalc as it would for the
TppVariable (The variable timing should be set to calculate on Traversal).


Cheers,

Jim Bennett
Digital Metaphors

rbuser

To answer your question: "Does the count print zero or is it short one
value? "

It (DBCalc) retrun a wrong value each time and a different one. If I run a
"reguler" customer everything work fine (count and sum function) but for
this 7 millions customer it doesn't. Why???? Still a mistery for me. In
the past, we even test our report on a 9 millions record customer and it
work fine. The count and sum function of the DBCalc was ok.

Thanks again,

rbuser

These may seem like a seriously dumb questions but I'll ask anyway...

Is the .width property wide enough or is it set to autosize?

How about the display format? If it is set to something like ###,##0,
that will not print a value in the millions properly.

Anyway, I am sure you have already checked these things. )

- Rich

rbuser

I learn that there is not dumb question in IT....

Yes I double check all that....

:-)

digitalmetaphors

What value do you get when you use the TppVariable instead of the DBCalc?
Any difference?


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Yes...the right value (7,435,836 items count) when doing a total record
count in the summary band. I'm testing this right now with ReportBuilder
6.03. If I have the same wrong result I think I will be force to do all
count and sum total per break in code.

I let you know the result with RB 6.03

Michel.

digitalmetaphors

Can you give us a sample report layout? Please, send it to
support@digital-metaphors.com We could try to build a report with 7 million
records or so by modifying on of our JITPipeline demos which creates records
at runtime. We need to reproduce the problem here so that we can isloate
what is causing the DBCalc to be different than the variable sum.


Cheers,

Jim Bennett
Digital Metaphors