Search results for query: *

Here it is: //details section evaluateafter({@First Array}); booleanvar FirstDate; stringvar array MyTypes; numbervar array D05; numbervar counter; stringvar Output; If not (FirstDate) then ( for counter := 1 to ubound(MyTypes) do ( if {STD_SR_ServiceRequest.Category}= MyTypes[counter]...

Thanks Synapse, when I add the line: Qty0-5[counter]:={table.Qty0-5} to the details formula for Qty0-5 it appears to move the values down 1 i.e date2 compared to date1 no longer works, date3 to date2 are values are being compared to the wrong HDtype. I saw your gotcha there, however each...

thanks synapse, sorry I forgot to show expected output (I've read so many of your posts as well, d'oh!) Ok I have it working except that it is only comparing 1 day correctly i.e comparing Date2 to Date1 is fine, however Date3 is comparing to Date1 instead of Date2. Howe do I change the array...

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...

Thanks lbass! I've checked the help file on dateserial and have figured out how it works, just needed a push in the right direction... : ) Cheers!

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...

Hi lbass, I need to have the TopN categories seperate as the amount of detail that is retrieved can be large and performance wise takes longer if you have to retrieve all of the TopN's in one subreport. Also depending on the type of TopN Category I would like to run a specific subreport that...

Sorry lbass, I would like to have 5 on-demand subreports sitting as links next to a crosstab in the main report so that a user can click on them and get further detail on the TopN Category. There is aggregate data in the main report but it is all 'Top Level' which suits the purpose of the main...

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, I have scoured far and wide for a solution to this problem and still haven't been able to find anything... Help anyone?

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...

Thanks lbass !

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...

Parent and Child are on the same table. I know how to link tables within Crystal, however performance drops when you link Remedy tables using Crystal. I'm sure there must be a way of running a SQL query on 1 table....?

Hi dgillz, The current report works fine, however I would like to make it more efficient by not using subreports. There is only one table that holds this information. Cheers.

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...

Dammit, so simple... LB, Works a treat as per usual! Cheers mate!

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...

Thanks lbass! Worked a treat!

Hi lbass, I get an error "An array's dimension must be an integer between 1 and 1000".