Search results for query: *

George.. thanks for helping me... this is the actual query select vi_incident_pd_status.incident_id, tb_event.event_type, tb_event.event_date from vi_incident_pd_status Inner Join tb_event On vi_incident_pd_status.incident_id = tb_event.incident_id...

select event_type, event_date from tableb where event_type = 'HEARING' and event_date <= getdate() Thanks so so much!

I am a little new at this.. I am trying to write a statement that will allow me to select tablea.incident_no, tableb.event_type, tableb.event_date from tablea, table b where tablea.incident_no = tableb.incident_no and event_date <= getdate() and not exists (select * from tableb.event_type...

Thank you... I will try this and let you know.

Crystal Version 10 SQL database sorry forgot to add these in my prior post... thanks so much for looking at this for me.

Ok.. I have added a portion of the table.. The VBKey is the main key for the record. EventID is the record that can be duplicated and the event date next to it is the date(manual entry by user) the record was entered. Problem: I have several cases that have 2 or more entries of the EventID...

OK.. I am fairly new at using the forum and wasn't sure if everyone answered everywhere.. thanks again.

Hmmmmm... What I have is the event of Case Opened several times --- each with a seperate date. So I am not sure how I would do a date1>date2 etc.. because the dates are all in the same table and are the same field... Any more suggestions? Thanks so so much, this is driving me nuts.

I need a formula that chooses the newest date per record. I have a table that holds many events (some duplicates) along with the date of that event. I want to choose a specific event and it's corresponding date ---but I want only the most recent date/event. HELP!!!! Thanks.

I think maybe I was asking in the wrong way so I submitted a second thread on this subject.. thanks.

Is there a way to just select the newest date when there are several dates in a query?

Thank you for such a quick reply.... I do not have access to change the database itself, unfortunately, any other suggestions?

I have a table that stores events and event dates. I need to have Crystal pick the newest event date for duplicate events. Example: I have "Case Opened" on 2/1/2004 and "Case Opened" (again) on 12/31/2004 -- How do I force Crystal to find only the newest date?

I guess I wasn't clear enough in my original post. I have CE 10 and wanted to know how to get scheduled reports emialed from within CE 10 .. I have since discovered that this feature is not in the standard version that I have. I would need to upgrade to CE 10 Professional to get this...

Thanks.. this works great!

I want to have, for example, on page 2 USA continued.... to come up in text until the next group then Canada on the first page of that group and Canada continued.... on the following pages ... Any suggestions????? Thanks, Kristina

But.. this did... giving me "From: 3/1/2005 to 4/12/2005" "From: " + ToText(Minimum({?Between What Dates?})) + " to " + ToText(Maximum({?Between What Dates?})) Thanks for the tip .. got me going! Kris

Thanks.. but this didn't work.

Does someone know......What is the formula I would use to display the dates I choose in the parameter for the report header? The join functions works only on strings. Thanks, Kristina

Thanks Brian.. worked great.. I am a new working with the Repository so I will probably be asking a lot more questions. Kris