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

    Help Determining Minimum and Maximum Values…With Exceptions

    I have a set of holes and within each hole there are sections. (Picture a cardboard tube divided into sections and each section has a number of units in it.) Each section has a quantity associated with it. I need to determine the minimum and maximum quantity for these sections. The...
  2. omcompany

    Help Determining Fields within a Range and Displaying the Results

    My apologies for the title, it was a hard one to summarize. I am using CR 2008. Here is an example of my data and what I am trying to accomplish. ({table.Weight}, {table.Time}, {table.X}, {table.Y}, {table.TimeDiff}) (100, 0 , A , 1 , 8) (100, 25 , A...
  3. omcompany

    Help Formatting Parameter Date Range in a Concatenated Formula

    I am trying to bring in the date range parameters for a report. I believe I could simply use text boxes and the {?BeginDate} and {?EndDate} fields to accomplish this but I was wanting to concatenate the two fields as such, {?BeginDate}& " to " &{?EndDate}. My issue is the date format is set so...
  4. omcompany

    Help Counting Matching Values Across Multiple Fields

    I need to show the count of Datecode_1 and Datecode_2 as well as list the different Datecode(s). I am using Crystal 11 connected to an Access db. Here is an example of the data; Line Datecode_1 Datecode_2 1 abc xyz 2 xyz abc 3 abc abc 4 xyz xyz 5 xyz !@# The results...
  5. omcompany

    Help Summarizing Multiple Fields Plus a GrandTotal

    I am trying to get the sum of three number fields. Once that has been accomplished I need to have a grand total of those sums. I am using Crystal 11 connected to an Access db. To this point I am able to get everything I need by placing the fields in the Details section. All of the data comes...
  6. omcompany

    How to get a Minimum Result from a Formula?

    I am creating a report where I have to get the difference between two numbers (Number - Next(Number)) and then show the minimum result. I am using Crystal 11 connecting to sql database. I get all the records from a single Database Field called (as an example) Hole.Time. The field is sorted by...

Part and Inventory Search

Back
Top