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

    Suppressing a Group Header Based on Report Data

    Hi I have a Group Header field Called "User Name" I need to suppress this Group Header field if a field in the report "Group Name" equals "Project Green" If the "Group Name" doesnt equal Project Green then I need the Group Header to still display. Is this possible? Thanks
  2. keenoafc

    Formula to take into Account Working Hours and Weekends

    Hi I need to calculate the date/time difference between two date fields in my database. I can do this using the DateDiff function. However I need to also factor into this datediff formula. Working hours and weekends. So if the working hours are 08:00am to 17:00pm Monday to Friday (CET...
  3. keenoafc

    Field Population based on Date Created

    Hi I have a need to populate a field in a Crystal Report (using SAP Crystal Reports 13) The Population of the field will depend on the following Criteria If the Day of running the report is a Monday and the {Create_Date} is in the last 72 hours then tag the field as NEW If the Day of running...
  4. keenoafc

    Date Conversion to Hours

    Im using Crystal reports SAP v14. I have a simple formula Resolved - Opened Date. This gives me back a number in days (eg 0.32, 0.19, 0.62 etc) Question is how can i convert this returned number to hours. If i multiply by 24 I end up with still a number such as 14.78 I would like to get the...
  5. keenoafc

    Date and Time Calculation

    I have a need to create a formula which can do the following in Crystal: Calculate Current Date/Time minus Submit Date Time - This bit Im good with. However i only want it to calculate for Mondays, Tuesdays, Wednesdays, Thursdays or Fridays and only between the hours of 08:00am and 21:30pm...

Part and Inventory Search

Back
Top