Search results for query: *

Hi All, CRXI ODBC connection to Remedy ARS 5.1 Currently have a simulated crosstab the Date is in the group header and the HD's are detail section similiar to below: 22/09/06 0-5days 6-10days 11-30days HD1 47 35 10 HD2 31 41 7 HD3...

Hi All, CRXI ODBC to Remedy ARS 5.1 I am trying to determine a date range that is 2 months from now: [Date(DateAdd("m", -2, Date(Year(CurrentDate), Month(CurrentDate), 1))) to currentdate - 1 Works fine, however I need to determine the 'earliest' Monday to this date. i.e the date calculated...

CRXI ODBC Connection to Remedy ARS 5.1 Hi All, I have a report that counts the number of requests and groups by Category. I then use the Group Sort expert to Sort the records by Top-N. e.g Software Hardware User Access Mobile Audio Visual How do I capture these in to variables that I can...

Hi All, Using CRXI ODBC Connection to Remedy ARS 5.1 (Helpdesk) Query is: {Data.Logged_Date} = {?DateRange} or {Data.Closed_Date} = {?DateRange} This retrieves anything logged or closed over the selected date period. What I am now trying to do is Graph the results by date (bar graph over...

Hi All, Using CRXI ODBC Connection to Remedy ARS 5.1 Query is: {Data.Logged_Date} = {?DateRange} or {Data.Closed_Date} = {?DateRange} This retrieves anything logged or closed over the selected date period. What I am now trying to do is count them correctly. There are 3 'states' (as far as...

CRXI ODBC Connection to Remedy ARS 5.1 Hi All, I would like to ditch a subreport that I have within a main report. The current way the report works is like this. Show me each 'Parent' Incident where a 'Team' fails a resolution SLA time within a certain period. The subreport is linked by an...

CRXI ODBC connection to Remedy ARS 5.1 Table has multiple records per ID Hi All, This particular table has a Parent record (holds the final SLA measurements) and multiple child records (Which holds timing information as an incident passes from team to team). Each record has the same Incident...

CRXI ODBC connection to Remedy ARS 5.1 Hi All, I am trying to figure out a way to retrieve the last update from a a memo field. e.g: " 01/12/2005 13:25:50 Name2 Reassignment , this Incident was Previously Assigned to Name1 02/12/2005 13:35:22 Name2 Blah, blah, problem. 02/12/2005...

CRXI Connecting to Remedy 5.1 Hi All, is it possible to compare a value in one column to a value in a previous column? Crosstab example: 25/02/06 04/03/06 11/03/06 Total Email 118 123 178 419 Comparison I would like to do is 178/123-1=45% If there is an increase of more than 20%...

CRXI Remedy ODBC connection Hi All, when charting anything with a count or sum which is below 5 the automatic number division for the chart always displays it in .5 eg 4 X 3.5 3 X 2.5 2 X 1.5 1 .5 0 WEEK1 WEEK2 WEEK3 I know I can change...

CRXI Remedy ODBC connection Hi All, when charting anything with a count or sum which is below 5 the automatic number division for the chart always displays it in .5 eg 4 X 3.5 3 X 2.5 2 X 1.5 1 .5 0 WEEK1 WEEK2 WEEK3 I know I can change...