Search results for query: *

Please excuse me if this has been discussed before - I've searched the forums and found several 'closed' topics, but no definitive answers. Is there a way to force a new window when clicking on a hyperlinked crystal reports field? I have the hyperlink part of it nailed - I just need...

Good afternoon everyone! Plain and simple... here's what I need help with: [fire_chief_name] and [fire_chief_email] need to be required form fields if either [mem-type='alternate'] or [mem_type='delegate'] are selected from the list/menu. If not, neither [fire_chief_name] or [fire_chief_email]...

I'm trying to accomplish the same theory as rfisch, but compare last months data with the current months data. Would the formula be similar?

Hello all... again. I thought what I had was a simple job trying to create this report, but has turned out to be one problem after another. Here is what I am trying to accomplish: To create a simple report showing the status of emails coming in through our website. In doing this, I am trying...

Thanks for the quick response Mike. By chance, your last name isn't Barron, did you grow up in Richmond, Virginia? Mark

Hello once again! This time my question pertains to a situation that was dumped on me to fix. My problem: An application that enables users to write data to the database I’m extracting my information from for Crystal doesn’t have a spell-checker or pull-down menu for table name entries. What...

Okay... well that's how I've got it set up now. But what I need is to be able to "count" only the "true" statements... If I have rec'd 30 emails; 25 have been responded to and of those 25, 10 were responded to within the 24 hour service level. My formula now shows a count of...

Hey... Thanks Geoff. Not to sound too stupid... I'm learning as we go here. But how would the formula look? And would it be in the reset area or the evaluate area?

Hello all... again. You know, if it wasn't for this forum I wouldn't know half of what I know about Crystal... my thanks for your help! I have come to you, yet again, with another situation I need help with. The report I'm working on is designed to communicate the statistics of incoming...

Hey... sorry for the confusion! In rearranging the formula fields I was able to obtain the outcome I was looking for! Thank you so much for help! Mark

Well, it was very simple...{customer_response.response_dt_tm} - {customer_inquiry.create_dt_tm}. This gave me the elapsed time since the email was submitted (in days)until it was responded to... or not responded to. But, it only caught emails that had a response. This was done by creating a...

I need to be able to subtract the {Response_DT_TM} field and the CurrentDateTime from the {Create_DT_TM} field in order to come up with my 'elapsed time since recieved' [M]

Thanks Ken, that wokrs perfectly! Except! Now my subtraction formula doesn't work. How can I have both? Mark

Greetings everyone! I have created a report using CR 8.5, drawing information from a SQL database. This report is designed to give our business unit management the average total time it takes for the business unit to respond to an email by capturing the {submit date field} and the {response...

Thanks for the quick response Ken! Shortly after posting this message I figured it out! Exactly the way you suggested! Thanks again! Mark

Is there a formula to extract a date range from a report? Trying to capture records starting 06/01/2001 through 06/22/2001 and then picking back up again on 06/26/2001 until 06/30/2001. Any simple way to do this? Thanks! Mark

Ken. Could ypu please show me how the formula should look. I am very new to Crystal and am not completely comfortable with using it. Thanks. Mark

Hey Ken. Thanks for getting back with me. I'm trying to do what you mentioned first... trying to exclude records with Saturday and Sunday in the date field.

Thanks for your reply Ken! I read your FAQ and that, for the most part addresses my question. Although I probably should have explained that the data I'm working with changes on a daily basis. The start date and end date fields change every day. Therefor, I'm not really working within a range...

I've created a report in which I'm capturing elapsed time values from a create date and end date data field. My question: Is there a formula or simpler method to "only capture" Monday through Friday... and excluding Sat. and Sun??? Any help would be appreciated! Mark