i have a dataset filled with mdb, wich contains ID, Name, Date und salary.
so here is my problem: 1. how can I sum all those salaries together?
2. how can i sum salaries according to Date? for example sum salaries only for June.
the answer will not be saved in database.
can somebody help me please.
thnx in advance
1. You can add a Sum on the salary at the report level to sum all the salaries.
2. You can create a group on Date, and add a sum at the group level.
Check out this page for more information on using aggregate functions: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_expressions_v1_1l6b.asp
No comments:
Post a Comment