Is it possible?? Drill-down group and row count in header

Hi all...

I'd like to say hello, because it's my first post on this forum.

I have a question about drill-down group feature. Is it possible to move row count from groupfooter to groupheader display it before without group expanding ?

this is an example below:

fr.jpg

I've tried to use "Dialogs and script" demos but it doesn.t work for me [img]style_emoticons/<#EMO_DIR#>/sad.gif" style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" /> procedure Memo24OnBeforePrint(Sender: TfrxComponent); begin if Engine.FinalPass then Memo24.Text := 'Row count : ' +Format('%',[Get(<Users."ID">)]); end; procedure GroupFooter1OnBeforePrint(Sender: TfrxComponent); begin Set(<Users."ID">, Count(<Users."ID">)); end; thanks for any help.. regards Michal[/img]

Comments

  • edited 10:30AM
    no one is able to help me? [img]style_emoticons/<#EMO_DIR#>/sad.gif" style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" /> I'm trying many things and the procedure shown below is almost working[/img][img]style_emoticons/<#EMO_DIR#>/smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> but it shows RowCount from next group:[/img]var
    RowNumber: Integer;

    procedure DetailData1OnBeforePrint(Sender: TfrxComponent);
    begin
    if Engine.FinalPass then
    begin
    RowNumber := RowNumber + 1;
    end;
    Memo24.Text := IntToStr(RowNumber);
    end;

    procedure GroupHeader2OnBeforePrint(Sender: TfrxComponent);
    begin
    RowNumber := 0;
    end;


    It looks like this on the report

    fr2.jpg

    I have drill-down groups on the report grouped by the date of occur:

    fr3.jpg

    I'll be very grateful if someone can help me solve this problem.

    best regards

    Michal
  • gpigpi
    edited 10:30AM
    You should use aggregate function with flag=1
    See attach
  • edited 10:30AM
    gpi wrote: »
    You should use aggregate function with flag=1
    See attach

    Thanks very much for the reply! > ....... but I have a little one problem[img]style_emoticons/<#EMO_DIR#>/smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" />) aggregate function with flag=1 works fine only for main group ... I have two groups in my report: Main group is by USER_NAME (for example SYSDBA, MICHALS etc.), and the subgroup is by the date of events occur. At this moment the report looks like below:[/img]fr4.jpg

    Aggregate functions shows row_count from the last USER group.

    I need to group events by USER_NAME and then by DATE. Is it possible to use two grouping conditions?

    Thanks again for the help !

    best regards

    Michal.
  • edited 10:30AM
    Hi all.

    Does anyone would be so kind to tell me how can I count events as I wrote above?

    best regards.

    Michal
  • gpigpi
    edited 10:30AM
    wrote:
    Does anyone would be so kind to tell me how can I count events as I wrote above?
    Without test report template based on FRDemo database? I think, no
  • edited 10:30AM
    gpi wrote: »
    gpi wrote: »
    Does anyone would be so kind to tell me how can I count events as I wrote above?
    Without test report template based on FRDemo database? I think, no

    Ok,[img]style_emoticons/<#EMO_DIR#>/smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> There is the test report based on Drill-Down groups 97.fr3 file in attachment:) thanks for any help.[/img]
  • edited 10:30AM
    Hi,

    Does anyone of you would be so kind and tell me how can I do this grouping in FastReport ?

    best regards.

    Michal

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.