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

    run-tune error 3704 operation is not allowed when the object is codes: I don't think so.

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

    Resetting array and error with array limit

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

    charindex incorrect

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

    SQL Expression: Locate function works for some not for all

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

    SQL Expression: locate funtion returning incorrect result

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

    Any idea on why store procedure is so slow

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

    Set Location for every report, do we have to?

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

    Displaying corresponding value for a maximum record

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

    Internal SQL Server error - why?

    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)...
  10. morechocolate

    Calculating prior year

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

    SQL expression not returning data

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

    Is an Array the best thing?

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

    Union only returning records from first query

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

    Object causing blank pages and other problems

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

    Conditionally format negatives in cross tab

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

    UNION ALL with parameter field in WHERE clause

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

    Right outer Join issue

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

    Easy join problem

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

    Weighted Average Returning 0

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

    Verifying tables updated

    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

Part and Inventory Search

Back
Top