Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Populate tablix from same dataset based on switch Expand / Collapse
Author
Message
Posted Tuesday, April 16, 2013 5:59 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 6:40 PM
Points: 293, Visits: 1,043
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!
Post #1443057
Posted Wednesday, April 17, 2013 6:56 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, August 11, 2014 8:38 AM
Points: 349, Visits: 191
Use a Filter on each tablix, one for not nulls, the other for nulls (of course you need to use isNothing function in SSRS).
Post #1443236
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse