Wednesday, May 28, 2014

Multiple Rows for Same Value in Matrix Report

Hello


I am trying to create a matrix report that shows different page for each Category. Report looks like follows:


Page1( for Category '1')


Agent | Calls | Sales


TestAgent1 183


TestAgent1 51


Page2( for Category '2')


Agent | Calls | Sales


TestAgent1 265


TestAgent1 132


The issue is as you can see in above table, that i am getting repeated rows for same agents. I have tried making a parent group on Agent but it would still keep showing multiple rows. Ideally, it should show each agent only once in each page.


Any help would be appreciated.


PS: I am new to SSRS and this is my first time on microsoft blog, so i apologize if i wasn't able to follow the protocols/culture here.


Thanks


No comments:

Post a Comment