Search results for query: *

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

Don't I have to use &quot;Remainder&quot; somehow after the first part calculates the years, then again after months and then again after weeks? Thanks-

Hello, I am using age formulas in a report which work very well. How can I add on to the formulas below to specify years, monthes, weeks, and days old? Ex.: Little Bobby is 7 years, 8 months, 3 weeks, 2 days old today! Thanks! Risman If Month({table.dob}) <= Month(CurrentDate) and...

Thanks for replying you guys! After gathering all sorts of documents I could find from Crystal and related sites, (Tek-Tips too of course), I uninstalled Crystal, reinstalled Crystal, reapplied the Service Pack for 8.5, the monthly Hot fix, database drivers and dlls. Rebooted. Viola! I am not...

After searching around a bit more, I found what I think is the answer to the &quot;entry port not found&quot; problem. The Faq tab under Crystal Decisions: Crystal reports 3 Integrate Faq 768-3537. Problem is, I'm still getting Database errors and SQL Server Errors with my report. Maybe I...

Hello, I using CR 8.5 with Windows XP, IE 6 connecting OLEDB to an SQL Server. I was receiving Database Errors and SQL Server errors when trying to run a report with a Stored procedure. I downloaded the Service Pack 1, the monthly Hot Fix, and the Database Exporting Hot fix from Crystal's Web...