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

    Formula field giving unexpected results

    I have defined a new formula field called Category, that can have one of three values based on the value of three different database fields. - If {field1}="x" then "Legacy" else If {field2}="x" then "Vibe&quot...
  2. QPRphil

    Calculating previous business day

    Hi, I am using Crystal 8.5 and want to run a daily report listing entries from a Remedy database that were created on the previous working day (Monday - Friday). I have created a formula field to calculate the previous day [DateAdd ("d",-1,CurrentDate )], but if this is a Saturday or...
  3. QPRphil

    Linking files in my report

    I have a report in which I have one large file, something like 250,000 records, of which I am selecting 3,000, which I wish to link to a much bigger file, a couple of million records in all, of which I suspect I will be selecting about 20 for each record selected from the first file. I actually...
  4. QPRphil

    Extracting data from memo fields

    Hi, I am writing my first ever Crystal Reports over a Remedy database, my back ground is AS400. One of the fields I want to access is defined as type 'memo'; not really sure what this means in database terms. The entries in this field are a series of department names and date/time stamps. I want...

Part and Inventory Search

Back
Top