Search results for query: *

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

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

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

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

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

I'm using CR 8.5 - SQL - OLEDB - I'm trying to force a memo field,({vusrDiagnosticReportText.ReportText}), that is within a provided view, to UPPER CASE. I've tried using the @Null formula as described in http://support.crystaldecisions.com/kbase/c2007285.asp, but to no avail. Our vendor does...

Hello, I've been working Crystal for quite a while now, and still frustrated by blank returns on reports. I write reports for a Radiology Dept., and our new RIS application vendor has &quot;supplied&quot; us with views to use with Crystal 8.5, SQL, OLE DB. These views can have as many as 2 to...

I am using CR 8.5, accessing SQL Server, 2000 Prof. O/S, and utilizing these reports in a Radiology application that uses hard coded &quot;print triggers&quot; to run reports. I want a Patient History report to run at the time their exam is scheduled, (if exam is today or in the future). This...