Search results for query: *

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.

Hi lbass, thanks for the immediate response. I tried using a cross tab, but it seems to stack my columns vertically not horizontally. Could it be that I'm using fomulas to do the tally and not direct database fields? Perhaps it is my inexperience with crosstabs. "Total with SLO" is a count...

Hello, I have created a report that has several columns and two groups: 1)Assignment Group and 2)Open Time of incidents by Month/Year. For ex. Total Total Within SLO Percent Met SLO assignment 06/07 138 114 82.61% 07/07 08/07 Group...

Thanks for your response and valuable info.

Hello everyone, I have developed some reports (CR10) and published to CE 10. I allowed the reports to keep its initial parameter values. However when a user enters new parameter values and run the report(using CE user launchpad), the report reverts back to the initial values that were...

Sure lbass, as I have certainly received great tips from you and this forum! As you suggested in the referenced thread, I created three separate formulas to capture, "new", "closed" and "open" tickets and placed each in the detail section to get an increment count and suppressed each so that...