Search results for query: *

Is there a quick/easy way to copy a details section (formulas and all)? I have a large amount of work ahead of me if not ... I want to copy Details E and make about 30 more detail sections. I really dont want to copy and paste all day ... surely there is a faster method. FYI im on Crystal 9.

My current formula: if isnull({SB1001_main.PatientPhone1}) then "" else if isnull({SB1001_main.PatientPhone1}) then {SB1001_main.PatientPhone1} else {SB1001_main.PatientPhone1}+" / "+{SB1001_main.PatientPhone1Type} My issue is if there is no phone # entered, its reporting the following: () - /...

I think I need a formula versus using a text box in this scenario. I used a text box and dragged over the CustomerFirst, CustomerMiddle and CustomerLast Name fields. Whats happening now is if the customer doesnt have a middle name, its putting an extra space between the First and Last Names. Can...

I am having to do a Spanish and an English version of a report. I personally do not speak spanish. The client provided me the text they needed and I added that into my report ... The only issue is this ... they want the Date field to Print as such ( Friday, August 10, 2007 ) .... This is...

Two Fields: Phone1 Phone1Type I put a text box into my report and put in Phone1 then a "(" and then Phone1Type then a ")" If the report is null its just putting a "()" in my report ... can I suppress if Null somehow?

I am having an issue with a Summary Field. In my SQL Query, I have a Field titled "IHC Patient" ... which is based off a Case Statement. My Case Statement in my SQL Query: CASE WHEN Cast(PI.EligibilityNotes as varchar(8000)) like '%Declined IHC%' THEN 'No' WHEN...

My current formula: stringVar sProcedureDescription := LEFT({ParadigmReceipt.Description}, 200); IF NOT ISNULL({ParadigmReceipt.CPTCode}) THEN sProcedureDescription := sProcedureDescription + " (" + {ParadigmReceipt.CPTCode}; IF NOT ISNULL({ParadigmReceipt.CPTCode}) AND NOT...

My current formula: IF TRIM({rpPatProfile.PatientSSN})<>"" THEN MID({rpPatProfile.PatientSSN},1,3)+"-"+MID({rpPatProfile.PatientSSN},4,2)+"-"+MID({rpPatProfile.PatientSSN},6,4) My client would like to have it formatted only to print the last digits of the patient SSN#. So instead of...

In my application, I have two checkbox fields: Box 1 = Patients W/O IHC Box 2 = IHC Patients Only The data is all sitting on the details band. I am using one suppress statement for both of these checkbox fields: {?INCLUDEWO}= true and {Data.IHC Patient}= 'Yes' or {?INCLUDE}= true and...

Perhaps I'm missing something obvious.... I have three data fields I'm trying to base three formula's on. Data Fields: {data.ArrivalTime} {data.WithProvider} {data.CompletedTime} Formulas: Wait Time: {data.WithProvider} - {data.ArrivalTime} Provider Time: {data.CompletedTime} -...

I have a page header and want it suppressed in my Report Footer. In my Footer, I have a crosstab report and the page header looks bad with it. Can anyone tell me how?

I still relatively new to Crystal. I need to convert a string field into datetime so I can format it accordingly. My issue is I found another instance with a formula being used and now my Date (07/14/2006) is reporting back 07/09/2006. DateValue (Left ({Data.Date},19 )) Can anyone help...

I know this is an odd request but ... In T-SQL, I have 4 fields causing me Time nightmares ... StrtHour=convert(varchar(2),datepart(hour,Start)), StrtMin=convert(varchar(2),datepart(minute,Start)), StpHour=convert(varchar(2),datepart(hour,Stop))...

I have two fields {data.ProviderName} {data.resource} Alot of the time, the enduser is not entering the ProviderName so its causing a blank field to display in my report. How can I program a formula to Pull from ProviderName first and if it null pull the Resource name?

Very confused on how to make this report work. I have used a Union Query in SQL that returns two rows for each distinct ticket #. In my crystal report I placed the primary and the secondary information (the 2 rows) in my details section. Now I'm getting back two sections when I preview the...