kcsekhar25 Posted July 18, 2011 Share Posted July 18, 2011 hi all,below is the query i am using to get the fields.i need to provide ALL_MAPPLETS.SUBJECT_AREA, ALL_MAPPLETS.MAPPLET_NAME as input controls but ALL_MAPPLETS.MAPPLET_NAME is not included in the query.number of records without including ALL_MAPPLETS.MAPPLET_NAME are 86. which is the one i have to use.number of records including ALL_MAPPLETS.MAPPLET_NAME are 97.my question is how can i able to provide the input control ALL_MAPPLETS.MAPPLET_NAME to the report without including the field in the query.wishing to get some support.any support would be appreciatedbelow is the query i am using to get the fields.SELECT DISTINCT MAPPLET_REPOSIT_INFO.REPOSITORY_NAME, ALL_MAPPLETS.SUBJECT_AREA, MAPPLET_WIDGET_INST.WIDGET_TYPE_NAME, MAPPLET_WIDGET_INST.INSTANCE_NAME, SUBSTRING(MAPPLET_WIDGET_INST.DESCRIPTION,1,254) as DESCRIPTIONFROM rs_user.REP_ALL_MAPPLETS ALL_MAPPLETS, rs_user.REP_REPOSIT_INFO MAPPLET_REPOSIT_INFO, rs_user.REP_WIDGET_INST MAPPLET_WIDGET_INST WHERE (ALL_MAPPLETS.PARENT_MAPPLET_ID <> MAPPLET_REPOSIT_INFO.REPOSITORY_ID AND ALL_MAPPLETS.PARENT_MAPPLET_ID = MAPPLET_WIDGET_INST.MAPPING_ID AND ALL_MAPPLETS.PARENT_MAPPLET_VERSION_NUMBER = MAPPLET_WIDGET_INST. VERSION_NUMBER AND ALL_MAPPLETS.PARENT_SUBJECT_ID = MAPPLET_WIDGET_INST.SUBJECT_ID) Link to comment Share on other sites More sharing options...
kcsekhar25 Posted July 20, 2011 Author Share Posted July 20, 2011 hi all,i am adding input controls through add input control option in edit .the thing is if i take filters while choosing the report from domain, in ireport it gives that filters as parametes but if i attach input controls externally it is not giving any paramets relating to those filters in ireport.that time i am creating parameters for in ireport for that and cascaaidng input control is working.but the issue is it is giving same report results even if we choose different set of input controls.can anyone help me in this regard thanks Link to comment Share on other sites More sharing options...
antonfomin Posted July 22, 2011 Share Posted July 22, 2011 Hi kcsekhar25, I didn't completely get your situation unfortunately, but I want to tell you some general info at least. As far as I know, if you want to have an input control, you should have a parameter for it, defined in jrxml with identical name. To make query return different results depending on input control`s selected value, you have to put the parameter in query, otherwise changing parameter`s value leads to nothing. Usually, the parameter is used in "where" clause of the sql query. Anton. 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