Greetings everyone!
I have created a report using CR 8.5, drawing information from a SQL database. This report is designed to give our business unit management the average total time it takes for the business unit to respond to an email by capturing the {submit date field} and the {response date field} and then subtracting the {response field} from the {submit field} to come up with the elapsed time the email has been idle before response to our customer. But, if there has been no response given, the field is left blank until there is one. In order to capture the truest numbers, I need to have the {response field} populated with the current date at the time the report is run, so that my formulas will work correctly.
Right now, if a business unit has let's say, 2 emails, but hasn't responded to either one of them (which means there's no [DATETIME] in the {response field}) then the sub-total field (where I subtract the {response} from the {submit}remains blank. But if I could insert the current DATETIME in this field, until there is a response, my report would be more substantial!
I have included and image of the report below, hoping it might help to visualize my posting.
Can anyone help?
Mark
I have created a report using CR 8.5, drawing information from a SQL database. This report is designed to give our business unit management the average total time it takes for the business unit to respond to an email by capturing the {submit date field} and the {response date field} and then subtracting the {response field} from the {submit field} to come up with the elapsed time the email has been idle before response to our customer. But, if there has been no response given, the field is left blank until there is one. In order to capture the truest numbers, I need to have the {response field} populated with the current date at the time the report is run, so that my formulas will work correctly.
Right now, if a business unit has let's say, 2 emails, but hasn't responded to either one of them (which means there's no [DATETIME] in the {response field}) then the sub-total field (where I subtract the {response} from the {submit}remains blank. But if I could insert the current DATETIME in this field, until there is a response, my report would be more substantial!
I have included and image of the report below, hoping it might help to visualize my posting.
Can anyone help?
Mark