June 23, 2014 at 12:13 am
I have a report which uses a Tablix to show some Data. The column shows Month information and corresponding values against it. For those months, where there are No Data, those columns doesn't show up. I want my tablix to show all the months even if there is no Data.
I want to fix this in Query itself. Attached is what is the current and expected behaviour.
MyQuery...
Select A,Month,SUM(Value) from Table Group by A,Month
This seems too basic, but the fact that I need this help very urgently, I thought to post the same on forum also and side by side I can work on it as well.
Thanks in advance to all.
June 23, 2014 at 1:11 am
How I usually solve this in SQL is that I have a table with all the months in it and I join this against the data with a left outer join.
That way I am 100% sure all the months will be in the result set.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply