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 derfloh 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. TomiCobi

    How can I trim data after numeric data is converted to text?

    Hi to all, I have this formula in one of the crystal reports that I am asked to fix. I just cannot make the result correct. The formula is: IF (table1.field1) = "ConferenceName/SessionName" THEN (table1.field1) + " - " + " # of Attendees: " + totext((table2.field1)) ELSE...
  2. TomiCobi

    Formula for using wild card input in the parameter

    Thank you all (kray, Ian and lbass) for your quick solutions. I do appreciate it. I tried all your suggestions and all worked just perfect. Thank you once more for the learning lessons.
  3. TomiCobi

    Formula for using wild card input in the parameter

    I am asked to run a report that will show changes in member's category (previous to current). The objective is for user of the report to be able to enter even a wild character in the parameter set. I have the previous and current category as parameters. Below is what I have in my Select Expert...
  4. TomiCobi

    Getting specific records in a table

    Thank you for your prompt responses. To further clarify, the details of the report would like this on print out: PSI_Name ID# Full_Name Member_Type Member_Category Email Expected_YR_of_Grad Where PSI_Name = is a record in Gen_Tables.TABLE_NAME ID#, Full_Name, Member_Type...
  5. TomiCobi

    Getting specific records in a table

    I am a new CR user. I am using CR9. I am being asked to do a report that requires me to get specific records in a table and use it as a paramater. The table fields and sample data in each field are: TABLE_NAME <PROVINCE, PSI_NAME, etc.>, CODE <NU, ACC, etc.>, SUBSTITUTE, UPPER CODE & DESCRIPTION...

Part and Inventory Search

Back
Top