infocepts Posted November 26, 2007 Share Posted November 26, 2007 hi, am quite new to jasper. Can anyone tell that whether its possible to make iReports generate its own SQL for an specific templete Link to comment Share on other sites More sharing options...
svenn Posted November 26, 2007 Share Posted November 26, 2007 I don't understand what your trying to do. Could you provide an example? Link to comment Share on other sites More sharing options...
infocepts Posted November 27, 2007 Author Share Posted November 27, 2007 if u have use other BI tools , they have an SQL engine of its own by which it can have query generated as per the objects in the template. As joins cannot be designed by query designer it would be an cumbersome process to design an complex query having lots of joins.. Link to comment Share on other sites More sharing options...
infocepts Posted November 27, 2007 Author Share Posted November 27, 2007 if u have use other BI tools , they have an SQL engine of its own by which it can have query generated as per the objects in the template. As joins cannot be designed by query designer it would be an cumbersome process to design an complex query having lots of joins.. Link to comment Share on other sites More sharing options...
svenn Posted November 28, 2007 Share Posted November 28, 2007 IReports can not do that. I create and test all my queries outside of iReport. That would be your best bet for creating custom queries. 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