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!

  • Congratulations bkrike 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: *

  • Users: prevost999
  • Content: Threads
  • Order by date
  1. prevost999

    Can't re-position the TOTAL data label in a stacked bar chart

    In stacked bar charts, I sometimes re-position the data-labels by clicking and dragging them. In V8 all is well. In version 9, I can re-position the totals for the grouping categories, but I cannot re-position the TOTAL, which is on top of the bar. Any idea what's going on?
  2. prevost999

    Can't re-position the TOTAL data label in a stacked bar chart

    In stacked bar charts, I sometimes re-position the data-labels by clicking and dragging them. In V8 all is well. In version 9, I can re-position the totals for the grouping categories, but I cannot re-position the TOTAL, which is on top of the bar. Any idea what's going on?
  3. prevost999

    Moving from Crystal 8.0 to 9.0

    Ok, let me be long-winded. We are a mid-size organization where I am the sole report designer. CURRENT ARCHITECTURE: Crystal Version: 8.0 Deployment: Reports are accessed on-demand via a local intranet using the 8.0 Web Component Server in conjunction with locally installed...
  4. prevost999

    Moving from Crystal 8.0 to 9.0

    Ok, let me be long-winded. We are a mid-size organization where I am the sole report designer. CURRENT ARCHITECTURE: Crystal Version: 8.0 Deployment: Reports are accessed on-demand via a local intranet using the 8.0 Web Component Server in conjunction with locally installed...
  5. prevost999

    Web Component Server 8.0 updates?

    Does anyone know if any hot fixes or updates exist for the Crystal Reports Web Component Server version 8.0? On the support site I only found hot fixes for Crystal Enterprise 8.0 Web Component Server. Are they the same? The reason is with some of my more complex reports, especially reports...
  6. prevost999

    DTS Transformation-Binging over empty fields from a text file

    I am attempting, through a DTS transformation, to bring delimited data from a text file into a SQL Server database. My problem is that I cannot bring "empty" fields over without getting the following error: Insert error, column 2('tcit',DBTYPE_STR),status 10: Integrity violation...
  7. prevost999

    DTS Transformation-CDATE function

    I am attempting, through DTS, to bring delimited data from a text file into a SQL Server database. I am having a problem bringing over the dates(which appear in the source file as mmddyyyy(i.e. 092420001), and have tried the following syntax in an ActiveX Script Transformation: Function...
  8. prevost999

    Job execution - setting a time limit.

    I have a job that runs for about 1.5 hrs and usually completes successfully. Occasionaly, however, it fails, and sometimes, it just hangs and keeps executing endlessly until I stop it manually. My question is: Is there any way to set a time limit on how long a job can run, and then it will...
  9. prevost999

    Can't use formula field in chart

    I have a formula field I want to use as the value in a line chart, but when I try to use it the values come up as all zeros. The formula field is in a group footer and is a division calculation based on 2 running totals, also in the same group footer. Formula Field =...
  10. prevost999

    Automated Distribution - What works best with CR8?

    I am using CR8 with the Web Component Server to currently distribute on-demand reports. It works fine. My problem is to find a way to shedule reports so they automatically execute and distribute(file,e-mail,printer,etc.) on a recurring basis. I have downloaded and used the distribution...
  11. prevost999

    Automated Distribution - What works best with CR8?

    I am using CR8 with the Web Component Server to currently distribute on-demand reports. It works fine. My problem is to find a way to shedule reports so they automatically execute and distribute(file,e-mail,printer,etc.) on a recurring basis. I have downloaded and used the distribution...
  12. prevost999

    Multiple table aliases performance problem

    I am attempting to write a stored procedure via SQL: The problem is this: I am using 12 table aliases(instances) of the same table to get my results, and it is really slowing down the processing time of the query. Details: In the table I am using there is a field called Item and a second...
  13. prevost999

    Sorting on Running Totals

    How do you sort on a running total in CR8? * I can't create a Summary Field and use Top N functionality, because the running total is based on a formula which only totals certain records. * From what I have read, the only way to do this is to incorporate the running total in the SQL query...
  14. prevost999

    Suppressing multiple group headers.

    I have created 6 custom group headers based on user-defined date ranges.(formula fields) The grouping is working fine, it's just that for every header, all 6 Group Names are showing up. How do I suppress all non-relevant headers for each individual group? Thanks in advance.
  15. prevost999

    Left Outer Join Not Working Correctly

    I have a report that uses 6 tables, and has 1 left outer join. The report returns records as if it were an equal join, and is not resulting in all desired records. I am using CR 8 and SQL Server via ODBC. Any help is appreciated. Thank you. The statment is: SELECT...
  16. prevost999

    Some records in sub-report not showing up in main report.

    I have 1 main report linked with 1 sub-report, with a field called Item Number. Scenario: For 1 group in the main report, there are 10 records, each with a unique item number. In the subreport there are 12 records, each with unique item numbers, in the same group. The problem is, when I...
  17. prevost999

    Using a Running Total in the Group Seleciton Formula

    I am trying to use a Running Total in the Group Selection Formula, but get the error, "This formula cannot be used because it must be evaluated later". I tried using the EvaluateAfter() function, but it resulted in no records retrieved. Any advice?
  18. prevost999

    How do I execute multiple DTS packages as a single, scheduled job?

    I have created multiple DTS packages and would like to know how I can execute them all as one scheduled job.

Part and Inventory Search

Back
Top