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 bkrike 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: *

  • Users: MRWARNER
  • Content: Threads
  • Order by date
  1. MRWARNER

    Crosstab Row Numbering

    Help please, Using Cr9/SQL DB, Crosstabs: I want to add a column to the left of my row header(name)displaying a numerical sequence (1,2,3,4,5 etc....) I guess it would be like numbering the row header but I want to keep the row header (name) as the alpha sort. We will be adding new names each...
  2. MRWARNER

    CR9 Crosstab Percent of Difference

    I have been searching for a solution and have found lots of answers but not the one I needed. I am posting this because I think it resolves my issue but I'm not sure if I will have repercussions from this method. Please respond. In CR9 Crosstabs I am trying to create a % field based on the...
  3. MRWARNER

    Using ALL in SQL parameters

    Using SQL 2000 Stored Procedures I needed to pass an ALL parameter back to CR9. I couldnt find any information on this for SQL. I borrowed and altered an idea from a friend and it seems to work just great. Can anyone think of any reason why this might not work? I created a temp table and put...
  4. MRWARNER

    CR9 Logon Failed

    Have some reports (CR 9.0) that I open in a vb6 application, the db is SQL 2000 – I am connecting with ODBC If I run the report in crystal I have no problem, when I try to open it in Application I get this message : Logon failed. Details:2800:[Microsoft][ODBC SQL Server Driver][SQL Server]Login...
  5. MRWARNER

    CR9 Logon Failed

    Have some reports (CR 9.0) that I open in a vb6 application, the db is SQL 2000 – I am connecting with ODBC If I run the report in crystal I have no problem, when I try to open it in Application I get this message : Logon failed. Details:2800:[Microsoft][ODBC SQL Server Driver][SQL Server]Login...
  6. MRWARNER

    CR9 Logon Failed Connection Properties

    Have some reports (CR 9.0) that I open in a vb6 application, the db is SQL 2000 – I am connecting with ODBC If I run the report in crystal I have no problem, when I try to open it in Application I get this message : Logon failed. Details:2800:[Microsoft][ODBC SQL Server Driver][SQL Server]Login...
  7. MRWARNER

    Wildcards, Parameters and ALL

    Here is my code for Parameters that will allow a one or all type search with the (one) being a wildcard search. ('*'+{?Name}+'*' LIKE {@Name} OR {?Name} = "ALL") AND ('*'+{?Insureds}+'*' LIKE {@ssn} OR {?Insureds} = "ALL") I am using Crystal Reports 9 - When I use this with the WildCard "*"...

Part and Inventory Search

Back
Top