Search results for query: *

Hello All, I have a single column field that contains both a name and an e-mail address: Alice In Chains aichains@aol.com Howdie Doodie hd@msn.com I need a query that removes the e-mail address and leaves the name: Alice In Chains Howdie Doodie Since the e-mail address is consistent - in...

Hello All, I have the following formula to calculate the time duration (in business hours) it takes to resolve help desk tickets. The formula below works well…. Local DateTimeVar StartDate := DateTime({PROBLEMS.OPEN_DATE},{PROBLEMS.OPEN_TIME}) - (5/24); Local DateTimeVar EndDate :=...

PHV, Excellent! Worked like a charm!!! Many Thanks, - Tom

Hello all, I have a field that generally holds to this format: FirstName <space> LastName <space> E-Mail Address. I need to remove everything but the e-mail address. I thought the best way to accomplish this was to use something like the RTrim() function to the first blank space (end of last...

Got it. Thanks Ro!!!! - Tom

Hello All, Thank you all for such prompt and excellent replies!!! I’ve tried all three and, as synapsevampire predicted, there are no real performance issues with any of them. Like Rosemary, I am slightly more comfortable with SQL than Crystal syntax and therefore would like to use her...

I have a formula (@Date_Sort) that I use as a group in my report. It’s used to conditionally sort the group by a date field. If {tabel.stringfield} = "Cond1" Then {tabel.datefield1} Else If {tabel. stringfield} = "Cond2" Then {tabel.datefield1} Else If {tabel. stringfield} = "Cond3" Then...

synapsevampire, Perfect! Exactly what I wanted. Thanks a bunch!!! - Tom

Hello All, I have a fairly simple report that has two groups: Group1: Based on a field called “Status” (i.e. retired, active, potential) Group2: Based on the record ID (a details section) What I want to do is sort the report on certain date fields according to the “Status” group value. For...

Hello All, I had a similar issue and found this on the MSDN site. Either method they offer works well. http://office.microsoft.com/en-us/assistance/HA010345351033.aspx - Tom

VBrit, Thank you for your reply. I thought as much but held out foolish hope there might be a way. Thanks again! - Tom

Hello All, I'm using CR 10 and I've been given an Excel spreadsheet to generate a report from. Normally, no problem. However, with this spreadsheet the author inserted multiple (12) 'Check Boxes' in one column and grouped them together. One, all, some or none of these check boxes may be...

Hello All, I'm using CR 10 and I've been given an Excel spreadsheet to generate a report from. Normally, no problem. However, with this spreadsheet the author inserted multiple (12) 'Check Boxes' in one column and grouped them together. One, all, some or none of these check boxes may be...

Hi Lebisol, Thanks for your reply. All I get for error messages is: "Server Error in '/' Application. Runtime Error" Thanks again, - Tom

This is driving me CRAZY! All I’m trying to do is change the database path from this: string connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ Server.MapPath("access.mdb") +";"; string sql = "select * from events"; To something like this: string...

Hello All, This is driving me CRAZY! All I’m trying to do is change the database path from this: string connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ Server.MapPath("access.mdb") +";"; string sql = "select * from events"; To something like this: string...

Hello All, I'm trying to create a community calendar using some code I discovered in a tutorial I found on Macromedia's site. [link]http://www.macromedia.com/devnet/mx/dreamweaver/articles/aspnet_calendar.html[/url] <%@ Import Namespace="System.Data" %> <%@ Import...

Hi LB, Thank you for your reply. Sorry for the delay in getting back to you sooner. I couldn't log on to this site all morning. I have a report that returns client info where that client’s subscription has recently expired. Users enter a number in a parameter field, say 100, and the report...

Madawc, Thanks. I tried that, but it stops reading the string after the first non-numeric character. For example, if a phone number in the field is "(123) 456-7890" then it will not return the record. Your first post worked just fine! Thanks again, Tom

Madawc, That worked beautifully! Thanks!!!! Tom