Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by 69AceCool

  1. 69AceCool

    Help with Array

    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]...
  2. 69AceCool

    Help with Array

    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...
  3. 69AceCool

    Help with Array

    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...
  4. 69AceCool

    Help with 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...
  5. 69AceCool

    Date Range

    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!
  6. 69AceCool

    Date Range

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

    Extracting Top-N Values and passing them to subreport

    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...
  8. 69AceCool

    Extracting Top-N Values and passing them to subreport

    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...
  9. 69AceCool

    Extracting Top-N Values and passing them to subreport

    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...
  10. 69AceCool

    Logged and Closed graphing by date

    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?
  11. 69AceCool

    Logged and Closed graphing by date

    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...
  12. 69AceCool

    Categorising Logged and Closed Data

    Thanks lbass !
  13. 69AceCool

    Categorising Logged and Closed Data

    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...
  14. 69AceCool

    Record Selection possible?

    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....?
  15. 69AceCool

    Record Selection possible?

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

Part and Inventory Search

Back
Top