Hi everyone.
I am a new (but constant) user of Crystal Reports, and every so often, I am asked to create a custom report (most are already set up). The reports we create are used to track permit information. The information we collect on permits range from when a permit was applied for, to when it was issued.
I need to create a report where we list all permits, we subtract the date the permit was applied for from the time the permit was issued. This is to give us an idea of how many days elapsed between the two activities.
I have a reports which looks a little like this:
Date received.............02/01/06
Date issued...............02/24/06
Now, I want to add another row which says something like:
Days to issue.............23
I looked at the formula section, and since I am somewhat of a newbie, I cannot get anything to work. I play around with formulas, and I either get an error when trying to save the formula, or I get garbage. I tried the help manual, but to be honest, it's pure garbage.
Is there a simple way to do this? Thanks.
I am a new (but constant) user of Crystal Reports, and every so often, I am asked to create a custom report (most are already set up). The reports we create are used to track permit information. The information we collect on permits range from when a permit was applied for, to when it was issued.
I need to create a report where we list all permits, we subtract the date the permit was applied for from the time the permit was issued. This is to give us an idea of how many days elapsed between the two activities.
I have a reports which looks a little like this:
Date received.............02/01/06
Date issued...............02/24/06
Now, I want to add another row which says something like:
Days to issue.............23
I looked at the formula section, and since I am somewhat of a newbie, I cannot get anything to work. I play around with formulas, and I either get an error when trying to save the formula, or I get garbage. I tried the help manual, but to be honest, it's pure garbage.
Is there a simple way to do this? Thanks.