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!

  • Congratulations TouchToneTommy 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: hawg
  • Content: Threads
  • Order by date
  1. hawg

    Comments on Training by Kimball University

    Hi All, I am looking at attending the Kimball University class: ‘Data Warehouse Lifecycle in Depth’ and would like comments from anyone who has attended a Kimball University class. Last year, I attended the TDWI world conference in Las Vegas and was impressed with the quality. This year I...
  2. hawg

    ODBC Login failed from outside the domain

    I have a sql server 2000 installation on a Win2003 server. I am trying to connect via ODBC from my web server (a Win2000 box). I get error message: " Login failed for user '<username>' ". I think the trouble is that the web server sits outside the domain from where the ss2k is installed. I...
  3. hawg

    Are Multiple SQL Statements in SQL Designer Possible?

    Using: Crystal Reports 8.5 with Informix database I want the Crystal SQL Designer to issue 2 or 3 separate SQL statements against my database. From what I can tell SQL Designer can only handle one SQL statement, is there a work around? My first statement will be to set the user role to read...
  4. hawg

    Graph percentage of total sales from Multiple Series

    Hello, using: CR v8.5(dev) with SQL Server7.0 I would like to graph the contribution toward each month's total Units Sold by individual product line. I need my x-axis to change on date (&quot;for each month&quot;) and the y-axis to show the &quot;market share&quot; of the months total...
  5. hawg

    Finding 3 Consecutive Months in History File

    I am looking for a method to find all records of those who &quot;qualified&quot; for 3 or more CONSECUTIVE months. If an employee &quot;qualified&quot; in a particular month there will be a record in the table with the month and their ID. If they did not qualify--no record. MyTable: ID...
  6. hawg

    Can I Sort on a Summary field using a Parameter??

    Using SQL Server 7.0 and CRv 8.5 My report is grouped by a product Number (i.e. the left 4 characters of [SalesUSA].item). I want the sort order as a parameter field. My problem, as far as I can tell, is the two fields I want to sort on are summary fields. Creating the formula field below...

Part and Inventory Search

Back
Top