Have Windows App which makes call to Crystal Reports which is being published
as web services. It works but really slow. stored procedures are used to get
data from database. The windows app has crystal viewer which consumes the
crystal report web service.
The problem is, there is an audit trail report which I have to compare item
by item to find out what got changed, and dump that into a dataset, load that
dataset at runtime, create report document and load the report with that
dataset. I created a class and method to do this, which works perfectly fine.
But the problem is how do I let this class sit on a remote server (IIS), let
it process the report document and throw the object to Win App. I used
Remoting to do this.
everything worked on my local machine. Now I decided to Deploy this Win App
which has reference to a class called ReportManager which has method to load
the report, plus has reference to CrystalReport.Engine.dll. I set up the
remoting configuration for app.config plus web.config files accordingly.
When I build the set up package, it gathered all the dependencies along with
the crystal.engine runtime file. I install this setup on a different machine
but looks like it has become a THICK CLIENT as the reporting will be
processed on the user's localmachine. The remoting works, it goes out there
loads reports, processes everything but I want this whole thing to work as
Winapp THIN CLIENT which has the report viewer only, I want the IIS to
process report document and send it back to WinApp.
Have the LoadReport method sit on IIS on remote server along with the
Crysal.Engine reference. Make a call to this method from WinApp and get the
report document somehow.
Can I do this ??? As the management is only willing to buy per processor
Crystal Rerport licensing and NOT per user, as there will be around 200 users.
I really appreciate advice on this.
Dipendra.