rodnikosh Posted December 12, 2012 Share Posted December 12, 2012 i'm using IReport 4.8.0. i created a dataset and using it for a table and a chart and everything works fine.now i want to add a string parameter so the user can insert a name of city.so i added a new string parameter inside the dataset and dragged it into Page Header. i also updated the Dataset query so it will receive the value from the parameter:SELECT COUNT(leads.`status`) AS Number_Of_Status, leads.`status` AS leads_status, leads.`primary_address_city` AS leads_primary_address_cityFROM `leads` leadsWHERE leads.`primary_address_city` = $P{city_to_choose}GROUP BY leads.`status`but all i get when pushing the "preview" is "Parameter Not Found: city_to_choose" what did i miss? Link to comment Share on other sites More sharing options...
Solution sanbez Posted December 12, 2012 Solution Share Posted December 12, 2012 Add paratemer city_to_choose in Report (not in a Dataset). After that you can pass it into New Dataset 1 (for example if you want to display this parameter in table header) Link to comment Share on other sites More sharing options...
rodnikosh Posted December 12, 2012 Author Share Posted December 12, 2012 Thank you,There is much more detailed example here::http://isura777.blogspot.co.il/2011/10/pass-parameters-from-main-report-to.htmlas you said, The parameters from inside the dataset , need to be mapped into the master report parameters. only then the master report recognizes the parameter defined inside the dataset. 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