Search results for query: *

stevefah - I'm not confused, but you might check on the poor little report designer. LB - Thanks for your help and research, it is working fine now. rfoote - I have your e-mail somewhere, I'll send you a note. Thanks again.

Very helpful, thanks.

This formula will give a datetime value that is 42 days forward. You can select based on the table's class end date being equal or make a range using the same process. CDateTime(cdate(DateAdd ("d",42 , currentdate )), CTime(00,00,00)) If you need date rather than datetime, leave the outside...

Using Crystal Reports XI. A report without groups, using the Suppress (No Drill-Down) formula of: {Patient_Clin_Tran.clinical_transaction_no} = NEXT({Patient_Clin_Tran.clinical_transaction_no}) In the Section Expert box, when the suppress checkbox is checked, the last detail row is...

Wichita Kid nailed it - - thanks The selection formula is: ( DayofWeek({Login_History.start_datetime}) in [2 to 6] and not(hour({Login_History.start_datetime}) in [8 to 17]) or DayofWeek({Login_History.start_datetime}) in [1,7] ) and ( {Login_History.start_datetime} in {@Start of Week}...

In Crystal 8.5, I'm trying to select records for off-hours system access. The tables have a login date/time field. The report needs to run from the current date, usually Monday, and include the previous week's access for after 5:00 p.m. until 8:00 a.m. Monday thru Friday and all weekend. I'm...

I'm trying to do a report that will allow the user to select the columns they want to see in the report. For example, out of 20 fields in the table, the user can select 6 to be listed. I've created parameters for each of the fields, but can seem to find a way to get them to display after the...

I need to develop a report where patients are listed that do not have a treatment plan developed. I have put together a report that lists patients based on intake date with columns for Patient ID, Episode ID, Name and Completed Documents. Episode is usually the number of times the patient has...

I've always found what I needed by searching, so this is my first post.... I'm not sure I described the problem well. If the user has not logged in, there is no information for them in the table that tracks access. I tried using an outer join so the staff table would list all records while...

I have two tables, one that has the user id and other staff info, the second has login info for the user, datetime, workstation, etc. I would like to find out who did not log in last month. Can this be done?