Output to Microsoft SQL Server (CR 8.5) 
Author Message
 Output to Microsoft SQL Server (CR 8.5)

Hi there

I'm trying to make CR 8.5 output data to Microsoft SQL server 7.0

That task is fairly simple. However it seems that CR cannot add
records to an existing table. It will always create a new table, and
fails if I apply a name of an existing table.

So my question is:

How can I add data to an existing table using Crystal Reports

Thanks in advance

Bent



Sat, 21 Feb 2004 19:29:27 GMT  
 Output to Microsoft SQL Server (CR 8.5)
Hi Bent,

A fundamental policy of Crystal has always been to not alter data.  So
it is not possible for Crystal to add data to an existing table at all.
 When it exports, it will do a Create Table instead of an Insert or Update.

The best work around would be to export the report to a table then have
SQL Server do an Insert from the Crystal table to your existing one.

--
--
Sincerely,
Brian Dong

To reply, remove nospam from the address.

Quote:

>Hi there

>I'm trying to make CR 8.5 output data to Microsoft SQL server 7.0

>That task is fairly simple. However it seems that CR cannot add
>records to an existing table. It will always create a new table, and
>fails if I apply a name of an existing table.

>So my question is:

>How can I add data to an existing table using Crystal Reports

>Thanks in advance

>Bent



Sun, 22 Feb 2004 12:32:16 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. SQL Server 2000 + CR 8.5

2. VB6 and CR 8.5 Server has not yet been opened

3. Page Server is crashing (NT 4, CR 8.5)

4. CR 8.5 and SQL connection

5. DNS'less connection CR 8.5 to SQL 7.0 - 2000

6. Passing SQL Query in CR 8.5 Viewer

7. CR 8.5 and CR from VS.Net package

8. Decimal Place problem after Upgrading from CR 6 to CR 8.5

9. CR 8 and CR 8.5

10. Using a dll that referenced CR 8.5 files on a machine that has CR 8.0

11. Crystal Report 8.5 and connecting to SQL Server?

12. string truncation with crystal reports 8.5 and sql server 7

 

 
Powered by phpBB® Forum Software