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: *

  • Users: knerve1
  • Content: Threads
  • Order by date
  1. knerve1

    Trimming varchar(255)

    Anyone, What would be the easiest statement to trim this? Filler Order ID: <10190968MMDSCR> Filler Facility ID: <RAD> I only want what is in between the < > to then compare to another column. Thank you,
  2. knerve1

    Can Access a database on one client but not another

    Anyone, One PC has SQL Server Enterprise Manager MMC 1.2 version 5.0 sp.4 Windows 2000. I can access all databases. The other PC has Enterprise Manager 8.0 and MMC 2.0 v5.1 sp2.0 on a windows XP machine. Cannot access all databases. Has anyone ever encountered a problem like...
  3. knerve1

    Conditional suppress not working

    I have an 8.5 report that has two groups. On group is split into 1a and 1b. I would like to suppress 1b if the details section is suppressed. The formulas on Group 1b are New page after "not onlastrecord" , new page before is checked, and Keep together is checked. I have tried using a...
  4. knerve1

    desktop shortcuts

    I have an application that sits on a test as well as a production server. On the win2k client in order to change from test to production, I must go into the registry and modify a Server Profile setting. I go into the setting and remove a few alpha characters to access test and add them back to...
  5. knerve1

    Record selection question

    Hello, Using CR 9.0, I have a record selection that looks like this: ({a.COLLECTED} in {?Begin Date} to {?End Date}) and (("ALL" IN {?Test Code})OR ({a.TESTCODE} = {?Test Code})) and {a.PS} in [" ", "210", "91840"] and (("All" in {?Site}) OR {a.LS} = {?Site}) for the a.PS in [" ", "100"...
  6. knerve1

    Multiple Parameter Values

    I am using CR9.0. I have a parameter field that has multiple locations set as default values. In the report header I want to display the parameter values input at runtime. I have put the parameter field into the report header but it only lists the First value input. How do I see multiple...
  7. knerve1

    Modification of Show SQL Query CR9.0

    How do you modify the Sql in the CR9.0 "Show Sql Query" text box. In earlier versions, you could modify the query directly in this box. How do you do it in 9.0. From Database>Show Sql Query. Thanks for any help.
  8. knerve1

    running total suppression

    Anyone, I think this is simple but I cannot figure it out. I have a running total that I only want the last record to display. How can suppress an unknown amount of records before the last record is displayed? Any help is appreciated.

Part and Inventory Search

Back
Top