Search results for query: *

Hi, I cannot run the following query in Query Analyzer, I get an error: SELECT NAME_LAST, OPT_ID,OPT_NUM FROM OPTIONEE WHERE OPT_ID = '999999999'AND UPPER(NAME_LAST) = 'O'BRIEN'; My problem is that the name O'BRIEN contains a single quote. How can I work around this? Using SQL Server 2000...

Hi, In cell A6 I have this AU9602 Dec 15, 1995 What you cannot see in is that between the "2" and the "D" is the character for carriage return char(13); it looks like a square. Ok in cell B6 I have this formula to get the date out of A6: =MID(A6,FIND(CHAR(13),A6,1)+1,12) So the value in B6...

How do I get a vlookup to return 0 (zero) when the value "#N/A" is returned? My formula is =VLOOKUP(S8,$C$8:$N$3448,12,FALSE) which returns a currency value if there is a match. When I do not get a match I would like to have the value zero returned. Thanks, Mike

Hi, Using Excel 9.0. I have 2 columns of cells about 35,000 rows each. The data in the cells is text. I need to compare the columns to each other. I need to determine values in column A that are not in column B and vice versa. I was using vlookup and match to do this and then auto filter...

Hi, I am using Crystal Reports 7. I have a report that needs to be grouped on price ranges. However the ranges are not determined until the data is returned to the report. The grouping occurs as follows. First find the lowest price of the record set returned and multiply it by 1.5. This is...

HI, I am using crystal reports version 7. I need to know methods of comparing two crystal reports. Here is my situation. I was given the task of adding additional functionality to a report used by my company in their production environment. I have added the given functionality. However...

Hi, Crystal 7, MS SQL Server 2000. I log on with SA password. I am responsible for creating a crystal report based on a stored procedure. The stored procedure returns a runtime ID (integer) as an out parameter. There are no in parameters. So the stored procedure is called from the main...

Hi Crystal Reports Version 7 MS SQL Server I was having problems with my query not returning correct data because the way my option price field was stored in my datebase(as floats). Storing values as floats can cause the values to differ slightly for the same value stored. NOTE: Option price...

Hi have the following two queries. QUERY 1 SELECT count(*) FROM OUTST_VIEW outst_view, CUS_WEIGHTED_FAIRVALUE CUS_WEIGHTED_FAIRVALUE WHERE outst_view.NUF_GRANT_NUMBER = CUS_WEIGHTED_FAIRVALUE.FK_GRANT_NUMBER(+) ORDER BY outst_view.GRANT_TYPE_BASE ASC...

Hi, I have the following formula in the Records Selection in a subreport. I use version 7 of Crystal. ToText({crecap_view.NUF_GRANT_TYPE},0,"","") in {?Pm-@Make grant type paramater a text string for passing to the subreports}; NUF_GRANT_TYPE is type number and can only...

Hi, I need to create a view that calculates weighted average from another table. The fields I am using from the other table are GRANT_NUM Number OPTS_GRNTD Number OPTS_VESTED Number FAIR_VALUE Number I need to calculate the weighted average FAIR_VALUE for each GRANT_NUM or set of...

Hi, Version 7 Crystal. I am writing a report and using the ROUND function. I was having a problem when the rounded value should have equaled the end of a range. So I create the following formula and place it in my report and it returns False. round(10,4) = 10; Has anyone seen this?

Hi, Crystal report version 7.0 I am creating a report that will be distributed to employees. Not all employees in the database will have the data criteria and thus not show up on the report. The report will pull one set of data for the employee in the main report and one set of data in a...

Hi, I have created a view which calls a function (relevant line of code below): optionsVested(grnt.grant_num, canc.CANC_DT, DECODE(grnt.sar_flag,2,1,0)) VESTED - Returns a number The canc.CANC_DT field is a date field. I need to pass the day before. So if CANC_DT is 01/01/02, I need to pass...

Hi, Does anyone know of any UFLs for the natural logarithm and square root functions for crystal reports version 7. Thank you

Hi, Crystal Reports Version 7. I have chosen to print the group header on each new page.. I do not want to keep the group together. I run into the following problem. My group header sometimes prints at the bottom of the page without any of the records in the group printing below it (there is...

I am working on a proposal for a custom applicaton for a client that involves the uses of triggers. We will allow the user to enable/disable the triggers via a VB application. We also want to display the status of each trigger via the VB application: What SQL statement can we run to obtain...

Hi, Crystal 7. The application provides a free flow comments section for each employee. These comments are stored in 256 byte records in the database. So each employees comments can be made up of one or more of the 256 byte records. Once a record is filled another record is started, so for...

Hi, Crystal 7. I would like this text "Deferred Comp Plan" to appear in quotes. How do I do this in crystal.

Hi, Using Crystal 7. Is there a way to get multiple records returned from the database to print across? Here are the specifics. The report will have 2 tables, EMPLOYEE and GRANTS. Each employee can have zero to many grants (of stock options). For this problem, if it helps, we can limit the...