Can Crystal write report results to sql table?

[delsolsf]

Hi,

I have a complex Crystal report 9 financial report with rows and columns of numbers and multiple groupings.

I'd like to know if I can take the group totals that crystal produces and write those totals values to a SQL table to use later?

I've heard that crystal can create work files, but I don't know how nor can I find any info on it.

Any help would be appreciated.

Regards,
DelsolSF@aol.com

 

[synapsevampire]

There are different approaches to accomplishing this.

You can write SQL and use the Add Command button to accomplish this, or you might write a stored procedure to accomplish this.

You can even export data to a new table after the report has been run.

Here's the CD whitepaper for updating a table:

http://support.crystaldecisions.com/library/kbase/articles/c2011921.asp

-k