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_city FROM `leads` leads WHERE 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?
2 Answers:
Thank you,
There is much more detailed example here::http://isura777.blogspot.co.il/2011/10/pass-parameters-from-main-report-to.html
as 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.