Search results for query: *

That would probably be a good workaround except user wants to see all results.

Using Excel 2007. Spreadsheet is created from SQL script run in TOAD as an Excel Instance. Have existing spreadsheet with drug names. Need to find the top 5 drugs used from column. Have tried MATCH, COUNTIF, VLOOKUP, MODE and others. The problem is that there are thousands of drug names and...

Adding a Patient Allergy table alias did the trick! Thanks.

Yes it does pmax9999. It's an alias table. I have used similar method in Oracle to find date differences. Don't know why I didn't think of it earlier. I'll let you both know how it works out. Thanks.

Actually there are four. Patient Allergy, Patient Visit, Masterpatient, and Facility. Massterpatient and Facility are linked just to get extraneous info like names. Patient Allergy and Patient Visit are left outer joined by masterpatientid and visitnumber. So all visits with an allergy display...

Using CR 8.5. We have patients, allergies, and allergy codes. - Some patients have allergies. Some do not. - Some allergies are coded. Some are uncoded (null codes). How can patients with only uncoded allergies be displayed? Here's the catch. We want all those patient's allergies to display...

Posted in Citrix section but no replies there. Citrix Client 10.150.58643 Using C#. When printing more than three pages of progress notes, printer overlays next page of notes over previous page. We have a patient that has 7 pages of progress notes. Preliminary testing shows following results...

Citrix Client 10.150.58643 When printing more than three pages of progress notes, printer overlays next page of notes over previous page. We have a patient that has 7 pages of progress notes. Preliminary testing shows following results: Page 1 printed with no issue. Page 2 printed with no...

That worked, Lillabeth. Nice to see someone else who knows the game of Kismet. Thanks

Trying to create formula for old dice game called Kismet. If basic score is 63 - 70, then a bonus of 35 is added. If basic score is 71 - 77, then a bonus of 55 is added. And, if basic score is over 78, then a bonus of 75 is added. Can get two of three criteria to function, but can't get all...

Turkbear: The restatement of criteria code seems to do the job. lbass: Actually, the sql code ended up being the same for both commented and uncommented. When I ran it in oracle, I had to add one more parameter to make it work. Can't post the original code, bound by agency guidelines. It would...

Turkbear, I know it's hard to troubleshoot from the hip, but, I would prefer not to post specific code. Yes, there are nulls involved. All columns do have null values. There are two tables and they are left outer joined. That was the initial problem with two parameters and not all rows were...

Crystal 8.5 with Oracle 10i All VARCHAR2 fields. Have four parameters and Record Selection formula in part below: and ({TABLE.COLUMN1} = {?COLUMN1} or {?COLUMN1} = "") and ({TABLE.COLUMN2} = {?COLUMN2} or {?COLUMN2} = "") and (UPPERCASE({TABLE.COLUMN3}) = UPPERCASE({?COLUMN3) or...

Thanks lbass, that worked!

Crystal 8.5 Oracle 10g database The Record Selection formula goes like this below. It is one of many other parameters that will display specific results if something is entered in the Parameter Values window, otherwise results are displayed not using parameter...

That seems to be the right track. The tables were linked: table1.SHIFT_CD = table2.SHIFT_CD (+) The tables are now linked: table1.OT_SHIFT_CD = table2.SHIFT_CD (+) Thanks for sticking with it lbass.

This worked: if isnull({table1.ot_shift_cd}) then "No Shift Code" else if {table1.ot_shift_cd} in[1,2,3,4,5,6] then totext({table1.ot_shift_cd}), 0) else "Invalid Shift Code" I guess my real question should be how to make the script work dynamically? (i.e. instead of hard coded values 1-6...

The tables are linked in the stored procedure with a left outer join. The script works great for nulls. But, the report also needs to check for invalid codes. (EX: ot_shift_cd 0 is not null but is invalid).

Tables are linked by shift_cd. There are also other fields in both, but are not relevant. Unfortunately, there is no referential integrity. table1 (Employee_Detail) table2(Shift) shift_cd ot_shift_cd shift_cd 1 0 1 2...

Oracle 10g and CR10 There are two tables, table1 with a field named ot_shift_cd and table2 with a field named shift_cd. Both are number fields. The report currently displays "No Shift Code" if the ot_shift_cd in table1 is null. However, I'm out of ideas on how to return a string value...