jake_faredge

Ok, I just create an input control server side with the same name, simple. I am wondering though, to run a report in Jaspersoft studio would I need to set the parameter to something special? (like something other than the "for prompt" option) So in my situation the value of the input control is an id for a row of a table, easy enough to use in the report query. But how exactly would I be able to get other data from the same row? Like the name column and put it into the report, would this be where variables come into play? Thanks, Jake. (sorry if this is the wrong way of asking a clarifying my question)

Hello, I am trying to use the value of an input control in my report sql statement and have a few questions. (For reference I have skimmed through the documentation once, and have searched through it many times trying to find answers - although I could have missed something.) 1. Can I create an input control in JasperReports Studio? 2. How do I put the result of the input control into the sql statement of the report? (I.e. what is its name to give to the query?) 3. I would also like to put the label of the selected value from the input query into the heading of the report. Is there any easy way of doing this. My current sql statement is the most basic statement, for example: SELECT * FROM dbo.cases The table cases contains a column that is the result of the input control. Thanks, Jake Murphy Far Edge Technology