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: dstalls
  • Content: Threads
  • Order by date
  1. dstalls

    Convert Number Field to Time Field (Minutes)

    I saw various entries on converting number to time (but nothing specific to minutes)... I am using Crystal 2008. I have a number value {Location_Appointment_Type.Lead_Time_Length} that I want to subtract from a datetime value {Appointment.Start_Date}. Specifically, it is to create a begin...
  2. dstalls

    Array/Loop Question

    I am using Crystal XI. I have a report pulling contact dates into the main report from a subreport. In the main report, I wish to evaluate the contact date(s) to see if they are within a service authorization range. If they are in the range then will be assigned hours to determine a workload...
  3. dstalls

    Repeated Group Header

    I want to repeat one of my headers am using the formula: If InRepeatedGroupHeader Then 'Continued...' Else '' but it's not working. What else do I need to do? DS
  4. dstalls

    Group Headings & No Data Showing

    I am trouble shooting an old report I inherited. The report has 4 Groups: 1. Unit 2. Worker 3. Case 4. Client A sub-report is providing details. The worker & unit groups keep showing up with headings but no data (having no data is fine, but if it is empty I don't want the headings). I don't...
  5. dstalls

    Month & Year Parameter

    I created a date parameter (named Service Start Date) that corresponds with the date in an existing field({TCL_SRVC.BGN_DT}) . In the formula editor of the select expert I have: Month({?Service Start Date})= Month({TCL_SRVC.BGN_DT}) and Year({?Service Start Date})= Year({TCL_SRVC.BGN_DT})...
  6. dstalls

    Using Select Expert to Filter Out One of 2 Similar Classifications

    This may already be on the site, but I can find it. I am using the Select Expert to filter (something like below): {Table_nme.field_nme} in ["Pea Pods"] Somehow I am also getting values in "Pea" (which I don't want). I tried: ({Table_nme.field_nme} in ["Pea Pods"] and...
  7. dstalls

    Determining the Lowest Value between Fields from 2 Separate Tables

    I would like to select the lowest value from related fields in two different tables. I can get the lowest value from each field by using Minimum, but how can I get Crystal to evaluate both fields and determine which is lowest? Any input? Thanks- Derik

Part and Inventory Search

Back
Top