Question about report design

[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

[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.