Still question on display subtotal of subreport in main report

rbuser

Sorry for the lengthy question, but I really need to solve the question.
Refer to your solution in 2005/3/11,
1) If not using RAP, your method means place a TppVariable inside the detail
band of SUBREPORT and in its OnCalc event update the value of another
TppVariable located in the main report group footer?
2) If this is true, then if the user jumping page (from page 1 jump to page
3 without preview page 2), then will the result not included value in page
2?
3) Also, Assume the tppvariable is inside a region of detail band in
subreport, then will the oncalc event fires more than once if the detail
band in subreport cannot fit in the page and then print on another page ?
(So the group total in main report is larger than the correct, expected
value)?

nicocizik

Hi Kei,

2. Yes. Be sure you have your report set to TwoPass.

3. No, the OnCalc event only fires once per traversal (or how ever you have
your Timing set).

--
Regards,

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

rbuser

I can't catch the meaning of answer 2, You means if user jumping from page 1
to page 3 (with psTwoPass), then the value in page 2 will not included in
the sum display in main page group footer? (Yes if the value not included,
No if the value is included)
I want to included the value in page 2 even user jump page from page 1 to
page 3, so if your answer is Yes (the value is not inclueded), then any
method to make it included in the sum displayed in the group footer of main
report?

nicocizik

Hi Kei,

The value should be included. I would suggest giving it a try in a simple
test application.

--
Regards,

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

rbuser

The OnCalc event fires more than once for a tranversal!!
I have placed a region with KeepTogether set to true in a main report detail
band and in the detail band there is a subreport, in the subreport there is
a TppVariable, I found that if the record in subreport cannot be printed on
a page, the TppVarialbe will fire more than once, I certain this is true!!
So is it really necessary to set some unique field in the record display in
the subreport and check it to prevent sum a record more than once?

rbuser

I found that even set unique ID is not enough, the error still occur, I
think this is because not only a record that can't fit on a page and forced
to next page and so the TppVariable oncalc event fire more once, but is a
group of record in a subreport surrounding by a region with keeptogether set
to true can't fit on a page, so maybe it is the second record in a group of
keeptogether which can't fit on a page and so the whole group need to print
again on next page and so the checking of unique ID method fail!!
So, how to handle this problem? your .rtm example has no subreport enclosed
in a region with keeptogether set to true!

nicocizik

Hi Kei,

In my quick testing, the OnCalc event fired only once. Please put together
a small example demonstrating the issue you are having and send it in .zip
format to support@digital-metaphors.com.

--
Regards,

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

rbuser

How can I sent a example to you? I don't know how to send the database, any
method?
In my scenario, there is a detail band with a region set KeepTogether to
true, then in the region there is a subreport, in the subreport detail band
there is a TppVariable, I found that this TppVariable oncalc event will fire
more than once for some record.
Is your quick test included this setting (region, keeptogether, subreport,
tppvariable in subreport detail band)? If not, then maybe it is the reason
for can't simulate the problem, or could you sent a .rtm which included
these scenario and can still show the correct calculation?

rbuser

I found the .rtm has two table "Customer" and "Orders", is these table come
from
"Program Files\Common Files\Borland Shared\Data"? If not, where is it come
from? How can you embedded these two table to the example .rtm?
If I zip a Access Database to the email address
support@digital-metaphors.com, is it ok?
Anyway, I hope you can provide a successful quick test example with scenario
like my previous posted news (region, keeptogether, subreport, TppVariable
in subreport)

nicocizik

Yes, please send the example to me in .zip format.

--
Regards,

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

rbuser

I have sent the example today, hope you can help me!