How To Get Data in 2 Matrix Report by grouping those in List box

Question

H!, I was trying to combine 2 Matrix report in SSRS but the out come result is not what I want. I need to header columns to be fix even there are not data for those particular dates. attached image shows what I am trying to do and the what is the out put and I am trying to get out of it. Hope someone can help me.

Same been posted in

Thanks

Answer 1

Hi @Arrow
I did a test. These are the two matrices created by DataSet1.

Then add a List to the report and drag and drop the two matrices into the List. Mouse click to select List to display tablix properties of list, select DataSetName as DataSet1.

Then select List, in the row groups pane below, right-click Details to display the Details row property, and add [id] as the grouping by.

Preview:

Best regards,
Aniya

Answer 2

Dear Aniya,
Thank you for the reply.
Actually I am trying to get the required dates as headers using "With Statement" as below with 2 Parameters Passed

WITH PayrollMonth(PRM)AS
( SELECT CAST(@LTSFrom as DATETIME)
UNION ALL SELECT PRM + 1
FROM PayrollMonth
WHERE PRM < @LTSTo)

the issue is all dates will appear between 2 parameter dates but the issue is, for those dates with no data "id" column shows as "NULL" when execute the Stored Procedure. So when I group it by "id" dates are not getting displayed for those "id"s which appeared as null. Like below

Thanks again