kcsekhar25

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 appreciated below 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 DESCRIPTION FROM 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)

hi all i got it i am trying import in community edition but mine that domain is on professional edition

hi i am trying to import an the directory in jasperserver 4.0 but i a getting below error. not importing org.exolab.castor.xml.MarshalException: The class for the root element 'semanticLayerDataSource' could not be found.{File: [not available]; this is what i am getting while importing ------------------------------------------------------ Creating ActionModelService object. Creating action model infrastructure. Folder /EDI_BU already exists, importing permissions only Folder /EDI_BU/DATA_SOURCE already exists, importing permissions only Folder /EDI_BU/DOMAINS already exists, importing permissions only Folder /EDI_BU/REPORTS already exists, importing permissions only Folder /EDI_BU/REPORTS/PCMR already exists, importing permissions only Folder /EDI_BU/REPORTS/PCMR_INPUT_CONTROLLERS already exists, importing permissions only Resource /EDI_BU/DATA_SOURCE/MSSQL_SERVER already exists, not importing i uninstalled and installed jasperreports server 4.0 again but still same error can anyone help me

Hi, CAn anyone please answer this question ? we want use profesional JS 4.1 for our reporting service. regards, Post Edited by kcsekhar25 at 07/06/2011 02:53

Thank you very much :)

hi, can we create cascading input control using custom datasource ?

I too have the same issue. Is it possible to design domain suah that there are no hard coded sql queries and the domain can be used with multiple databases ? regards

I've read that ad-hoc reports can be design using custom datasource. But I'm unble to design a domain using custom datasource. Please let us know if this is possible.