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

    Change to a SQL Union Query

    I am using Crystal 8.5 with a SQL 2000 database. I have two Crystal reports that use a union query. I have a new report that needs two new fields added to that union query. If I add two new fields and rename the union query, how will that affect the existing reports? Does Crystal...
  2. brek2

    Group without duplicates

    I am using CR8.5 with a SQL database. I have a report grouped by recruiter name and detail of interview information as follows: Group1: Recruiter Jim Smith: Detail: Name DateInterviewed InterviewedBy Req# Jane Doe 3/1/2005 Betty Banns 578...
  3. brek2

    Business Hours Problem

    I am using Crystal 8.5 and need to calculate business hours, no weekends, including holidays. I found the sample report called BusinessDays_Hours (How To Calculate Business Hours or Business Days) in the zip file cr_business_dh_samples in the Business Objects knowledge base. The code for the...
  4. brek2

    Crystal 8.5 Calculate Average Days

    I am new to Crystal(using Crystal 8.5 with a SQL database). I need to show average days to fill for positions. Positions can be placed on and off hold multiple times. There are two tables as follows: Table--Positions: PositionID DateOpen (date/time) DateFilled (date/time)...

Part and Inventory Search

Back
Top