sql server reporting services: document mapping -- sql server reporting services

document mapping

Vipul Shah
1/14/2005 1:29:57 PM

sql server reporting services: I have a report which has two items- chart and a matrix, both uses same
datasets and produces same results. I want to give an option to user to
choose between chart and matrix. I was thinking to use document mapping.
But i can't create bookmarkID, or document map on chart or matrix name, it
only gives option to use available fields from dataset. I end up using two
dummy text box linking them to chart and matrix having chart and matrix
hidden initially. I don't like this. Is there any other option?

Thanks

Re: document mapping

Wayne Snyder
1/16/2005 10:13:35 AM

You could create a parameter, that the user could choose chart or matrix,
and you could change the visibility of both based on the parameters..

Visibility for chart
=Iif(Parameters!ReportType.Value) = 1,False, True)

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

[quoted text, click to view]