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

  1. Whippingboy2004

    New to Subreports

    I'm having trouble adding a subreport onto an existing report. The main problem that I'm having is with the parameters. I'm using stored procedures for both the main and sub. They both have input parameters of @BeginDate, @EndDate, @Region, and @County. Is it possible to pass the subreport...
  2. Whippingboy2004

    Distinct Count Issue

    I'm having an issue with a report I'm trying to write in SQL 2000. I'm trying to determine a count for each letter type (NewCert and ReCert, the final report will have about 10 types) AND want to count each Case only once for each letter type. SELECT DISTINCT(tl.CaseID), NewCert=CASE...
  3. Whippingboy2004

    Decimal issue in age function

    I'm having a problem with my age function returning a decimal point with either one or two trailing zeroes. I've tried using LEFT, but since my ages are being returned as either single or double digits, it's not been successful. What I'm trying to accomplish with this is to get the age in...
  4. Whippingboy2004

    Suppress Total in Group Footer

    Is there a way to suppress the total from GF1 in the various drilldown sections as shown in the following: GH1 Region GH2 County (drilldown) GH3 City (drilldown) D ZipCode (drilldown) GF2 Region Total (drilldown) GF1 State Total I would like the State Total to show on the first page...
  5. Whippingboy2004

    All drill down data not showing up

    This is a two-part question. 1). I'm having an issue with all of my data showing up in the detail section. For some reason, only the first CaseName is appearing. I'm using Crystal 8.5 and getting my data from a stored procedure in Microsoft SQL Server. The data is being returned normally in...
  6. Whippingboy2004

    Comma placement in string

    I'm using a cursor to concatenate the values of a one-to-many relationship into a single column. See I read the FAQ's, specifically faq 183-2146! What I'm having an issue with is the comma separating each value. Depending on my placement of the comma in the statement, I get either an extra...

Part and Inventory Search

Back
Top