Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. suechamps

    Excel tab name when exporting from CR11

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

    Excel 2002 - If Statement

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

    Excel 2002 - If Statement

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

    Crystal 8.5/Saleslogix 6.2 - want to link Access 97 table to report

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

    DateTime Record Selection

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

    DateTime Record Selection

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

    DateTime Record Selection

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

    DateTime Record Selection

    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"...
  9. suechamps

    DateTime Record Selection

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

    DateTime Record Selection

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

    Concatenate Duplicate Groups

    Thanks so much that worked perfectly! ~Sue
  12. suechamps

    Concatenate Duplicate Groups

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

    Concatenate Duplicate Groups

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

    Split Formula Problem

    Thanks so much, that worked! Sue
  15. suechamps

    Split Formula Problem

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

Part and Inventory Search

Back
Top