Search results for query: *

Hello, I have just begun to use Crystal 11. Previously I was using 8.5. When exporting to Excel I am using Microsoft Excel 97-2000 - Data only(XLS). When report is opened in Excel, the tab name of the report is "Sheet 1". In 8.5 the tab name of the exported report would be the file name of...

John, Thanks for the reply, but that did not work for me. Hopefully, here's a better explanation of what I'm trying to accomplish: SHEET 1 Bank # Branch # Branch Name 1 2010 Portsmouth 1 3010 Topsfield 1 9010 Congress St 1...

I'm working with 2 spreadsheets with 3 columns: Bank #(Col A), Branch #(Col B) and Branch Name(Col C). I need to identify those branches where the bank # matches, if so, does the branch # match, if so, return the branch name. I have tried the following: =IF('[north listing...

My database is Salelogix 6.2 and I am using CR 8.5. I have information in Access 97 database that I want to bring into report. I have managed to add the Access table to the report. I want to link Saleslogix field {IP_BENEFITS.ALT_REP2_CD} to Access field {REPPHONE.ALT_REP2_CD}. When I link...

In answer to SV's question...yes I did try increasing the day by one day and the data returned included the date range that I am looking for. So I am at a loss because I do not understand why {HISTORY.MODIFYDATE}>=DATETIMEVALUE(2005,07,01,10,00,00) returns the expected result but...

I tried the suggestions of both MrBillSC & synapsevampire...but with no luck. I going to try to rethink the report to see if I can somehow pull the data another way... Just wanted to thank you both for trying to help me! Sue

Here's the update: I removed all criteria from the Report->Edit Selection Formula and changed the selection from just < to <= to see if anything pulled: {HISTORY.MODIFYDATE}<= DATETIME(2005,07,08,10,15,00) and again nothing with a modified date prior to 10:15 am on 7/8/2005 was returned. I...

The field's data type is DateTime. Here's the Show SQL Query: SELECT ACCOUNT."ACCOUNTID", ACCOUNT."TYPE", ACCOUNT."ACCOUNT", ACCOUNT."CREATEDATE", IP_ACCOUNT."REFERRAL1", IP_ACCOUNT."REFERRALDATE", IP_ACCOUNT."PAYON", IP_ACCOUNT."CUSTNUM"...

I'm sorry if I did not explain this well. Let me try this again: I'm using Crystal 8.5 I believe the answer to the Database/Connectivity question is ODBC What I'm trying to accomplish is the following: A report listing accounts that were modified during a specific time frame. This time...

I am trying to select records based on a date & time range: The entire record selection formula: {IP_ACCOUNT.REFERRAL1} = "Bank" and {ACCOUNT.TYPE} in ["Sold", "Sold DDOS", "Sold Pending"]and ({HISTORY.MODIFYDATE}>=DATETIME(2005,07,01,10,00,00) and...

Thanks so much that worked perfectly! ~Sue

This worked great except for the very first rep. It got suppressed but only appears one time? Thanks, Sue

Using Crystal 8.5. Creating a report to reflect the # of accounts transferred from one Sales Rep to another. Report is grouped as follows: Group 1: @REP Group 2: INTERPAY_ACCOUNT.ALT_REP In Group 2 header I have concatenated as follows: @ REP [@TRANSFER COUNT][@BRANCH TEXT]transferred from...

Thanks so much, that worked! Sue

I'm using Crystal 8.5 and I'm having difficulty using the split formula. I have a string that I need to split "-" character in the string. The "-" does not fall in the same place in each string: 12-ABCDE 123-FGH and one instance of 123-ABC-DEF GHI I am using the following formula which I...