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

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

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

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

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

Hello All, I have a report that returns records based on a parameter field that searches a phone number field. Users want to enter just the number into the parameter field i.e. "1234567890" for a field string (inconsistantly) formatted like "(123) 456-7890" or "123-456-7890". Is this possible...

Hello All, I’m having a problem with group selection and can’t figure why. I have a group based on the following formula: Left({Table.PRODUCT_CODE},3) I have a Parameter Field, {?Product Code}, where users enters the first three characters of a product code, i.e. 101, 102, ABC, etc. I have...

Hello All, I’ve been searching this site for help on how best to do this but haven’t found an applicable solution so let me just put my issue out there. I am working with a publication database that tracks client’s subscriptions to various products. I need to create a report that returns Nth...

Hello All, I've recently encountered a problem where I can no longer insert a table (drag-and-drop - via the toolbar icon) into a html page. I get a "Table.htm" JavaScript error message. I suspect my app has somehow been corrupted. Has anyone else encountered this problem before? Can I simply...

Hello All, This is similar to a previous posting, but different enough that I can’t figure out how to make it work from an excellent reply to that posting from MrBill. Here goes. I have a simple 3-table report: MEMBER, SUBSCRIPTION and DETAIL. The MEMBER table holds member info, the...

I need to create a QA report to check for data entry errors. I have a seemly simple 3 table report: MEMBER, SUBSCRIPTION and DETAIL. The MEMBER table holds member info, the SUBSCRIPTION table holds the subscription info for the member and the DETAIL table holds info on the member’s...

I have a simple report using only two tables (CLIENT, PUB). The records are displayed in the Details section. The tables are linked in your average One (CLIENT) To Many (PUB) relationship. Therefore the report returns duplicate CLIENT records if a client has multiple pubs. I want to suppress...

I’ve inherited a report that generates a form letter to remind clients that their subscription for a certain product will expire in X months. They get a letter every month for the three months prior to the expiration date. Clients can then either: 1. Not renew 2. Renew for 1 year 3. Renew for 2...

I’m experiencing a BIZZARE issue with a simple Label report I’m using the following formula to get the names & address for the labels: {Name.FIRST_NAME} & " " & {Name.LAST_NAME} & Chr(13) & If IsNull({Name_Address.ADDRESS_2}) Or {Name_Address.ADDRESS_2} = "" Then {Name_Address.ADDRESS_1} &...

I think I’m screwing up the parentheses in the Select Expert because it ignoring other sets of parameters. I have this set that returns the data I want: ( If {?ParameterField} = "ParameterString1" Then {Db.Field} = "FieldString1" Else true) Or ( If {?ParameterField} = "ParameterString2" Then...