baga_priya Posted August 5, 2010 Share Posted August 5, 2010 Hi,Iam new to jaspersoft.Can anyone help me out?1) What are the knowledge we need to have to work with jaspersoft like mysql,xml etc...?2) We have our datas in mysql database,how we can get report using it in jasperserver?3) Whether we can view the database in jaspersoft ?4) Can anyone explain how to generate a report step by step with a sample database and table in mysql.Please help me.Thanks. Link to comment Share on other sites More sharing options...
abdon Posted August 5, 2010 Share Posted August 5, 2010 1) What are the knowledge we need to have to work with jaspersoft like mysql,xml etc...?R - Java, SQL, XML2) We have our datas in mysql database,how we can get report using it in jasperserver?3) Whether we can view the database in jaspersoft ?4) Can anyone explain how to generate a report step by step with a sample database and table in mysql.R - You should try reading the official documentation athttp://jasperforge.org/website/jasperreportswebsite/trunk/documentation.html?header=project&target=jasperreportsBruno Abdon Link to comment Share on other sites More sharing options...
baga_priya Posted August 6, 2010 Author Share Posted August 6, 2010 Thanks for the reply.I can create reports and charts for my datas in myswl database.whether we can use excel as a datasource for jasper and ireport? Link to comment Share on other sites More sharing options...
abdon Posted August 6, 2010 Share Posted August 6, 2010 I can create reports and charts for my datas in myswl database.R - I suppose you're asking about the feasibility of creating a report for you data stored on a MySql database. The answer is yes you can create such reports with JasperReports.whether we can use excel as a datasource for jasper and ireport?R - As far as I know, this can't be done out of the box. But you can write a java class that knows how to read your excell files and implements net.sf.jasperreports.engine .JRDataSource, and this will do the job.Bruno Abdon Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now