Sum by group (GroupFooter)

yvesarchambaultyvesarchambault Lacolle, Qu?©bec
edited October 2011 in FastReport 4.0
Hi, I don't see [img]style_emoticons/<#EMO_DIR#>/unsure.gif" style="vertical-align:middle" emoid=":unsure:" border="0" alt="unsure.gif" /> a way to sum on group. I have a query :[/img] 
select *
from gest2009.fmr1mab ab
left join cumul.fmr1ma cma on ab.perma = cma.perma
where ab.hop like '%'
and ab.period like '%'
order by ab.hop, ab.period, cma.nom, cma.prenom
In the report I have the following bands:
ReportTitle
GroupBand by hop
GroupBand by period
MasterData associated to the query
GroupFooter1
GroupFooter2
ReportSummary

Everything display ok, it is easy to tell one System Text to sum by period
but a second one to sum by hop, I don't see how.

Is there a way to associate a GroupHeader with a GroupFooter ?

Thanks

Yves

Comments

  • gpigpi
    edited 3:05AM
    In your report GroupBand by hop should be assigned with GroupFooter2, GroupBand by period - with GroupFooter1
  • yvesarchambaultyvesarchambault Lacolle, Qu?©bec
    edited 3:05AM
    gpi wrote: »
    In your report GroupBand by hop should be assigned with GroupFooter2, GroupBand by period - with GroupFooter1

    Hi, I tought that the solution was something like this but I don't see how to do that, "Assigned" ?

    I have re-read the manual and I don't see how to assigned or bind the footer with the header.
    Could you give me some precision about that ?

    Thanks for your time.

    Yves
  • Petter S.Petter S.
    edited 3:05AM
    yvesarchambault wrote: »
    Is there a way to associate a GroupHeader with a GroupFooter ?

    Hi.

    As far as I know the association between group header and group footer is always set up automaticly by FR depending on the order of the bands, starting from the masterdataband. The nearest group header connects to the nearest group footer. The scond nearest header connects to the second nearest footer, and so on..

    So in your report you have connected 'GroupBand by hop' to 'GroupFooter2', and 'GroupBand by period' to 'GroupFooter1' just by ordering the bands.

    Petter

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FastReport 4.0Comment As ...

© Vanilla Keystone Theme 2025