BizzyLizzy
Technical User
Hi all
Hope someone can help me. I am using Crystal 11 connecting to sql database with odbc.
The table I am reporting on has two number fields showing logon time and logoff time. For example.
Logon Time Logoff Time time logged on
143,125 144,125 1000
143,125 145,125 2000
143,125 150,125 7000
143,125 151,125 8000
The logoff time field is a running total for amount of time that the agent is actually logged on. This figure is being written to the database table not created by a formula in crystal. The time logged on field is a formula field that I have created {logoff time} - {logon time}. I have grouped the report on logon time and created a Max summary of time logged on. The max summary is shown in the group header for logon time. The report then goes to the next logon time with its associated running total in the logoff field.
What I now need to do is Sum the value shown in the Max summary but when I try to do this using Sum I run into the problem of 'This field cannot be summarized'. I tried putting the max value into a variable and then sumarizing the variable but that still didnt work.
Hopefully I have given enough information and that someone out there can help me.
Cheers
Lizzy
Hope someone can help me. I am using Crystal 11 connecting to sql database with odbc.
The table I am reporting on has two number fields showing logon time and logoff time. For example.
Logon Time Logoff Time time logged on
143,125 144,125 1000
143,125 145,125 2000
143,125 150,125 7000
143,125 151,125 8000
The logoff time field is a running total for amount of time that the agent is actually logged on. This figure is being written to the database table not created by a formula in crystal. The time logged on field is a formula field that I have created {logoff time} - {logon time}. I have grouped the report on logon time and created a Max summary of time logged on. The max summary is shown in the group header for logon time. The report then goes to the next logon time with its associated running total in the logoff field.
What I now need to do is Sum the value shown in the Max summary but when I try to do this using Sum I run into the problem of 'This field cannot be summarized'. I tried putting the max value into a variable and then sumarizing the variable but that still didnt work.
Hopefully I have given enough information and that someone out there can help me.
Cheers
Lizzy