Search results for query: *

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

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

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

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

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

I need to create a column that identifies which week the data fell into. For example: The top row is a yield % and showing count by week. Week 100 99-92 91-85 09-07-2003 - 09-13-2003 13 14 5 09-14-2003 - 09-20-2003 12 10 8...

Sweeeet....it works [afro]

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

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!

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

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

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

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

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

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

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!

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

I have the following sub select in my query (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...

I have the following case statement getting the following error Server: Msg 156, Level 15, State 1, Line 17 Incorrect syntax near the keyword 'else'. Any ideas? Thanks Much case when detail.rec_stus_id = '1' then case when bg.bus_grp_id = 1 and demand.mfg_fclt_code in...

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