Recent content by kowalbp

All, I have a data field which has the customer email address in it. I need to strip out certain characters and format the data in an export format I can use. Original Data Format is: SMTP:{user@company.com}user@company.com I only need the real email data between the {} brackets. How can...

Just to clarify. On a traditional bar graph, with the X axis being the date. I would like the X axis text font to be bold and red if the day of the week is Saturday or Sunday.

OK new user error. So I can't add 'new formatting formula' 'font color' to my graph. I will allow me to add other selection formula like 'background color'. But not 'font color' or 'font style'. No sure why. Why cannot I not add a font style formatting formula to my graph ? When using with...

I've added a formatting formula under \formatting formulas\report header\graph1\tool tip text Here's what I have... if DayOfWeek ({PWDCounter.ResetDate}) = 1 then crBold else crRegular I keep getting the error "the formula result must be a string". How do I go about getting the graph text to...

-LB Thank you very very much. Your code worked perfect. I did add a line and if dayofweek({PWDCounter.ResetDate}) = 1 then time({PWDCounter.ResetDate}) in time(0,0,0) to time(23,59,59) else true In order to get the entire other weekend days data to be included. Thank you very much ! -BK

For a 7pm to 6:30am shift which starts on a Sunday night, does this count as Monday or as Sunday? My thoughts are this would be Sunday up until midnight, and Monday midnight onward. If we need to we can consider this to just be a Sunday instance if easier. In other words, is your weekend 7:00...

All, First let me say I'm not a used to working with Crystal Reports. I have so far been able to create basic formulas getting the results I need. But for this issue I need to consult you expertise. I need some quidance how to create a formula for a specific date range within specific time...