Search results for query: *

I am a bit lost...I think because I need to link to so many tables to get from the Procedure name (proname.name) to the Effective date (Effdate.eff_datetime). This is the SQL from the Crystal report I have been working on... SELECT "proname"."name", "proname"."abbr"...

I had read earlier that this was a possible solution. I have not worked with commands much and had tried to do this earlier, but will try again using your example. Thank you, Jan

Thanks for the reply...sorry it is not clear. The date you see on the rows is the effective date. If there is more than one effective date I need to pull only the rows with the most recent effective date. The Stress Test shows two effective dates, 7/11/11 and 7/14/11, I only want the rows...

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

I am finally able to work on this again and both KENHAMADY and CHARLIY's suggestions work...Oh Happy Day, thank you so much! Jan

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

AndyMC - this worked perfectly...thank you so much!!!

Yes, this is the only date field that is available. I found out that the first 5 numbers are the number of days since 01/01/1800, and the last 5 numbers are the seconds since midnight today (midnight is always nnnnn00000).

Yeah, I do not know how to do this either. I have not been able to find an answer anywhere...thanks though!

...and to clarify, I need both the Start date and start time to display as 7/13/15 09:00 on my report. Thanks so much for your help! Jan

SkipVought, It is not a time stamp, it is a start date/time for an order placed in an application. For example, when a physician orders a medication and they do not want it to be administered until tomorrow, they enter a start date/time of 7/23/15 at 0900. I ran my Crystal report for another...

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

I appreciate both of your replies. Tamar, I found out that you are correct...Thank you!!

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

Thanks for the reply....it seems from other posts that it should be possible. I have Crystal XI service pack 2 or Crystal 10 available to use. Anyone else have any information? Jan

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

I was thinking that might be the 'case' :) Thanks for the extra tip!

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