Populate tablix from same dataset based on switch

• PSB

  SSChampion

  Points: 13195

  More actions

  April 16, 2013 at 5:59 pm

  #394606

  CREATE TABLE #Enabled

  (

  State VARCHAR(15),

  DaysToEnable VARCHAR(10),

  NumberOfDeliveries INT,

  NumberofAccountNumbers INT

  )

  INSERT INTO #Enabled (State,DaysToEnable,NumberOfDeliveries,NumberofAccountNumbers)

  SELECT 'Enabled',NULL,410,157

  UNION

  SELECT 'Enabled','0-4',298,99

  UNION

  SELECT 'Enabled','10-14',35,21

  UNION

  SELECT 'Enabled','15-19',6,5

  UNION

  SELECT 'Enabled','20+',0,0

  UNION

  SELECT 'Enabled','5-9',71,32

  UNION

  SELECT 'Non-Enabled',NULL,1260,358

  SELECT * FROM #Enabled

  DROP TABLE #Enabled

  I have a detail report with a separate dataset and two summary report below the detail using the query in the above dataset

  For the first summary report I need the following (where days to enable IS NOT NULL):

  DaysToEnable NumOfDeliveries NumberOfAccountNumbers

  0-4 298 99

  10-14 35 21

  15-19 6 5

  20+ 0 0

  Second Summary report (where days to enable IS NULL):

  State NumOfDeliveries NumberOfAccountNumbers

  Enabled 410 157

  Non-Enabled 1260 358

  How do I achive this using the same dataset in different tablix ?

  Please help.

  thanks!

• TaylorMade

  SSC Eights!

  Points: 967

  More actions

  April 17, 2013 at 6:56 am

  #1607223

  Use a Filter on each tablix, one for not nulls, the other for nulls (of course you need to use isNothing function in SSRS).