jdeppuser

sorry about that, I just edited it differently for this post

sorry your answer and accidently clicked accepted; as yet to try.

I found code to produce a report via java code and thought this would be easily possible but found too many errors occurring. I am able to create a report from a template using the normal procedural steps but programmatically it fails. This is critical as i need to be able to query the DB and render the reports automatically on a schedule. JRResultSetDataSource rsdt=new JRResultSetDataSource(rs); JasperReport jrpt = JasperCompileManager.compileReport("C:\Users\mmm\Documents\workspace-sts-webapps\HelloJasper\firstReport.jrxml"); //InputStream is=this.getClass().getResourceAsStream("firstReport.jrxml"); //jrpt = JasperCompileManager.compileReport(is); JasperPrint jp = JasperFillManager.fillReport(jrpt, new HashMap(), rsdt); JasperViewer jv = new JasperViewer(jp); jv.setVisible(true); [/code] Now when I actually add the report first using one of the templates, I get another error:

I have still been unable to successfully create a connection to a datasource. The actual connection works but it cannot reference the existing tables within that database. I posted on this before but would like to take an alternative approach by creating the report from within java code. For example I will query the database and then try and commit the data to a specific report.. Connection conn = DriverManager.getConnection(connectionUrl);stmt = conn.createStatement();rs = stmt.executeQuery( query );JRResultSetDataSource rsdt = new JRResultSetDataSource(rs);JasperPrint jp;JasperReport jrpt = null;jrpt = JasperCompileManager.compileReport("Flower_Landscape.jrxml");InputStream is = this.getClass().getResourceAsStream("Flower_Landscape.jrxml");jrpt = JasperCompileManager.compileReport(is);jp = JasperFillManager.fillReport("HelloJasper/Flower_Landscape.jrxml", new HashMap(), rsdt);JasperViewer jv = new JasperViewer(jp);jv.setVisible(true);con.close(); [/code]I am looking for a tutorial or assistance on how to get this done. I thought I could manipulate the fields from the xml but I have no idea on how to do this.

Does anyone have any tutorials or example related jasper projects that are created within spring tool suite?

Hozawa Thanks for your response. Yes, within the datasource selection in the report wizard I selected the data adapter but not sure what the dataset you referring to. As I mentioned above, I tested the data adapter with the test connection and it worked fine so user credentials show privileges. Could you please look at the image:/sites/default/files/images/JaspersoftReportWizard.png

My first attempt at JasperSoft Reports, community edition.Installed the necessary plugin to get it to work in Spring Tool Suite. Created a new report project and added the data adapter to connect to a sql database and the connection worked fine. Then tried to create a new report and select a datasource and design a query. This is where the error is produced: user lacks privilege or object not found: and the object in this case happens to be the DB table. I have been unable to retrieve any solution online and hoping someone can direct me here. Appreciate your response.