March 7, 2017 at 8:48 am
Hello,
I am grouping data based on a 1,2,3 group values but on one page of the report i have only group values 1 and 2. Question is how to show group 3 on that page?
Best regards
Lukas
March 7, 2017 at 10:16 am
You haven't given us enough information to determine the problem, let alone determine how to fix it. For instance, is group 3 showing on the following page, or is group 3 not showing because you don't have any data for that group?
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
March 7, 2017 at 12:34 pm
Thank you for reply. Your assumption is right, i don't see group number 3 because i don't have any data for that group.
March 7, 2017 at 3:14 pm
SSRS can only work with the data that you provide. It cannot fill in gaps in your data.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
March 8, 2017 at 3:54 am
Thank you for reply. I had to do something with this problem so i came up with following solution.
I have added a row that holds value for missing group value (in our case that row value equals 3) and added an expression that takes value 0 when Nothing. Then i have excluded value 3 from a group. That works.
If you have any remarks please let me know.
Best regards
Lukas
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply