Search results for query: *

I have tried suggestions from other posts like using Report Selection Formula/ Group but I couldn't get them to work. This is a report that displays a schedule build for procedures and every time the schedule is adjusted it is given a new Effective Date. I need to pull the schedule build with...

Hi, I need to pull patients first locations when being admitted to the hospital into a report. The fields in the database are pat_loc1, pat_loc2, pat_loc3, pat_loc4, pat_loc5, etc. The values of the location fields are updated in the database so that the most current location is #1, for...

I am using Crystal XI to pull data from an Oracle database. I have a SQL (that I am using for reference) where the date field {TABLE.START_DDT}, which is a number field, is converted to a date using ddt.todate{TABLE.START_DDT}. I have not been able to figure out how to do this in Crystal...

Hi, I am a Crystal report writer trying to create a Crystal report based off of a SQL that I was given. The report pulls from an oracle database. I am trying to add the tables from this FROM statement to my Crystal report. FROM O_ITEM, O_PAT, ent_config.STAFF O_STAFF-AUTHORIZE, PRIORITY...

When I use this URL it just opens the Crystal Report Login screen, it does not pass the Username or password to the login screen. I have tried the Guest account with no password and a username and password and both behave the same. If I manually enter username for Guest or username and password...

When I use this URL it just opens the Crystal Report Login screen, it does not pass the Username or password to the login screen. I have tried the Guest account with no password and a username and password and both behave the same. If I manually enter username for Guest or username and...

Very much a Newb here, trying to create a case statement with multiple 'likes' and I do not know the correct syntax is or if this is even possible. This is just a sample, the actual case statement is bigger: CASE WHEN casepro.act_proname like ['%COLOS%','%COLON%'] then "COLO" WHEN...

I have a Crystal V10 report that uses {appt.start_datetime} = {?StartDate} in the selection formula to pull scheduled appointments. There is a subreport that is linked to the main report by a Patient_id field and ?StartDate to ?Pm-StartDate. I need the subreport to pull all appointments...

Hi, I have data that looks like this: Accession#: 14CP123 Reason for study: 1. Shortness of breath 2. Chest pain Summary: 1. First diagnosis 2. Second diagnosis 3. Third diagnosis The data is stored as {document_text_c.line_text} where each line of text is stored separately as...

This is my @HtIn formula that displays height in inches: if {casevisitresultlistwt.label_seq} = 9997 then left({casevisitresultlistwt.result_value},2) else '' This formula returns values, for example, of 65, 73, 40. I need to display this as feet and inches in two separate columns. Like...

I am trying to extract data from a string...my data looks like this: Strength: 4 mg Strength: 30 ml before bed Special instructions: On full stomach Special instructions: Take before breakfast Strength: 20 mg and sometimes the field is null/empty I need to pull the text from the strings...

I have three different subreports that pull medication admin times into three columns on the main report. One column displays meds to be administered from (07,01,00) to(15,00,59). This is my formula: time({THERAPYADMINISTRATION.ADMINISTRATIONTIME}) >= time(07,01,00) and...

I have a 200,000+ row report that I am trying to export to Excel 2010. First of all when I try to export, Excel 2010 is not an export option. I did some research and what I have read is that it is either a problem with missing dll's on my computer OR it may not be an option to export from...

Hi, We still have an application that uses Crystal 8.5 and I need to modify one of the "standard" reports that comes with the application. It contains this formula: "QTY:" + NumberFormat(({TABLE.QTY}*{TABLE.DISPENSESIZE}),0) but I can't get the standard report to run outside of the...

Hi, Regarding previous thread 1623741. The resolution works very well but we have recently noticed a problem when there are duplicate RX#s. For example: RX# Drug Dose Comment 123 Amoxicillin 250 Take with food 1234 Diprovan 250 x2 doses...

We have a text field that is stored in multiple rows like this: 1/2 tablet every 8 hours Linenumber 1 as needed for headache Linenumber 2 not to exceed 8 tabs Linenumber 3 in 24 hour period Linenumber 4 We need this to display horizontally on our report like...

Hi, My data looks like this in the details section of my report: Description Area NDC(string) Onhands Acetaminophen ED 123 1 Actaminophen ICU 1234 3 Acetaminophen ED 123 2 Acetaminophen 4W 12345 4 Acetaminophen TCU...

Hi, My data looks like this: Description Area NDC(string) Acetaminophen ED 123 Actaminophen ICU 1234 Acetaminophen ED 123 Acetaminophen 4W 12345 Acetaminophen TCU 222 Acetaminophen 3S 222 I need add an X in a column when the Area is ED and...

Help please...I need to add comments which are stored like this: {table.textline} {table.linenumber} SLIDING SCALE HUMALOG 1 BEFORE MEALS 2 REQUIRES SIGNATURES 3 To medications in the details section of my report so that they...

We use this formula to display allergies horizontally. How can I get it to NOT display allergies that have an inactive date? For example, allergies are: Aspirin (inactive date is null) Penicillin (inactive date is null) No allergy information (Inactivate date of 10/1/10) Currently it...