Search results for query: *

Thank you both for the sql and explaination. I have several others that I will modify using this format. Scott

Mainly an MS Access user I need to start doing things in SQL Server. After much tweaking I came up with this sql. It works but I want to see if there is a better way to write this. SELECT dbo.Training2_V.LBU, dbo.Training2_V.District, Count(dbo.Training2_V.SRNumber) AS Calls, Sum(CASE...

Hi All, Crystal 8.5 SQL server These 2 parameters work by themselves. I'm trying to combine them so either one or the other can be used in the report. 1. (if {?Wildcard Dealer} <> "All" then {HISTORY.ACCOUNTNAME} like "*" + {?Wildcard Dealer} + "*" else if {?Wildcard Dealer} = "All" Then True)...

LB, Thanks again. Its starting to make sense to me now. Have a Happy Turkey Day Scott

LB, One More item if you could. I'm trying to get the info printed in the report header. I previously used that works OK:(I'm using Left because I just want to display the first 3 chars of the result codes unless "All Dealer Visit Codes" is selected then I would display the whole string...

Thanks for the present LB. It makes sense now seeing how it should be written. I'll add the other code back and try all the parameters. Thanks again, Scott

I'm using Crystal 8.5 and connecting to SQL Server. I'm using multiple parameters in the select expert and are having problems with one set of parameters. I've removed the working code (except for date range)to try to troubleshoot the problem area. Here is the formula: (if {?Result Code} <>...

Why doesn't this formula work? It used to with the old version of Sales Logix. If I take out the HISTORY.ACCOUNTNAME section the report works. We are using SQL server and switched to an OLE DB connection for Crystal reports rather than the ODBC connection we had with the old Sales Logix. (if...

K, Thanks That worked. can you explain why the Mid function didn't work for the account name but workes for city. Scott

Ok, I imported a list into the default values in the parameter field. They look like: companyxyz in charlotte companyiny in seattle companyttf in atlanta ...etc the formula I have in the select expert is: {HISTORY.ACCOUNTNAME} = Mid({?Dealer},1,(InStr({?Dealer}," in ")-2)) and {ADDRESS.CITY}=...

Ido, Sorry I forgot to mention that Account name and city are in two different tables. Don't know what you mean by: using export to text and import from file cycle How would I get AccountName/City to display in the default values of the parameter list? Thanks, Scott

Is there a way to combine 2 fields in a parameter. We have a lot of accounts that have the same name. The only way to search and get the exact one you need would be to use their name and the city. Can this be done? Thanks, scott

I removed the rest of the selection formulas and tried just the wildcard section but can't get the syntax right. numbervar Increment; stringvar FieldValue; (if {?Wildcard Dealer} <> "" then for Increment:= 1 to count({?Wildcard Dealer}) Step 1 Do if...

I tried the formula that was in the thread but all it did was search forever and not return any records. I don't know if it has to do with the rest of the selection formula. Here is what I have: numbervar Increment; stringvar FieldValue; for Increment:= 1 to count({?Wildcard Dealer}) Step 1 Do...

Thanks, I'll give that a try

Is there a way to allow multiple values (wildcard) in a parameter field. I can get 1 value to work using: (if {?Wildcard Dealer} <> "" then {HISTORY.ACCOUNTNAME} like "*" + {?Wildcard Dealer}+ "*" else if {?Wildcard Dealer} = "" Then True) But can't get it to work with multiple values. Do you...

I'm trying to limit the columns in a crosstab formula. Here is the condition I'm working with: {HISTORY.CATEGORY} in [&quot;CDT Dealer Telephone Support&quot;, &quot;CDV Dealer Visitation&quot;, &quot;CTS Technology Update Support&quot;, &quot;COA Other Customer Activity&quot;] I only want to...

First off let me say that I'm new to CR9 so be easy on me. I've been using MS Access for about 10 years and I want to try something different for reports. I created a crosstab report with a field that sums up minutes. I want to show that field as HH:MM. I have a formula to do that but don't know...