How to control report building to hide detail items on master data band and show only subtotals on group footers and totals on report summary bands?
Exist any other and more intelligent solution than calculating sums for groups into arrays and in final pass hiding databand and showing array items???
UT.
Full Version: Grouping report without details?
turn mdb visible property to false
use extended syntax of sum funtion in memos in footers and summary band
[sum([tablename."Fieldname"],bandname,1)]
bandname is bandname of mdband as shown in frs object inspector.
the ,1 param allows summing non visible values.
of course you could always look at the main reports demo to see how it is done.
regards
use extended syntax of sum funtion in memos in footers and summary band
[sum([tablename."Fieldname"],bandname,1)]
bandname is bandname of mdband as shown in frs object inspector.
the ,1 param allows summing non visible values.
of course you could always look at the main reports demo to see how it is done.
regards
I´m doing that, but when I do the operations in memo on MasterData and i set property visible to false in the band, throws an "Invalid variant type conversion"
memo have text like this
memo have text like this
| CODE |
if [DialogForm.qryAcumPendXPay."STATUS"] = '1' then if [DialogForm.qryAcumPendXPay."DUEDATE"] <= [vFrNowDate] then totalOutDated := [DialogForm.qryAcumPendXPay."TOTAL"] else totalOutDated := 0; |
I put the Group Header Band to group totals per Customer
then put a MasterData Band
then i put a Group Footer Band to subtotals of each customer
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.