Hi I am currently trying to create a report that contains times used on each customer each specific day, currently I am stuck at ordering them by weekday so I get
----------
Monday
Tuesday
Wednesday
Thursday
Friday
'''''''''''''''''''
Basically I have a list of time entries that contains something like
String customername
int customerid
custom class Update
---
custom classs(Relevant members):
DateTime LastUpdate
so there might be more times for one customer each day like this
snippet from list
.....
name=x, timespent=1 update=10.10.10 10:10:10
name x, itmespent=2 update = 10.10.10 11:11:11
.....
apart from this I want a total number at the end of each day (hours spent that day) and a total at the end of the report, total time used on each customer and total time used that week, here's the desired result
___________________
[header]
monday
customer1 2
customer2 2
x:::::::::::::::::3
total time spent day 7
[the monday block for the rest of the days in a week]
Total
Customer1 20
customer 2 10
x:::::::::::::::::10
total time spent 40
'''''''''''''''''''''''''''''''''''''''''''''''''''''
at the current point I created a group that is sorted by each day, from here I am blank
----------
Monday
Tuesday
Wednesday
Thursday
Friday
'''''''''''''''''''
Basically I have a list of time entries that contains something like
String customername
int customerid
custom class Update
---
custom classs(Relevant members):
DateTime LastUpdate
so there might be more times for one customer each day like this
snippet from list
.....
name=x, timespent=1 update=10.10.10 10:10:10
name x, itmespent=2 update = 10.10.10 11:11:11
.....
apart from this I want a total number at the end of each day (hours spent that day) and a total at the end of the report, total time used on each customer and total time used that week, here's the desired result
___________________
[header]
monday
customer1 2
customer2 2
x:::::::::::::::::3
total time spent day 7
[the monday block for the rest of the days in a week]
Total
Customer1 20
customer 2 10
x:::::::::::::::::10
total time spent 40
'''''''''''''''''''''''''''''''''''''''''''''''''''''
at the current point I created a group that is sorted by each day, from here I am blank
1 Answer, 1 is accepted
0
Anders
Top achievements
Rank 1
Rank 1
answered on 13 Sep 2012, 12:35 PM
I figured out how to do the first part, stopped using tables and put in a group around the detailsection of the report I now have
GroupHeader | [= Fields.update.LastUpdate.DayOfWeek]
DetailSection | [= Fields.CustomerName] [= Fields.update.TimeSpent]
GroupFooter | [= 'total time registered' + Fields.CustomerName] [=sum(Fields.update.TimeSpent)]
my report is databound to a list but the part that gives a total time used for each customer and a total time used for everything, is the part I haven't figured out yet, so now I made my report do like this
.........................
monday
customer1 2
customer2 2
x:::::::::::::::::3
total time spent day 7
[the monday block for the rest of the days in a week]
''''''''''''''''''''''''''''''''''
still need it to display the last part (stated in the first post)
I tried adding another group but it just surrounds the detail section and I don't think this will help, any kind of help is appreciated
GroupHeader | [= Fields.update.LastUpdate.DayOfWeek]
DetailSection | [= Fields.CustomerName] [= Fields.update.TimeSpent]
GroupFooter | [= 'total time registered' + Fields.CustomerName] [=sum(Fields.update.TimeSpent)]
my report is databound to a list but the part that gives a total time used for each customer and a total time used for everything, is the part I haven't figured out yet, so now I made my report do like this
.........................
monday
customer1 2
customer2 2
x:::::::::::::::::3
total time spent day 7
[the monday block for the rest of the days in a week]
''''''''''''''''''''''''''''''''''
still need it to display the last part (stated in the first post)
I tried adding another group but it just surrounds the detail section and I don't think this will help, any kind of help is appreciated