December 17, 2013 at 6:26 pm
Hi, I've attached an example of an excel report I'm trying to create in SSRS.
The problem I have is that if data doesn't exist in my data source for a given day or metric then the row or column disappears, along with the column or row headers.
In other reports I've solved this problem by creating a separate table with the headers and doing an outer join to that table. I was hoping someone might have a simpler solution.
December 17, 2013 at 11:56 pm
What's your source, SSAS or SQL Server?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 18, 2013 at 8:18 am
Thanks for getting back to me on this, my source is a table in SQL Server.
December 18, 2013 at 1:01 pm
In that cause you just need to make sure there is data for every cell.
Do OUTER JOINS between tables and replace NULL with empty strings.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply