Search results for query: *

I am embedding an image on each distinct details tab with a specific suppress statement relating to the users ID #. I really dont care to play copy and paste all day to make this happen ... thats why I asked if there is a quicker way. Its much easier changing 30 plus ID #'s and dropping in one...

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.

Perhaps its in the sql statement then .... I just checked that, and sure enough it was the sql. Now all I'm getting is the '/' if null. Can I suppress that too if null?

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: () - /...

Thanks ... just what I needed.

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

You saved me again ... you need to write a book with all your knowledge. Its amazing! Thanks a million ... saved my day.

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?

lbass, Am I creating this in SQL or in Crystal? Can you elaborate just a tad more for me? I really appreciate the help!!!!!

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

lbass, You saved my day ... THANKS A MILLION! You answer alot of questions on here ... do you teach crystal reporting perhaps?

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

Thank you so much ... that was it. I really appreciate it.

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?

Amazing - thanks a million.

Maybe this would be easier: Currently its displaying as such: 2006/07/14 00:00:00.00 I want to read: 07/14/2006