Grouping report without details?

uramst

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.

gordk

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

paren

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

  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