I have a simple query to fetch First_Name, Middle_Name, Surname from a table along with few other fields.
I have Matrix control on my Report designer. What I am looking for is to, in the matrix the top level (fields) it should just appear as Name (with a collapse/Expand button) if somebody expands it then it should show the names as First_Name, Mid_Name, Surname..
I read from somewhere that I need grouping first but not very sure where and how in my case.
Can somebody put some thoughts on how to do this SSRS 2008?
-Forum Etiquette: How to post Performance Problems[/url]
-Forum Etiquette: How to post data/code to get the best help [/url]