Search results for query: *

Good morning: I have been tasked with managing a project (Program) which involves implementing a JAVA licensing and Management system at multiple sites. Planning started 10/2014 and all sites must be complete by 6/2016. There are 32 sites, each site requires the exact same tasks and there...

Staggered start / Rolling Schedule and Predecessors I have a project to install software across 30 sites. The WBS is the same for each site so the plan would look something like this Site1 Task1 Subtask 1.1 Subtask 1.2 Task2 Subtask 2.1 Subtask 2.2 Site2 Task1 Subtask 1.1...

Good morning: I have a database with 2 tables (OCT_ASSETS and ALL_ASSETS) Each table has asset # (ASSET_OCT and ASSET_ALL) I want to compare the two tables something like this: If ASSET_OCT = ASSET_ALL Then I want it to show ASSET_OCT along with other data from the OCT_ASSETS table. Thanks in...

I have a report in that list all clients for a specified outpatient (recurring episode) program, last appointment, who they saw, and how many days since they were last seen. The report works as it is but it is grouped by Patient Name. When I try to group it by clinician it gives me inaccurate...

I have a report that I need to sent to a vendor on a daily basis. It list patient, phone number, appointment time, and appointment date. The vendor needs to recieve this file as a comma delimited text file. I can manually export the report into this format but is there a way to have the report...

I have a report in CR11 that lists Clinician, Patient name, date of appointment, and apointment value. The report is grouped by Clinician my data looks llike this Dr Smith Patient A 09/01/2012 NS Dr Jones Patient b 09/01/2012 CP Dr White Patient c 09/01/2012 NS Dr Green Patient d...

Can anyone please help me out here I am kinda under the gun to complete this report Thanks in advance

do you have anything in your database manager, that would allow you to create a "view"? That way you can create the view and "see", the underlying sql atatement." Yes it is the same as the code in the SQL command that I posted above. There was also a Parameter at the same time as the command...

The only thing i dont understand is A collegue from another hospital is running the same system except he is running a newer version of Cache and it works as intended on his system. That is what makes me think it is a syntax issue. I am about ready to give up on the SQL command and just try...

I have a Crystal XI report that list all clients for a specified outpatient (recurring episode) program, last appointment, who they saw, and how many days since they were last seen. I couldnt get it to group properly to get the dadt the way I wanted it. It was suggested that I use an SQL...

OK I can deal without the bold name but I have added to the formula: Numbervar Days; if (isnull({meditech_accts.SERVICE DATE})) then Days := 99999999 else Days := DateDiff ("d",{meditech_accts.SERVICE DATE}, CurrentDate);if Days = 99999999 then GroupName ({avatar_jail.Pat Name})+" "+" NO APPT...

Ian: Thanks for the quick reply it works just like I want but is there a way to make the GroupName ({avatar_jail.Pat Name}) bold?

I have a formula that ouputs "NO APPT DATA ON FILE FOR " + fIELD + "PATID" + FIELD + FIELD + "FOR EPISODE" + FIELD IF THE SERVICE DATE ISNULL. A sample of the output is; NO APPT DATA ON FILE FOR DOE,JOHN PATID: 2,306.00 FOR EPISODE 1.00 I need to format the GroupName ({avatar_jail.Pat Name}) to...

when I use: if isnull({billing_tx_history.date_of_service}) or {billing_tx_history.date_of_service} = date(0,0,0) then 99999999 it returns 99999999 if billing_tx_history.date_of_service isnull and returns 0 if billing_tx_history.date_of_service is not null when I run...

-LB I tried what you said and It still only works if ({billing_tx_history.date_of_service}) has a value but if it isnull it just shows a blank field

It is not checked. This shoudnt be this hard I dont know why it isnt working.

I removed or TRIM({billing_tx_history.date_of_service})="" Numbervar Days; if isnull({billing_tx_history.date_of_service}) then Days := 99999999 else Days := DateDiff ("d",{billing_tx_history.date_of_service},CurrentDate); if Days = 99999999 then "No appt data on file" else "Patient last...

I got this from -LB Numbervar Days; if ( isnull({billing_tx_history.date_of_service}) or TRIM({billing_tx_history.date_of_service})="" ) then Days := 99999999 else Days := DateDiff ("d",{billing_tx_history.date_of_service}, CurrentDate); if Days = 99999999 then "No appt data on file" else...

I have 2 formulas in a sub-report.One gives me the number of days since a patients last appt. and one displays "NO APPT. DATA ON FILE" if {billing_tx_history.date_of_service} is Null. How can I combine the 2? The formulas are as follows 1) Numbervar Days; Days := DateDiff...

I have the formula working but now I want to display "No Appt. Data" if apptdate is null Here is what I have but it isnt working: datevar apptdate; stringvar svccode; stringvar staffname; IF ({appt_data.appointment_date} <= CurrentDate) THEN (apptdate := {appt_data.appointment_date}; svccode :=...