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

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

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

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

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

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

Hello, I'm usig CRXI with SQL2000. I've got a clients table that unfortunately doesn't have a CreateDate field. That makes it difficult to report on new clients (within the last 30 days). My workaround idea is to look at the orders table and find only the clients who'se OLDEST order is...

I'm using CRXI and MS SQL 2000 Is there a formula that allows you to lookup a value in a table based on a Parameter? I'd like to look in the tbGroups table and lookup the GroupDescription based on the GroupID (where GroupID = the Parameter)

I’m using CR XI with MS SQL 2000 I’m trying to build a report showing all possible Policies that a group can have along with a True/False value showing whether a group has that privilege. (I'll either group by group or use a parameter to select a single group once I get this working) I’ve...

I'm using CR XI with MS SQL 2000 I've got a table in a database that lists possible rights that a group of users can have. The rights have a hierarchy--up to 6 layers deep. Top Level Policy Sub-Policy Layer1 Sub-Policy Layer1 Layer2 Layer3 Layer2 Layer3...

CR XI and MS SQL 2000 I’m trying to create a report that shows the Transmit Status for each REPORT for each EXAM. Some EXAMs can have more than one report, and there may or may not be a ‘status’ for each of them. There is a tbExams table that contains an ExamID. There is a tbExamReport table...

Using CRXI and MS SQL Svr 2000 I'm trying to compare data in two different databases. There is a common value, however, one vendor stores it as a number and the other a string. Other than a SUB-REPORT (very slow), is there any way to add this table and LINK with a formula (ToStr(X))?? TIA

Normally, I can do this with GROUPS, but I'm having trouble here. I have 2 groups ENCOUNTERID SEQUENCEID (may be multiple per ENCOUNTER) EACH SEQUENCEID has an associated ROOMID. When there are multiple SEQUENCEIDs, they MAY or MAY NOT have the same ROOM ID. I'd like to print some...

I'm trying to create a report that shows a daily schedule in 15 minute increments. If there are any appts scheduled at that 15-minute increment, I'd like to display them. If not, I'd just like to display the Time. I've been working with the Missing Data hints from Crystal Clear, but I don't...

I've migrated data from several systems into a new MS SQL server. One of the fields contains the text pulled from .TXT and .DOC files. There are various series' of text that I'd like to remove from the field (or replace with ""). I'm pretty comfortable with Enterprise Manager, but pretty much...

I have an APPOINTMENT Date/Time field in SQL. I also have a LeadTime (number of minutes) that need to be subracted to show an ARRIVAL time (no need for the date). I first tried to subtract the NUMBER from the Time(APPT), but it subtracted seconds. Next, I tried using Time(0,LeadTime,0), but...

I've migrated legacy data from one system into another (MSSQL). When the data was migrated from MS Word, information was captured from the headers and footers, and now exist in the actual text. I'd like to write a Crystal formula that will 'strip' these strings out. I can use the Replace...