AnsweredAssumed Answered

Creating parameters for report that prompt for multi values

Question asked by ndore on Feb 22, 2017
Latest reply on Feb 27, 2017 by msnizek

I am new to CPM and Jasper Studio. I created a report in Jasper studio, in the report sql I have the following parameter that should be prompting for multiple vales to select from. When I run the report there is no value. Here is my parameter:

AND $X{IN, DWH_RES_OBS_MAPPING.OBS_UNIT, OBS_UNIT}

 

full sql:

<![CDATA[SELECT  DWH_RES_RESOURCE.RESOURCE_NAME ,    DWH_TME_SHEET.PERIOD_FINISH_DATE ,
                  DWH_RES_RESOURCE.RESOURCE_MANAGER ,    DWH_LKP_SCI_DEPARTMENT.SCI_DEPARTMENT,
                  DWH_TME_SHEET_LN.TIMESHEET_STATUS ,  sum(DWH_TME_ENTRY_FACTS.TIME_HOURS)
                  
                      
 FROM  DWH_TME_SHEET   DWH_TME_SHEET
 INNER JOIN  DWH_TME_SHEET_LN    DWH_TME_SHEET_LN  ON  ( DWH_TME_SHEET.TIMESHEET_KEY =  DWH_TME_SHEET_LN.TIMESHEET_KEY AND  DWH_TME_SHEET_LN.LANGUAGE_CODE ='en' )
 INNER JOIN   DWH_TME_ENTRY_FACTS  DWH_TME_ENTRY_FACTS ON  (  DWH_TME_SHEET.TIMESHEET_KEY = DWH_TME_ENTRY_FACTS.TIMESHEET_KEY )
 INNER JOIN  DWH_TME_PERIOD   DWH_TME_PERIOD  ON (DWH_TME_SHEET.TIME_PERIOD_KEY = DWH_TME_PERIOD.TIME_PERIOD_KEY )
INNER JOIN  DWH_TME_ENTRY DWH_TME_ENTRY ON( DWH_TME_SHEET.TIMESHEET_KEY =DWH_TME_ENTRY. TIMESHEET_KEY)
INNER JOIN DWH_INV_PROJECT  DWH_INV_PROJECT ON ( DWH_TME_ENTRY.INVESTMENT_KEY = DWH_INV_PROJECT.INVESTMENT_KEY )
 INNER JOIN DWH_LKP_SCI_DEPARTMENT  DWH_LKP_SCI_DEPARTMENT ON (DWH_INV_PROJECT.SCI_DEPARTMENT_KEY =DWH_LKP_SCI_DEPARTMENT.SCI_DEPARTMENT_KEY )

 

 INNER JOIN  DWH_RES_RESOURCE   DWH_RES_RESOURCE  ON ( DWH_TME_SHEET.RESOURCE_KEY= DWH_RES_RESOURCE.RESOURCE_KEY )  
 INNER JOIN   DWH_RES_RESOURCE_LN  DWH_RES_RESOURCE_LN  ON (DWH_RES_RESOURCE.RESOURCE_KEY = DWH_RES_RESOURCE_LN.RESOURCE_KEY AND DWH_RES_RESOURCE_LN.LANGUAGE_CODE='en')
 INNER JOIN  DWH_RES_OBS_MAPPING  DWH_RES_OBS_MAPPING  ON (DWH_RES_RESOURCE.RESOURCE_KEY = DWH_RES_OBS_MAPPING.RESOURCE_KEY)
 
 WHERE DWH_TME_SHEET.TIMESHEET_STATUS_KEY <5
 AND $X{IN,DWH_RES_OBS_MAPPING.OBS_TYPE_ID, OBS_TYPE_ID}
 AND $X{IN, DWH_RES_OBS_MAPPING.OBS_UNIT, OBS_UNIT}
 GROUP BY  DWH_LKP_SCI_DEPARTMENT.SCI_DEPARTMENT,DWH_TME_SHEET.PERIOD_FINISH_DATE ,
                       DWH_TME_ENTRY_FACTS.TIME_HOURS,DWH_TME_SHEET_LN.TIMESHEET_STATUS ,
                     DWH_RES_RESOURCE.RESOURCE_NAME ,                      DWH_RES_RESOURCE.RESOURCE_MANAGER
  ORDER BY DWH_TME_SHEET_LN.TIMESHEET_STATUS]]>

Outcomes