xantia95d Posted October 6, 2009 Share Posted October 6, 2009 Is there a way to pass the visible column(s) of a query or list from a input control back to the jrxml file so that they can be displayed in the report heading. I have no problem passing back the value column (which is for the most part an id) however, I need to be able to provide the description on the id'ed object for it to be meaningful to the user. Link to comment Share on other sites More sharing options...
swood Posted October 7, 2009 Share Posted October 7, 2009 Nothing directly. With a query input control, you look up the visible columns in your report query with the ID parameter. With a list of values input control, you will need some logic in your report to work out what was visible. This could be in a scriplet, or a parameter expression, like: <parameter name="idParameter" class="java.lang.String"/> <parameter name="visibleParameter" class="java.lang.String"> <defaultExpression>some expression using $P{idParameter} as an argument</defaultExpression> </parameter> ShermanJaspersoft Link to comment Share on other sites More sharing options...
xantia95d Posted October 8, 2009 Author Share Posted October 8, 2009 Sherman,Thanks for your answer, sort of what I expected but not what I was hoping for. The problem with using the report query is that it may not return any values, so the user would not see the full selection criteria used. Hence this means putting in place a set of sub reports to fill in the selection criterial used for the report. As we want to use the same jrxml file both in our base web application and the jasperserver this would lead to the two of them going their own way. Is there any chance that we could convince your development team to add an additional parameter e.g. ParameterNameDesc for the selected values in both select and multiselect input controls.Thanks Terry Link to comment Share on other sites More sharing options...
mdahlman Posted October 8, 2009 Share Posted October 8, 2009 Terry,I don't know what sort of priority it will get overall... but it's certainly a valid request. Please put it in the tracker.Regards,Matt Link to comment Share on other sites More sharing options...
silvannos Posted March 25, 2010 Share Posted March 25, 2010 I have the exact same problem...right now all I can get to show in the report is the value of the parameter, not what it represents. I would be very grateful if you guys could add that feature in the future. :DThanks,Simon Link to comment Share on other sites More sharing options...
mdahlman Posted March 26, 2010 Share Posted March 26, 2010 Remember that the first step toward asking the team to consider the new feature is to enter it in the tracker. (A good second step is posting the tracker id number here and convincing others to vote for it.)Regards,Matt Link to comment Share on other sites More sharing options...
silvannos Posted March 26, 2010 Share Posted March 26, 2010 Thanks Matt, you're right.Here is the ticket by xantia95d: http://jasperforge.org/projects/jasperserver/tracker/bug_view_page.php?bug_id=4347 Link to comment Share on other sites More sharing options...
lachinaa Posted October 15, 2021 Share Posted October 15, 2021 Any news about this feature request? Or in next release (7.5, 7.8) is there another way to obtain the visible column of the parameter to display?Thanks 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