possible to UPDATE table from report

[MSBrady]

Oy!

CR 10 for Solomon
SQL Server 2005

I was wondering if it's possible to have Crystal update a table and turn a flag on based on what was requested in the report by the user. I have a pre-process SPROC that fires when the report is called from Solomon. This SPROC dumps a bunch of records into a work table so the report has something to pull. There is a date range parameter that the user selects and based on that range the subset of records returned from the work table need to become a permanent part of the table, all others need to be cleared. There is a post-process that can run but it doesn't have access to what was returned in the report.

thanks

 

[TheBlondOne]

You can do an update on a table from within Crystal Reports but be careful with it. If you search on Business Objects on the Knowledge base and then search for Table of Contents this might help. The table of contents FAQ shows you how to update a table from Crystal and which sections to put the SQL statement in.

I'm sure from there you will be able to manipulate the code to match your requirements.

One thing to note though is that the report will have to be processed twice as the first time the report is processed will only "Update" the table whereas the second pass will display the information from the updated table.

HTH

-Steve


"if at first you don't succeed, sky diving is not for you"!!! )

 

[IdoMillet]

Consider a 3rd-party tool - see list at:

http://www.kenhamady.com/bookmarks.html

My CUT Light UFL (User Function Library) allows you to generate dynamic update SQL statements against any ODBC data target from within Crystal formulas.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[MSBrady]

I'll check it out Steve. thanx
Ido, I'll check out your UFL. I am still trying to eval your DLV. Since I'm in a Solomon environment I don't yet know if it will work. Solomon needs to upgrade to CR XI.