Can I INSERT using Crystal?

[pelajhia]

I am having difficulty finishing a report which contains a couple of subreports. I want to add a pie chart which will show the final results/grand totals from the various subs, but I have been told/done research that suggests that the sub reports execute after any charts making this chart impossible. I have even tried putting the chart into an on-demand sub-report, hoping this would delay the creation of the pie sufficiently to allow it to 'read' those values, but this does not work either.

Anyway, my other idea is to possibly take the grand totals and insert them into a temp table, and then show these values in a subreport/chart. I am wondering if this sort of thing is doable in crystal? If I can do the insert, will it occur in time for the subreport chart to pull correctly? Or perhaps someone out there has a better idea that might work in this situation...?
Thanks in advance!

 

[dgillz]

Crystal does not write to databases, it only reports from them.

It is possible to have a stored procedure create your temp table, and then base your report on your stored procedure.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[pelajhia]

That is what I had always thought, but I recently read in a couple of places that it might be possible.
The stored procedure idea sounds good; just to clarify, you mean that I should rebuild the report based on a stored procedure, rather than try to add an additional data source to this report, right?
I will give that a try. Thanks for the help.

 

[IdoMillet]

Crystal 9 can INSERT using a Command as a data source.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[synapsevampire]

CR 9 can do this, or you can write to a new table in a previous version using ODBC.

-k