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. strom99

    Like Statement

    I have the following: = If Match(<Keyword> ,"CC:BEF") Then "BEF" Else If Match(<Keyword> ,"CC:HANDHELD") Then "HANDHELD" Else If Match(<Keyword> ,"CC:DBEF") Then "DBEF" Else If Match(<Keyword> ,"CC:ESR/DESR/DRPF") Then "ESR/DESR/DRPF" Using BO 5.1.7 This variable works if the "CC:BEF" etc is...
  2. strom99

    Max Date Formula

    I have a report that shows a number of loads for a specific product. These loads tell what is happening as far as the qty of the product. The last load produced with the latest date tells me what the current inventory of that item is. I need a formula that will allow me to display this, ie...
  3. strom99

    Min and Max Records

    I have the following data: Tool Nbr Run Nbr Roll Nbr Datetime Yield There are multiple Runs and Rolls per tool number, I need to display only the Min date and max date associated with each tool number. How could I accomplish this? Data is from SQL Server 2000, BO 5.1.7 Thanks
  4. strom99

    Retrieve Database Name

    Is it possible to retrieve the name of my database and/or server to display in my query? Thanks Much!!
  5. strom99

    Convert CHAR to DATE

    I have the following field process_datetime which looks like this...(20020617094637) it is a CHAR field, I need to convert this to a date field that looks like '2002-06-17' or '06/17/2002'. I've tried both CONVERT and CAST with no luck in getting it to work. Any ideas? Thanks much...
  6. strom99

    Identify Weeks

    ...between 71 and 77 then 1 else 0 end) as '77-71', sum(case when mvi_tool_yield < 71 then 1 else 0 end) as '71-0' from (select v1.*, v2.mvi_tool_yield, v2.estimated_yield as mvi_estimated_yield, left(convert(varchar,v1.start_create_datetime,120),7) as test_date...
  7. strom99

    Data Different between Report and SP

    Sweeeet....it works [afro]
  8. strom99

    Data Different between Report and SP

    I have a report that I displaying the max number of uses for specific tools. I am using a stored procedure (SQLServer 2000) and it returns the data correctly, when I call the stored procedure through BO, the data comes in fine when viewing throught the data manager or exporting to excel, but...
  9. strom99

    Week Formula

    Hi Have the following field cut_date and I need to include another field that will tell me which week (date) it occured. So if it the cut_date was 09/17/03 I would need another column to tell me that it occured during the week of 09/15/03. Thanks much!
  10. strom99

    Date Sorting

    I have the following field <Transaction_Date> which looks like 08/06/2003. I created a variable in my report called varTransMonth =FormatDate(<Transaction Date> ,&quot;Mmm yyyy&quot;) When I use this in a cross tab the dates do not sort properly? They appear to be in alphabetical order, I...
  11. strom99

    Input box

    I have the following piece of code which allows a user to select 0,30,60 or 90 day order horizon days, I need to change this to a text box where they can enter in any number, I am very new to this and have no clue how to handle this...any advice would be appreciated. <td...
  12. strom99

    Excel - Datedif formula

    I have the following formula =IF(D2=&quot;ACTIVE&quot;,DATEDIF(Z2,P2,&quot;D&quot;)) Checks to see whether project is Active and then determines number of days it has been active. Cell Z2 contains =Today() Cell P2 contains Project Start Date I am getting the following error message: #NUM...
  13. strom99

    Date Field Format

    I have the following field I am displaying in an HTML page 2003-04-15 14:48:18.25 How can I change my SQL to only show the 2003-04-15 or 04-15-2003 or April 15 2003 Thanks SQL Server 2000
  14. strom99

    Java PDF Generation

    Does anyone know of a good (cheap/free) tool that will allow us to create PDF reports dynamically? Creating web app using Websphere and need to create 4 very basic reports and need to create a PDF file that will look like a daily pass / permit. Or are there any good code examples? Database is...
  15. strom99

    Date Range

    WHERE detail.rqst_del_date >= ''01/01/'' + datename(year,getdate()) and detail.rqst_del_date <= dateadd(month, 8, getdate()) I have the above in my where clause, but I need to make a change in order to go back 6 months from the first of this month, so I would include all records from July 1...
  16. strom99

    Extract Product Weight from description

    I have the following field 55 gal container (750 lb, 341 kg) Holder (11 lb, 5kg) I need to be able to extract the 750 lb, 341 kg in order to sort on this field. Crystal 8.5 Thanks!
  17. strom99

    Different Result Sets in Stored Procedure

    I have a stored procedure that is dynamically built and returns 13222 rows when executed as exec pr_rpt_das014 1, 0 When I run the SQL by itself I get 10249 rows, how can these be different? Any ideas? SQLServer2000 Thanks Much
  18. strom99

    Dynamic Column Name

    ...(select sum(ord_qty) from t_acct_dmd_detl where (acct_dmd_id = ad.acct_dmd_id and rec_stus_id in (3, 4)) and (datePart(month, dateAdd(day, (-1 * (mfgtran.trnt_days + stocktran.trnt_days)), rqst_del_date))= datePart(month, dateAdd(month, -7, @TODAYSDATE)) and datePart(year, dateAdd(day, (-1...
  19. strom99

    Nested Case Help

    ...= 1 and demand.mfg_fclt_code in ('cg','ci','ac') then case when (m.invt_cost = 0 or m.invt_cost is null) then (gs.sllr_figqy_conv_fc * detail.shpd_qty) else (gs.sllr_figqy_conv_fc * detail.shpd_qty) * (m.invt_cost) end end end else case when...
  20. strom99

    Page Server Message

    Is it possible to modify the error message that appears when there are no more licenses available? I would like the user to see a more readable message that tells them to try again later. Using CR8.0 and WCS

Part and Inventory Search

Back
Top