I need some advise from the experts out there. I am currently redesigning a client/server app which runs Crystal templates with stored procs providing the business logic. I am a newbie to Crystal Enterprise. Any suggestions will be greatly appreciated.
We are moving to a 3-tier architecture with a C# application client (where reports will be requested with parameters), a Websphere Application server as the middle tier and an Oracle database. I would hope to hold the business logic in the middle tier using EJB's.
My main concern is as to where the Crystal report engine will sit in this architecture and how the communication will be done between the report presentation bit in C# app and the business logic holding websphere application server. Should the CR engine be on and independant server? Would I use web services to communicate between Websphere and the client application hence requiring Crystal on the client to use the XML? Can te EJB's be a data source? If this architecture won't cut it is there a better way of doing the reporting given the architecture?
Previous Topic
