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

    XL 2K3 External Data Query, Cell Formatting changes on some desktops

    I've written SQL for an external data query and return the data to the worksheet. The external query pulls data from an IBM DB2 database. I've formatted the worksheet including formatting cells to render acceptable standard MS XL date formating rather than the yyyy-mm-dd 00:00:00.000000...
  2. brookwood

    CR XI export to Excel w/ Autofilter in Detail

    OK, I'm stumped. How do you export to Excel and have the detail section autofilter without having to turn it on in Excel? Using CR XI and MS Excel 2003 Thanks.
  3. brookwood

    Pulling Min and Max Dates only

    I have a situation in my db where I get multiple datetime stamps for parameters that I have identified as the start and stop times. The frontend tool permits the users to mark activities 'done' then reopen and mark 'done' again...and again....and again. Anywho...I need to get the minimum of...
  4. brookwood

    Left Outer Join Percent Formula

    I'm having some trouble with my left outer join percent formula(got too full at lunch I suspect). Anyway, I've created a left outer join to bring back all the results of one table,and the results of the right table where the condition is met. So, here's my problem. I'm trying to show the...
  5. brookwood

    Help with Percent formula on condition

    I'm new to CR XI, and I'm sure this is quite simple....but, here's my problem. I need to get the percent of Service Requests where the request type is a produciton correction. So here's what I've got so far... count({V_BAR_SR.BAR_ID})%count({V_BAR_SR.BAR_TYPE}) I need the solution to WHERE...

Part and Inventory Search

Back
Top