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

msciwiarski · August 2012

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:

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]

msciwiarski · August 2012

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

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

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

best regards

Michal

gpi · August 2012

You should use aggregate function with flag=1
See attach

msciwiarski · August 2012

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]

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.

msciwiarski · August 2012

Hi all.

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

best regards.

Michal

gpi · August 2012

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

msciwiarski · August 2012

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]

msciwiarski · September 2012

Hi,

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

best regards.

Michal

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

Comments

Leave a Comment