Search results for query: *

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

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

Thanks. Thats Perfect. Cheers

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

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

Thank you for your help, this has been great. THis returns the values but not as propoer Hrs and Minutes. For example on some of them it returns 139.73. What do I need to do to convert this number to 'Real' Hrs and Minutes?? Many Thanks

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