Friday, February 24, 2012

Hiding parts of the report

Hello All,
I have to generate a report based on parameters. And each part of the
report depends based a particular set of parameters.
Is there a way to hide the parts of the report that i dont need to show
?
Thankx
BofoDid you look into the Visibility.Hidden property of reportitems? You can use
expressions based on parameter values to statically or dynamically hide
certain areas of a report.
More information can be found here:
*
http://msdn.microsoft.com/library/en-us/RShowto/htm/hrs_designer_v1_3kq5.asp
*
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_dc_v1_0rc7.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Win2003InstallIssues" <bofobofo@.yahoo.com> wrote in message
news:1107047048.476551.144590@.c13g2000cwb.googlegroups.com...
> Hello All,
> I have to generate a report based on parameters. And each part of the
> report depends based a particular set of parameters.
> Is there a way to hide the parts of the report that i dont need to show
> ?
>
> Thankx
> Bofo
>|||Hello Robert,
I am partially successful in using the Hiding/hidden properties.
Here is the issue.
I have 7 diff parameters to my report, 2 main groups say A and B to gen
Areport and Breport
if the user enters any of the fields of Group A, the ReportB should not
appear and vice-versa.
Now I tried using the parameter.value of the Group B to hide Breport.
But to no avail. I can still see the Textbox label.
I can hide the table cos I created dummy fields in Select and use them
as the Labels for the table columns.
But what I need is something that will hide the entire part of the
report.
Any Ideas on how to go about it ?
Thx|||Finally got it.
This is the expr.
=iif((Parameters!param1.Value + Parameters!param2.Value +
Parameters!param3.Value +
Parameters!4.Value)="", TRUE, FALSE)
Rgds
Bofo

No comments:

Post a Comment