Page 1 of 1

Question about report design

Posted: Thu Oct 30, 2008 10:49 am
by tobi
Hi,

I have some trouble on designing my report, perhaps someone can tell me how to solve them !

My report lists the results of a sports club. On every competion day there are multiple games played.
For each game result the players get points. Everything works fine in my report so far !

What I´m not able to do it to display the sum of points for each player per gaming day ( sum the points of all games played on this day ) as well as the sum over all days and games per player in total under the Reportheader...


My report structure looks like this:

REPORTHEADER
GROUPHEADER1 ( Condition: Days )
GROUPHEADER2 ( Condition: Game )
DATABAND1 ( DataSource: Results )


Thank you very much

Question about report design

Posted: Thu Oct 30, 2008 6:20 pm
by Edward
Hi.

Please define the following variables in the Dictionary:

GameDateVariable, PlayerIDVariable

In the BeforePrintEvent of the DataBand1 please assign these variables:

GameDateVariable = Results.GameDate
PlayerIDVariable = Results.PlayerID

You have to use Totals for calculation of necessary Points per player/per date:

Code: Select all

{Totals.Sum(Results,(Results.PlayerID==PlayerIDVariable)&&(Results.GameDate == GameDateVariable)?Results.PlayerPoints:0)}
And total points of the player in all games:

Code: Select all

{Totals.Sum(Results,Results.PlayerID==PlayerIDVariable?Results.PlayerPoints:0)}
Thank you.