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 TouchToneTommy 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. ghostofelmo

    Real simple question- numbers

    CR8 I have fields that I am trying to summarize but CR isnt recognizing the numbers. How do I get it to recognize the numbers as numbers? {P Folder 1.Sq Ft}+{P Folder 2.Sq Ft}+{P Folder 3.Sq Ft}+{P Folder 4.Sq Ft}+{P Folder 5.Sq Ft}
  2. ghostofelmo

    Details suppression question

    Using CR 8 Can you suppress in the details section using 2 qualifiers? I am writing the report off of 6 tables, one is a master and there are five tables that link directly to it. I need to indicate wether one of the buttons on each of the five areclicked on and the other clicked off to pull...
  3. ghostofelmo

    Sorting

    I am sorting my reports by priority. We are using a range of 1-10, how do I get the 10 to print after the 9, instead of the 1?
  4. ghostofelmo

    Summarizing multiple if then statements

    I am using the following formula If {P Folder 1.Material} = "Stone" then {P Folder 1.$} else 0 + If {P Folder 2.Material} = "Stone" then {P Folder 2.$} else 0+ If {P Folder 3.Material} = "Stone" then {P Folder 3.$} else 0+ If {P Folder 4.Material} = "Stone" then {P Folder 4.$} else 0+ If {P...
  5. ghostofelmo

    Can i use If and statements in CR

    I am using the following formula to evaluate the total number of rooms in a job, using Crystal 8. The formula editor sees nothing wrong with the formula, but yet it returns no results. Any thoughts? IF {P Folder 1.Room 1 Active} = True and {P Folder 2.Room 2 Active} = False then "1" else IF {P...
  6. ghostofelmo

    Horizontal results question

    I am a novice here. I have built a report giving us all orders where the product either had a negative inventory classified as stock or had a status of backorder and a positive quantity. Now I need to list all open picking ticket numbers regardless of status, listed horizontally on same...
  7. ghostofelmo

    Upgrading CR8 to 11

    Crystal Reports has been thrown into my lap and I have been designing reports by looking at existing reports. We currently are using CR8 with Pervasive 2000 accessing Macola. I have downloaded CR11 trial and done all of the datasource updates, seen the tables and pervasive launches yet I see...

Part and Inventory Search

Back
Top