Trouble with Server-Side component

[wagaman]

I know that OWC is not intended for use on the server side, however I'm
not sure of another way around it. Here is what I need to do:

1. Create jpg of OWC PivotTable
2. Create jpg of OWC Chart
3. Insert those jpg's into an SQL DB
4. Create a Crystal Report to display both images together (along with
disclaimers and signature lines)

I have no problem with 3 and 4. My problem is with 1 and 2. The
approach I am currently taking is from the client side object, pass
XMLData to the server This XMLData is used to build server side OWC
objects. The server then does an ExportPicture on the server side
objects. I then insert the pictures into my SQL Db and populate my
Crystal Report.

The problem is the images show an error message stating:

The query could not be processed:
The data provider didn't supply any further error information.

Does anyone know of any way around this? I know that (on the client
side) if I do not have the web site listed in "Trusted Sites" the I get
a dialog box. Could this be tripping up the server side? I do have the
site listed as "Trusted", but perhaps that doesn't matter on the server
side.

BTW. this is OWC11 and ASP.Net 1.1

Thanks
Tim

 

[wagaman]

Crystal doesn't allow you to embed OWC, do they? I wish they did. If
they do, please let me know how.