c-george Posted June 12, 2012 Share Posted June 12, 2012 Hi,I'm new to the jasper products so please excuse the basic level of my question.I have connected to Infobright database and press "Test" button to make sure i have the connection.The test was succesfull, so I procceed to the next step selecting the samplest reporty template.I was expecting to be able to see some tables and/or fields on the left panel under "Fields", but its empty.Am I missing anyting?C_George Post Edited by c-george at 06/12/2012 16:13 Link to comment Share on other sites More sharing options...
c-george Posted June 12, 2012 Author Share Posted June 12, 2012 Anybody? Link to comment Share on other sites More sharing options...
augarte Posted June 13, 2012 Share Posted June 13, 2012 Hi, To see the fields you have to define a query in the "Report Query" section. After doing that and retrieving the fields you'll see that the fields returned by your query are added.Here you have a tutorial, I guess you have a newer version of iReport but maybe this could help you defining your query: http://www.thainetbeans.com/sample/reportquery.htmRegards. Link to comment Share on other sites More sharing options...
c-george Posted June 13, 2012 Author Share Posted June 13, 2012 I took a look at the link but the problem is that I don't have "Data" option in my menu:Any sugestions? Link to comment Share on other sites More sharing options...
c-george Posted June 13, 2012 Author Share Posted June 13, 2012 Can anybody help me with this. I can see db/tables in Services window but can't find the way to "drag and drop" them to the report space.I need helpd urgently or the managements will pull the Jaspersoft from the shortlist of products considered for production.ANYBODY? Link to comment Share on other sites More sharing options...
augarte Posted June 14, 2012 Share Posted June 14, 2012 Hi, To define your query you can click in the icon that is marked with red colour in the attached image. This will open the report query (in the second image) and here you can define your query, if you click 'Automatically Retrieve Fields' it will create the fields automatically from the query, then you click in Ok and the fields will be ready to drag and drop to your report. Hope this helps. Regards Link to comment Share on other sites More sharing options...
c-george Posted June 14, 2012 Author Share Posted June 14, 2012 Does this mean that IReport is importing all data from the query?If so, that would defit the purpose of having database?!C_G Link to comment Share on other sites More sharing options...
augarte Posted June 15, 2012 Share Posted June 15, 2012 If you want to use a database connection, the data you add in the report is defined in a query. This query can be dynamic because you can use parameters to have different results in each execution. Anyway, if you don't like the option of the database, you can use Xml DataSource, Java Bean datasource, and other ones... You can see all the different datasources in the attached image. 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