Search results for query: *

That description may be confusing. Crystal XI, SQL 2000 I've got a ReferringMD table that has about 2000 entries. I've built a report that allows the user to select ONE Referring MD. The problem is that they must know the EXACT spelling of the ReferringMD (first and last). If I create a...

Please don't appologize! This board, and people like you are a great resource! And for the price, I certainly can't complain!! Thank you!!

Sorry--I only need to print reports for one room / one day. So we can use parameters to limit our data.

Hi Linda, thanks for looking. I'll try to give you all the info you need, without writing a novel. There are a bunch of tables, but I've created a VIEW to make a lot of it simpler. Essentially, there is an APPOINTMENT table that has an AppointmentID for each appt ever made. For each appt...

Somebody must have tackled this before? I have CRXI and MSSQL 2000 I've got table of appointments that includes the SchedStartTime (DateTime). I'm trying to create a report that shows the entire daily calendar. My first report showed the appointments one right after another, which makes sense...

Brilliant! Thank you!

I'm using CRXI and MS SQL 2000 I've got a main report that contains ApptTime (DateTime). I've got another table that lists schedule blocks, and they are defined by a FromTime, ToTime, FromDate and ToDate I'd like to have my subreport return informtaion for any schedule blocks active at the...

Sorry for the delay--power storms been keeping me busy. What I'd like to see for the above data is: PatientID PrirorCount Status 83707 6 (don't need this) I don't need the status/rank in this view--I've added it while I was troubleshooting the 'duplicate' PatientIDs...

Thanks for all of your help! First, I'll mention that an exams goes through many different STATUS' (as they progress from scheduled appt to complete). This status relates to another table (tbcdExamStatus) which provides a RANK. It's generally easier to use RANK to include several status' (ie...

Thank you for your response. Is there any way to simply count the patient entries with ranks in a specified range (regardless of what the rank IS?) Anything like a CountIF statement? Or, is there a way to SUM all of the different ranks into another field (that I can use in my Crystal...

I'm relatively new to programming in SQL, but I've been using Crystal Reports for many years, so I'm familiar with databases and tables. I'm trying to create a view that shows a Patient ID and the COUNT of exams they've ever had. I have a tbExams table (contains the ExamID) and tbEncounters...

I've been using CRXI for several years but I've only connected to SQL databases. I've got an application that I've been told uses SAP (Esker Fax Server) and I'd like to query the database. I feel pretty stupid to say that I can't even find the option to connect to SAP. Is there some other...

Excellent idea, thanks. You say "insert" the data from one table to the other. Is there an easier way to do this besides the Import Data wizard?

I'm using MS Excel 2003 and MS SQL 2000. I needed to do a LOT of data entry, so I exported a SQL table from my database into Excel. I deleted the existing data and created the additional data I need. When I import the data (and select Append), I get an error that the primary key is duplicated...

I'm using Crystal XI (with Crystal Server) with MS SQL 2000 (two different SQL Servers). I'll try to give as much info as I can (without writing a novel). Essentially, I've built a report that lists exams (by exam ID. IF there is information about that Exam ID in another database, that...

Thanks for the ideas. I confirmed that the SERVER running this report CAN access all databases. 1) I added the sub-report ONLY (with a parameter) and that works fine. 2) I ran the report on the server in Crystal XI and that works fine with sub-reports. Any other ideas?

I'm using Crystal XI with MS SQL 2000 (two different SQL Servers). I'll try to give as much info as I can (without writing a novel). Essentially, I've built a report that lists exams (by exam ID. IF there is information about that Exam ID in another database, that information is shown via a...

Hello. I'm using CRXI and MS SQL 2000. I've built a report with 'sensitive' data in it. The users who have access to it are allowed to see it, but if they print the report it could end up anywhere. Is there an option/command to suppress a section when a report is printed? (Or, change the...

Yes, each order in tbOrders references the ClientID. Of course, there can be multiple orders for the same ClientID so ClientID is not unique in tbOrders. Thanks

A VIEW sounds like the best option--that way I could use it from any other Reports I create too! I've never created a veiw before. It's not like creating a table, right? I'm not actually impacting the database at all?? Are there any threads or docs you can recommend to learn how? If it is...