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