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!

Search results for query: *

  • Users: JoyCR9
  • Order by date
  1. JoyCR9

    Distinct Count formula help

    My other problem is not every system_id has a service_call_id and I need to report on all system_ids.
  2. JoyCR9

    Distinct Count formula help

    lbass, I've been working with this, but need all service_call_id to print. Your method, and mine, only lists one service call id. My group is system_id. Suggestions on how to get all service_call_ids to print? Joy
  3. JoyCR9

    Distinct Count formula help

    I want a formula in CR9 that is a distinct count of {service_call.service_call_id} for each {part.service_part} The tables have a nice clean join. The only group of the report is {part.service_part}. I suck at writing formulas and need some help. Thanks, Joy
  4. JoyCR9

    CR9-Cross Tab Running Total/Average

    My Crystal Report (v9) is a distinct count of service call ids per month. Group Name 1 is Service_Call.Create_Dt Group Name 2 is @Vendor @Vendor is: if {PART.PART_VENDOR_ID}=109 then "NETWORK" else "UNIX" Group Name 3 is Service_Call.Service_Call_ID In the Cross Tab I use a formula to break...
  5. JoyCR9

    "ToText" for Quarterly date range

    Thanks for pointing me in the right direction. I went with: If Month(Today) >=1 and Month(Today)<=3 then totext(cdate(Year(Today)-1,10,1))+ 'to' + totext(cdate(Year(Today)-1,12,31)) Else If Month(Today) >=4 and Month(Today)<=6 then totext(cdate(Year(Today),1,1))+ 'to' +...
  6. JoyCR9

    &quot;#of records greater than or equal to X &quot; formula

    DUH!!!! Way too easy. Had been making this harder than necessary. Thanks for your help, Dave.
  7. JoyCR9

    &quot;#of records greater than or equal to X &quot; formula

    Crystal Reports 9 Group Name One is: {Company.Company_ID} Group Name Two is: {Service_call.Service_call_id} Group One Footer has a Distinct Count of {Service_call.Service_call_id} I want my report to print the service call history for the given date range based on 3 or more service call ids...
  8. JoyCR9

    &quot;ToText&quot; for Quarterly date range

    In CRYSTAL REPORTS 9, I am using the following formula (@lastquarter) to select records based on true: f Month(Today) >=1 and Month(Today)<=3 then (Year({SERVICE_CALL.CREATE_DT}) = Year(Today)-1 AND Month({SERVICE_CALL.CREATE_DT}) in [10,11,12]) Else If Month(Today) >=4 and Month(Today)<=6...
  9. JoyCR9

    LastFullQuarter Function for CR9

    Thanks for the reply. I created a formula called @Quarter: if Month(currentdate) in [1,2,3] then Month({SERVICE_CALL.CREATE_DT}) in [10,11,12] and Year({SERVICE_CALL.CREATE_DT}) = Year(currentdate)-1 else if Month (currentdate) in [4, 5, 6] then Month({SERVICE_CALL.CREATE_DT}) in [1,2,3]...
  10. JoyCR9

    LastFullQuarter Function for CR9

    In Crystal Reports 9, there are predefined functions such as "LastFullMonth" and "LastFullWeek". However, there is not a "LastFullQuarter". I am looking for a formula that would be hands off (ie: no manual date range entry) that I can use when I schedule the report with Visual Cut. I don't...
  11. JoyCR9

    Parameter in report header

    Thanks for your FAQ. I ended up doing the following as it is a numerical parameter: whileprintingrecords; stringvar Output:=""; numbervar Counter; numbervar uboundminusone; uboundminusone:=ubound({?Part numbers}) -1; For Counter := 1 to uboundminusone do(Output:= Output& totext({?Part...
  12. JoyCR9

    Parameter in report header

    In Crystal Reports 9, on oracle/sql/unix, I have a parameter that lists part ids: (Part.Part_id). When I run the report I enter a list of part numbers I want to query. Works great. However I want to have that list of part numbers display in my report title. I have done this with date ranges...
  13. JoyCR9

    resetting group totals

    Cancel this post. Resolved on own (hanging my head in shame). maximum ({@vendoronsite},{SERVICE_CALL.SERVICE_CALL_ID})
  14. JoyCR9

    resetting group totals

    I have a formula in the detail section of CR9: if {SERVICE_CALL_EVENT.SVC_CALL_EVENT_TYPE}="VENDONSITE" then {SERVICE_CALL_EVENT.ACTION_DT} I cannot place this in my group footer section. However, for reasons I don't want to get into now, I need to have this in group footer. The only way I...
  15. JoyCR9

    ToText(minimum(AllDatestoToday)) + ' to ' + ToText(maximum(AllDatesto

    Thanks. I will put in a minimum. I was hoping to have an open start date so that I wouldn't miss any historical data. LastFullMonth works great for month to month data with my formula. I was hoping that AllDatesToToday would do the same. Oh well. :)
  16. JoyCR9

    ToText(minimum(AllDatestoToday)) + ' to ' + ToText(maximum(AllDatesto

    Let's assume my database's first date is Jan 01, 2000. However in the report I'm running the record selection criteria hits a match on April 01, 2004. By first date used I mean April 01, 2004 not Jan 01, 2000. Sorry for the confusion. Thanks for posting.
  17. JoyCR9

    ToText(minimum(AllDatestoToday)) + ' to ' + ToText(maximum(AllDatesto

    ToText(minimum(AllDatestoToday)) + ' to ' + ToText(maximum(AllDatestotoday)) I am using the above formula to convert dates to text. The output I get is: -47 13-01-01 to 2005-01-24 How do I get the firstdate that a record is used vs the first date in my DB? Crystal Reports 9. SQL and Oracle 8.
  18. JoyCR9

    Exporting CrossTab (CR ver9) to Excel

    I have a cross tab report where I have editted the column headers using EDIT TEXT to be more meaningful for my audience (they are formulas...removed the @ sign). When I export to Excel, the @signs reappear. Why? How to I get the editted text to export. I am also curious to know why the...
  19. JoyCR9

    CR ver9; Unable to expand info req'd on service call

    Report should look like: Call # Metric Vendor Reason 7032 Scrub Smith Defective Part Smith1 7055 Scrub Smith Warranty
  20. JoyCR9

    CR ver9; Unable to expand info req'd on service call

    I am running CR version 9 on SQL (not sure of the version) and on Oracle. My main table in linking is: SERVICE_CALL Linked off the SERVICE_CALL table is the SERVICE_CALL_XREF table. These two tables are an equal inner join using the SERVICE_CALL_ID field found in both tables. Within my...

Part and Inventory Search

Back
Top