sql server reporting services: How to Make a sub report hidden using custom code(Sqs Reporting Services) -- sql server reporting services

How to Make a sub report hidden using custom code(Sqs Reporting Services)

Rajesh Vasan
6/30/2005 3:59:51 PM

sql server reporting services: Hi There,

I have a question here. I'm using 2 subreports say subreport1 and
subreport2 in a mainreport. Based on a parameter value i would like to
show the subreport1/subreport2 or show both. Please let me know if this
is posible.

Thanks in advance.

Rajesh

RE: How to Make a sub report hidden using custom code(Sqs Reporting Se

Harolds
6/30/2005 4:19:04 PM

Using the visibility/hidden property: =iif(Parameters!ParameterName.Value =
1,True, False)

[quoted text, click to view]

Re: How to Make a sub report hidden using custom code(Sqs Reporting Se

Rajesh Vasan
6/30/2005 5:02:42 PM

Hi Harolds,

Thanks for the response it worked. But i have one more question :)
lets say the main report has got the subreport1 on the top(Eg:Say
location x=0,y=5) and the subreport2 at the location (Eg:Say location
x=0,y=10). Is it posible to move the subreport2 to the subreport1
location when the subreport1 is made hidden. Please let me know.

Thanks in Advance
Rajesh

Re: How to Make a sub report hidden using custom code(Sqs Reportin

Harolds
7/1/2005 8:19:02 AM

Not that I know of, but you could try putting your subreports in two rows of
a table (a table 2 rows by 1 column) and then use the hidden parameter of the
rows to hide or show the correct report or in this case row.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.