Search results for query: *

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?

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?

Ido, Around 50 altogether, but I believe a 5-concurrent license will suffice for now. I am currently in the process of importing the WCS logs from the past 2 years to analyze how many users are hitting the server. Paul

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

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

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

A summarized version of this problem is this: Through DTS, when transforming data from a text file to a sql table, how do I convert null values to blank or empty values.

I'm not sure how you open or query your tables, but once you do, here is the sql I use to do something very similar, which works well: INSERT INTO <destination_table_name> SELECT * FROM <source_table_name> WHERE <source_table_name>.fieldname not in(select <destination_table_name>.fieldname...

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 &quot;empty&quot; fields over without getting the following error: Insert error, column 2('tcit',DBTYPE_STR),status 10: Integrity violation...

Max and Al, Thanks for all your help, I am now able to bring over the dates. One more issue, however. In the text file, sometimes the date value is 00000000, and the DateSerial function is bringing them over as 11/30/99. Any idea why, or how to retain the 0 value? Paul Prevost

OK, Here is what I've found out so far. The Cdate function seems to work when the text is in the following format(s): 09/24/2001 or 09-24-2001, but does not work when it just straight text 09242001 My next question becomes: In the transformation script, how do I convert the string...

Actually, acting on your suggestion, I just cut the text file down to 20-30 rows (from a few thousand), and the package executed successfully, so it looks like it may be a problem with the data at some point in the file. I will research more, thanks for your help!

No, No matter what I try, I receive the same error. (Type Mismatch: 'CDATE') From my understanding, the CDATE function should take a text string from a source file and convert it into the proper OLE DB date format. The following is true for my scenario: 1. The source date is text and 8...

Thanks Al, I read the details in both articles that refer to datatype conversions and the CDate function, but am still not successful bringing over the dates. Paul Prevost

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

Thanks for the confirmation. Paul Prevost

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

Ken, After clicking everywhere, I believe you are correct. I have, however, found a workaround. The database I am using to report from is my own, so I just did this: 1. Exported the summarized values to a new table in my database on SQL Server, which I can refresh periodically...

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

Ken, Thank you very much. This app is simple, and it works! It will definitely satisfy what we need to do until we uprade to CR8.5 or above sometime in the future. Do you know the purchase price for this? I have requested a quote. Thanks again!!