Search results for query: *

thanks LBass for both the very quick response and the correct soulution provided.

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

LBass, RsGeek. Any help on this please? Thanks

Thanks Lbass and RsGeek I'm not sure I understand your explanation. Do I create a new formula for saturday or add to my working days formula? Looking forward to your reply.

Thanks RsGeek I have already used this formula to calcualte working hours between 6am to 7pm monday to friday but the problem i have is I also need to calculate times between 6am and 10am on saturdays. Any suggestions?

Can anyone help me with this?

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 Ian Sorry for the confusion. If i create the report just in crystal it is very slow as all the data is returned and filtered locally. I want to write a simple SQL command to allow the filtering be done on the server and only return to crystal the filtered information. I want 3 fields...

hi Ian There is a separate date field called scandate, This field type is Date. DISPLAY STRING(TIME,"HH:MM:SS") is used to diplay this interger in time format with progress DEFINE VARIABLE hour AS INTEGER. DEFINE VARIABLE minute AS INTEGER. DEFINE VARIABLE sec AS INTEGER. DEFINE VARIABLE...

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 Ian. I wrote the following formula. I think it will work. if currenttime in time (19,00,00) to time (23,59,59) then {@scan_date_time} >= datetime (today, time(19,00,00)) else if currenttime in time (00,00,01) to time (03,00,00) then {@scan_date_time} >= datetime (today -1, time (19,00,00))

Thanks for the help Ian. Any other ideas? I could maybe look at all scans for the past x hours as these scans only take place between 19:00 and 03:00. If i always look at the scans for the previous 8 hours i would pick everything up. Any suggestions how i can look at the last 8 hours, again...

hi Ian what do i use as shiftstartdatetime? i dont want to hard code the date, i cant use "today". I dont want to have to keep changing the startdate/enddate daily. Maybe i'm missing your point, if so please let me know. Thanks

datetime ({scaninfo1.scn-date}, timeserial (0,0,{scaninfo1.scn-time}))

Hi Ian We have a process where barcodes are scanned. I want to setup a dashboard that will give a simple sum of all scan records since the shift start time. This report will be auto refreshed every 5 mins during the shift. This will keep the operators aware of their progress. If the shift...

hi Ian. I can use the scan date and scan time as shift start and finish but i'm not sure how this will help me. I dont want to use a paramater or hardcode the shift date. If i was running this report after the shift had finished it would be easy, but this report will be refreshing every 5 mins...

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

Thanks lbass, its late, I must be missing something, Its reading records but not finding anything. :( . Its not giving me the error message anymore just reading records and not finding anything. Any ideas what I'm doing wrong?

i've tried this and i still get the error that the --------------------------- Crystal Reports --------------------------- Hour must be between 0 and 23. --------------------------- OK --------------------------- I've tried different combinations but cannot get it to work when it runs after...