Recent content by prevost999

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