Search results for query: *

hi I have written a report that allows the user through a parameter select multiple dates. This works fine but I want to display on the report the dates that have been selected. I can do this for a single date and a date range but I cannot do it for multiple values. Please can anyone provide...

hi I'm trying to calculate working hours from the open time of a ticket to the close time. Working hours are Mon - Fri 6am - 7pm Saturday - 6am - 10am. I can do the mon - fri calculation but because the hours are different on saturday its giving me some problems. Formula used is. //Working...

Hi I am trying to create a SQL statement for a crystal report to pull all scantime records from a progress database for the last 2 hours. The scantime is a interger type field. This is a very large database, therefore I want to write an SQL query to pull back to crystal only the data I need.If...

Hi I'm trying to set up a formula to calculate a shift time that crosses over midnight into 2 days. This formula will be used to count the number of scans recorded during this time. Example. Shift Start Time 19:00, Shift End Time 03:00. Report will be used on a live dashboard through Crystal...

hi I'm running reports in crystal server 2008. Reports are built using crystal 2008 with an ODBC connection to a progress database. I have many reports scheduled to rung and e-mail to mailing list but often get the error below. It does not happen all the time, Any ideas? Error in File...