Search results for query: *

I am receiving "run-tune error 3704 operation is not allowed when the object is codes" error in Excel. The debug takes me to the first line of the following code (comes after the SQL code): If Not rsData.EOF Then ' Add headers to the worksheet. With ThisWorkbook.Sheets("Data...

I need to display, in group footer 1, loans from the detail section. In the detail section I can have more than one loan. Therefore, I set up an array to capture the loans. The problem I am having is that I need to reset the array for each group because without doing so I am going over the...

using the statement charindex(PHIST.LOAN, p.loan_name)} and given phist.loan = 111111 p.loan_name = property name 111111 would return 15 but phist.loan = 222222 p.loan_name = property name 222222 (other text) would return 0 even though the loan is within the loan_name I cannot figure...

Using Crystal 8.5 Any idea why using the statement {fn LOCATE(PHIST."LOAN", p.loan_name)} and given phist.loan = 111111 p.loan_name = property name 111111 would return 15 but phist.loan = 222222 p.loan_name = property name 222222 (other text) would return 0 - the loan is within the...

I have a SQL Expression that was not returning the result that I had expected so I broke it (the expression) down to test the locate function. When I did the test it was returning 0 for all values and that, I know for sure, is not correct. Anyone have any ideas what I may be doing wrong? FYI...

I do not if anyone can shed light on this, but we have a stored procedure that runs fine, pershaps about 2 minutes, on our production server. However, when that same stored procedure is run on a different server, one that is to become our production server, the stored procedure seems to just...

We are going through a upgrade to a new system. The new system is on a different server then our current production environment. We have several, hundereds in fact, so as you can imagine we really do not want to go through every report doing a Set Location. Is there a way to set up the ODBC...

I think what I need is pretty simple, but I am not sure of the best way to do what I need. Before I begin, I am using Crystal 8.5. Say I am displaying the following, Group 1 is on Type and Group 2 is on Name: Rate Name Store Type 8.5 Hats Barney's Father...

I am getting the following error after adding in the subquery. The following are views nyl_property_opstatmt nyl_property_appr nyl_loanxref select distinct fl.loan_xref,sum(distinct isnull(po.noi,0)), isnull((sum(distinct po.noi) * max(isnull(ex.nyl_part_per,100)))/100,0)...

I have been playing around for a while with the following select dateadd(year,-1,(dateadd(day, -(datepart(day,somedate-1)), (dateadd(day,datediff(day,0,somedate),0))))) which returns the last day of the previous month. I need to return the previous year. For example if somedate is...

I am doing a simple SQL expression and nothing is returning though it should. Here is an example of the expression. {fn YEAR(ACCRHIST."ACCOUNTING_DATE")} The ACCRHIST."ACCOUNTING_DATE" field returns 6/30/2005, however, the SQL expression does not return anything. Any ideas why not? Thanks

Version: Crystal 8.5 Say that I have the following in the details section (D) Item No. Bank D 1 BNY D 1 CNY D 2 CCA D 5 KSD Then I group on Bank and in the group footer I want the following GF BNY/CNY 1 GF CCA 2 GF KSD 5 Would the best way to do...

Version: Crystal 8.5 I have created a Crystal Report which is using the UNION clause, however, only the first query is returning data. The second query is using some different fields than the first and the selection criteria is slighty different. I do, however, have the same number of columns...

I am using Crystal 8.5. The amount of data returned in one of my subreports is causing the GF1 to be on a page by itself with a lot of blank area. Furthermore, since the subrepor is in the details section it is causing various other problems. The problem is if I change to format so that the...

I am using Crystal 8.5 and I have a cross tab which displays negative values. The values as they stand allow the grand total to be correct. What the user wants, however, is for certain, but not all of the negative values to appear as positives. I have been playing around with the reverse...

I have a report where I am using a union all. The first where clause is using the parameter from the Record Selection Criteria. I need the where clause after the union all statement to also use that parameter. Is that possible? So far the report only works if I hard code the parameter value...

I have a report in which I am doing a right outer join to a table. The set up is like so TableA <-- TableB <-- TableC -- TableD where <--- means right outer join and --- means equal join. TableA and TableC are history tables, therefore, they have as of dates in each. TableA also has a...

I have two tables with data that looks something like the following: LOAN_NO AMOUNT1 AMOUNT2 200 152.60 4569.00 203 1652.00 7896.00 205 2589.36 159.62 LOAN_NO EMPLOYEE POSITION START_DATE END_DATE 200 Chris J. Accountant 2001-02-11 NULL 200 Ed P. Analyst 1998-03-04 NULL 203...

I have seen the problem where weighted averages have returned as blank or zero when they should not. In that instance I had our IT group apply the patch to my machine. I do not seem to be having any further problems, however, another person on another floor was having the problem with a report...

If I had a user enter a transaction and I wanted to see what tables were touched by the transation, what table or system object could I use to determine that? I do not thing sysobjects would be correct. Thanks in advance for your help. mc