beekerc69 Posted November 15, 2015 Posted November 15, 2015 I'm converting reports from Crystal to Jaspersoft. The parameter nomenclature is similar but different "$P{<parm_mame>}" vs "{$<parm_name>}". but for the purposes of initial report creation, i comment out (using oracle double dash "--") any line that refernces a parameter so when i test it grabs all available records. however, when i compile the code, i get errors saying that "Query Parameter not found: <parm_name>". when i look at the code both in the Source tab and the DataSet and Query Editor dialog, every line referencing a parameter is commented out.why is this happening? do i still need to define parameters in the report if they're note being executed in the code?Then another odd thing happened, i removed the affected lines (so now there is no trace of parameter reference in the SQL code) and tried to compile and/or preview the report, and i still get errors to "Query Parameter not found" to parameter references that don't even exist in the report at all?is this normal behavior for Jaspersoft Studio or is this a bug?
hozawa Posted November 15, 2015 Posted November 15, 2015 Switch to the "Source" view and search if there is still a reference to the parameter.
beekerc69 Posted November 17, 2015 Author Posted November 17, 2015 I reviewed the SQL code in Source and in the Dataset and Query Editor.no trace of those parameters exist
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