Friday, February 17, 2012

document mapping

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
vipulYou 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
"Vipul Shah" <VipulShah@.discussions.microsoft.com> wrote in message
news:C045C009-F5C2-4081-A0EE-0DFFF8245031@.microsoft.com...
> 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
> vipul

No comments:

Post a Comment