Search results for query: *

Hi Everyone, I'm using SQL 2000 server, Win 2003 server. I am trying to convert a datetime field into a regular date but I need the result to provide me a null when if the date returned is 12/31/1899. Here is what I have so far: SELECT patid,acctpriority,accounttype, TYPE=CASE WHEN...

I have been trying to import a Unicode file into an Access 2003 database via VBA code with no luck. I tried using the OpenTextStream to read the data but can't seem to get that to work. The files are fixed width but are UTF-8 format. Please any proven fix would be greatly appreciated.

Hi, SQL 2000 platform, Windows 2003 server. I'm working on a query that will provide me maximum date for a specific field(MR_FINISH_DATE). The problem is that not all of my entries have data in this field and thus are returning with a NULL result. I want to know if it is possible to force a...

Hi, I'm trying to compare 2 separate DB (SQL 2000 Server) tables to determine which Medical Record numbers are missing. I've developed a query to do that and it executes successfully, but I am not getting the end result that I am anticipating. Here is my query: SELECT DISTINCT MR_NUMBER...

Hi, I'm working on a SQL 2000 server and I'm trying to write a query that will return the latest instance of a patient's medication allergies. But my current query is only designed to pull all instances. Here is what my current SQL code looks like: SELECT DISTINCT ckt.name, prov.displayname...

Hi, Is it possible to combine 2 separate date and time fields and then convert them to a single date/time format within a SELECT statement? Let me give you an example, I have one field called Appointment Date (apptDT) and then I have another field called Appointment Time (apptTM). This is...

Hi everyone, Configuration: MS SQL 2000 using Server 2003. I am trying to design a query that will allow me to access different databases using the OPENDATASOURCE command but also using the WITH (NOLOCK) command as well. I know that using NOLOCK is using a 'dirty read', but it's okay with...

Hi everyone, (DB Info: SQL Server 2000). I'm currently working on a project for our hospital to participate in our states RHIO. What I need to do is create sql queries that will check to see if certain values (BP, Height, Weight, etc.) has been added to a patient record within the past 24...

Hi, I'm using CR XI accessing a SQL server DB. I just designed a Committed Visit Note report for our clinic. In this report, I've got the Appt Date, Note Commit Date (from a subreport), Patient Name, # of Days (Datediff between Appt Date and Note Commit Date) and a few other fields. The...

Hi, I'm working with CR XI against and SQL Server. I'm having trouble trying to get a value from a formula in the Group Header 3 down to the Group Footer 1 so that I can us it for finishing out some calculations. To look at the my report and what I'm asking, go to below link...

Hi everyone, I need some help in converting an cell that contains a salary value. The incoming values could look like this: 83.4 or 99.25 or 24 The problem is that I need to convert this format into a zero filled decimal implied value. And I need it to look like this: 0008340 or 0009925...

Hi, I'm trying to use Javascript to determine the number of instances of a carot (^) is located within a single string. Here is an example: 000100^Bombay^MD^Doctor Once I know the number (3 for the above example), then I'll use the Split command to break them down into an array and then put...

Hi everyone, I'm working with 2 different SQL DB's on 2 separate servers running SQL 2000. What I am trying to do is extract diabetic patients from 1 DB based upon a zip code listing which is in another DB on a separate server. Here is the select statement that I've put together thus far...

Hi, I'm using CR XI with and SQL ODBC connection. I'm having problem trying to get a properly formatted date string when using the ToText command. Here is my formula: // Clear Variables NumberVar Mon1 :=0; NumberVar Day1 :=0; NumberVar Yr1 :=0; StringVar Mon2 := ""; StringVar Day2 := ""...

Hi everyone, I'm working with CR XI and 3 SQL databases. I've got a report that I've put together. I am grouping (Group #1) by an EnterpriseIdentifier. In the details, I have 2 subreports which are passing shared variable information up to the main report. I then have a Formula Field that...

Hi everyone, I'm using CR XI with SQL. Since we have a central server and using the CR web reporting tool (InfoView). I was wondering if anyone knows of a way to hard code the System and the Authentication Type on the InfoView login screen? We're trying to make it easy for our users so that...

Hi everyone, I'm using CR XI on a Win XP Pro machine. I am having problems with some pages not fully showing the complete subreport information. I'm creating a single page containing all the medications a patient is currently taking. The main report contains just a list of patients, grouped...

Hi Everyone, System: CR XI on Win XP Pro accessing data in an SQL DB. Take a look at the PDF document that I put together first and then I'll explain: http://www.hcnsvt.org/Hold/CRIssue2.pdf As you can see in my final result which is the report on the bottom of the page. I am trying to...

Hi everyone, I'm using CR XI connecting to SQL tables (ODBC) on a Win XP Pro PC. I've got a main report that has 3 subreports embedded and when I run the report everything works just fine and it displays the 1st page fine. But when I want to go on and preview the 2nd or 3rd pages, CR has to...

Hi Everyone, CR XI SQL DB I'm creating a report that has 2 subreports embedded in it. Both subreports are passing weight values up to the main report (using parameter passing) and then the main report is performing some additional calculations. Well, my calculations are working great when I...