My document map contains names and nested under names are client names. Currently my tablix is displaying data for all client names. Is it possible to select a client name in the document map and then display the tablix row containing only information for
the client name selected? If so, how would I do this or how would I write an expression on the Hidden property of the row?
Yes you can do this, document maps are defined exactly for the purpose you are looking for. All you need to do is, right click on the cell you want to categorize or create a document map(RowGroup -- > Properties -- > Document Map).
Since you want to display the data only for client names which are selected in the document map, create a row group on the client names. That should help.
Expressions for hiding any properties can be written using IIF statements in the expressions of that cell.
This articles gives you a detailed information on how to do this.
rkeslar
Participant
853 Points
900 Posts
Dynamically display items in a table based on what is selected in documentmap
Jan 05, 2012 01:09 PM|LINK
My document map contains names and nested under names are client names. Currently my tablix is displaying data for all client names. Is it possible to select a client name in the document map and then display the tablix row containing only information for the client name selected? If so, how would I do this or how would I write an expression on the Hidden property of the row?
Thanks
GeeksGoneBad
Member
129 Points
57 Posts
Re: Dynamically display items in a table based on what is selected in documentmap
Jan 09, 2012 05:05 PM|LINK
It kinda sounds like you want a row group? right click on the row and create a parent group on Client Name
Sorry if that's not even close :)
Srikanth Kas...
Contributor
4289 Points
883 Posts
Re: Dynamically display items in a table based on what is selected in documentmap
Jan 10, 2012 03:21 AM|LINK
Yes you can do this, document maps are defined exactly for the purpose you are looking for. All you need to do is, right click on the cell you want to categorize or create a document map(RowGroup -- > Properties -- > Document Map).
Since you want to display the data only for client names which are selected in the document map, create a row group on the client names. That should help.
Expressions for hiding any properties can be written using IIF statements in the expressions of that cell.
This articles gives you a detailed information on how to do this.
http://beyondrelational.com/blogs/jason/archive/2010/05/13/how-to-add-a-document-map-to-your-reports.aspx
Srikanth Kasturi
Please "Mark As Answer" if my post serves purpose.