emrizwan Posted February 24, 2015 Share Posted February 24, 2015 Hi,is it possible to pass a query string as a parmeter to a report?for instance, I have a sql likeselect * from employees<lexical parameter>and in this parmeter space, I pass string value as "where dept_id = 25 and location_id = 1"any ideas? thanks Link to comment Share on other sites More sharing options...
Solution emrizwan Posted March 26, 2015 Author Solution Share Posted March 26, 2015 I've found the solution to thisthe parameter should be defined as, $P!$P!{my_query}Refer to below link for more detailshttp://community.jaspersoft.com/wiki/using-report-parameters 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