Recent content by risman

LB............You ROCK!! I've never used minimum / maximum in formulas and queries before. Thank you very much! Ris...

I'm trying to display a patient's exam if in the past month, it is the first one ever. I have witten a report that gathers our whole Db. It is grouped by Patient ID, sorted by Date of Service, (descending), and I have a running total of the exams that restarts with each Patient ID group. Then...

Hello, I have been having trouble with CR 8.5 OLE Db to an SQL cluster, so I just reinstalled Crystal. It worked fine yesterday. Today, I started a new report using the Standard Report Expert. After making a connection in the usual manner: The Data Explorer / More Data Sources / OLE Db / OLE...

The reinstallation worked. Thank you! Risman

Hello, A problem with no data being returned has started occuring with Crystal 8.5 OLE Db connecting to an SQL cluster. I develop new reports on my PC, (Win XP). I also edit existing reports which I copy off of our report server to my PC. The reports run fine in our application for endusers...

Hello, I am using an SQL Db with CR 8.5. I have what is probably a very elementary question, but I just can't figure it out: I am trying to design a report that shows scheduled exam times and open times that can filled for various departments for the current date and the following day. I...

Hello, Ok, I don't know if anyone will see this, but here is the solution: The table I was hitting had strings for the data type. It's returns were formatted like this: Jan 1, 2006 But the application would not take a date or a string parameter in that form. (From what I could tell). So my...

Hi Ken, Ok, I don't know if you'll see this, but here is the solution: The table I was hitting had strings for the data type. It's returns were formatted like this: Jan 1, 2006 But the application would not take a date or a string parameter in that form. (From what I could tell). So my...

Thanks Synapsevampire, My issue isn't solved, but I think I'm heading right. A couple of thoughts..... 1) If I want the end user to be able to pick the FromDate & ToDate, (as DateTimes and not DateTime Strings), wouldn't I want to convert the DateTime Parameters to DateTime String Parameters...

I am using CR 8.5, SQL Server, OLE Db driver. I have a Db field ({Corrected_Date}) that is a String. The format disregards leading zeros except for minutes and seconds.: 1/1/2006 2:09:07AM 10/2/2005 2:43:00PM etc.... I am searching for records corrected between two Dates, or DateTimes, (2...

Hello, Upon fixing the report as stated above, and closing the selection expert, I got the message: "A String is Required Here". I clicked "ok", and was then able to run the report without being forced back into the select expert or anything. The report ran great. I rechecked the Select...

And use it in the selection querie like this: DTStoDate({table.yourstringdate}) >= {?FromDate} and DTStoDate({table.yourstringdate}) <= {?ToDate} and {MEDICAL_REPORT_OBJECT.WKT_ID} =10 ???????? Then would the parameters {?FromDate} and {?ToDate} be set as Date fields?

Hello, I have access to the server, but I have never created a new view before. I browsed this field using one of the dropdowns in the selection expert. It came back with this format: "YYYY/MM/DD hh:mm:ss.xx" Example 1: Parameters {?FromDate} and {?ToDate} are set as DateTime...

Hello, I am using CR 8.5, SQL Server, OLE Db driver. I have a DateTime/String problem that I'm probably over thinking, but......I have a Db field ({Corrected_Date}) that is a String. The format disregards leading zeros except for minutes and seconds.: 1/1/2006 2:09:07AM 10/2/2005 2:43:00PM...

Hello, I am using CR 8.5, SQL Server, OLE Db driver. I have a DateTime/String problem that I'm probably over thinking, but......I have a Db field ({Corrected_Date}) that is a String. The format disregards leading zeros except for minutes and seconds.: 1/1/2006 2:09:07AM 10/2/2005 2:43:00PM...