I m having problem using jasperreports.I m using jasperassistant in eclipse.
Kindly tell me how to pass resultset from a servlet/jsp which will be based on i/p param entered by user in html.I m using tomcat 5.5.
e.g String command="select * from user where age="+hage+" order by birthdate";
where 'hage' is entered by user in html.
Also please tell me
1>what files shud b there in tomcat for running such program like any library file...and where it shud b?
2> what shud b the value of first parameter in JasperFillManager.fillReportToFile for .jasper file
like whether it shud be relative to current folder or absolute like c:/programfiles/.........
3>where to put .jrxml &.jasper file in tomcat dir for generating report
i have to also save generated report in MS-Excel format.