
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