Recent content by elansienna

Here is my formula to caculate: WhileprintingRecords; datetimevar escdate ; if {HDIncidentDetails.ActionId} = "ESCALATED LV2" then escdate := {HDIncidentDetails.Date}; NumberVar TotalSec := datediff("s", escdate,{HDIncidentDetails.Date}); NumberVar lDays := Truncate (TotalSec /...

Hello, I need help creating a formula that will subtract two dates based on a status. However the dates resides in one database column. For example, when a status goes from "escalation level 1" to "escalation level 2" I need to subtract the time when the statuses change. I keep getting...

You are simply awesome! Thanks, it works like a charm. elansienna

Hello all, I need help with a suppression formula that will count the number of groups in a report. I want to suppress the group section if the group total count is less than two as I will have the same information in the summary or report header level and the group section which is redundant...

Madawc, Thanks for the quick response. I never thought about using runninging totals -- I'll give it shot. Thanks.

Hello All, I am using CR10 against an Oracle 9i database. I'm pulling from one table with a where clause that needs to be slightly different to bring back three result sets that I will called -- closed, response and resolution records. I need to chart these records grouped by month. This...

I will go back and redo. As always thanks for your help!

First and foremost, thank you for the immediate response! You are a Godsend! I did exactly as you mentioned, but something seems to be wrong with the percentage calculation as I get the following in a sample. 6/2007 7/2007 8/2007 total incidents 88...

I am using CR version 10 with Oracle on the backend. I am attempting to create a crosstab in the report footer area to show totals and percentages by month from formulas created: Total_incidents (count of all incidents); Response_Incidents (count of incidents meeting response SLA) and...

This works great! You are absolutely the best!!! Thanks for the quick response.

I have a report that was built using the following record selection on a parameter field: (if {?Service Recipient Group} = "ALL" then true else {PROBSUMMARYM1.RECIPIENT_GROUP} = {?Service Recipient Group} or {PROBSUMMARYM1.RECIPIENT_GROUP} like {?Service Recipient Group} ) While "ALL"...

Thanks Madawc, I was leaning towards the running totals which I think is going to be my best bet.

Hello, I need to design a report to capture, count and group by month the following: backlog = incidents opened prior to the target month and still open. new incidents = incidents opened during the target month. closed incidents = incidents open before or during the target month and closed...

LB, this works fine, thanks for the tip.

Great, I will try it. Thanks LB.