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 Westi 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. JasonDove

    Entering nothing or blank values for a parameter

    You need to set default date values for the parameters, then make their use conditional with an if statement. Something like: IF {?ParameterDate} = #1066,01,01# THEN TRUE ELSE {Database.DateFieldYouCareAbout} > {?ParameterDate}; Assuming you are using it for record selection and the ELSE is...
  2. JasonDove

    Entering nothing or blank values for a parameter

    If you're using Crystal Reports 2008, select the "Optional Prompt" and use the HasValue formula function. If not, then it takes some formula coding to work around it. "Crystal Reports Formulas Explained" is the most advanced book on the market. Currently available with a free 70 page Crystal...
  3. JasonDove

    calculate the average for elapsed times

    Unless I am missing something: right click on the formula field (once it is added to the report) and select the Summary option, then "average". (NB: table linking which causes duplicate detail rows can cause this to give false results, so ensure the "Distinct Records" option is checked.)...
  4. JasonDove

    Trouble with Grand Total

    Running totals are the answer. For the Grand Total results do not "reset". "Crystal Reports Formulas Explained" is the most advanced book on the market. Currently available with a free 70 page Crystal Reports XI tutorial: http://www.scry-business-intelligence.com/products/bookoffer.php

Part and Inventory Search

Back
Top