I am in a situation where I have to use Crystal Reports 9, to generate reports, but those reports ( which are primarily gantt charts ) are to be rendered onto the browser using jsp's. The jsp, would have parameters which the user selects ( say the region and the customer whose sales over a particular quarter needs to be analysed ), and these user selection values are going to be parameters to the sql which the crystal reports should run and based on that generate the chart. I am calling for help from anyone who knows how to integrate crystal reports with jsp. Is there any Java API for Crystal Reports, by which I can pass in the parameters to the sql based on which CR would generate the required report ( the graph ).
Note: we are using Weblogic Express as our AppServer.
just in case, my e-mail id is: firstname.lastname@example.org
Thanx a lot in advance.