"Anitha Naidu" <AnithaNaidu@discussions.microsoft.com> wrote in message
news:EAAB429A-0C1E-4F15-96E7-1130127902FE@microsoft.com...
> Hi,
> I have a main report which has some 10 tables/subreports i want hide some
> tables/subreports based on some condition in custom code. for this i have
> written a function in that the code below:
>
> If Parameters!langid.value="Chinese" then
> table2.visibility=hidden
> end if
> Will the above code works? for me it display error as table2 is not
> declared"
>
> Please suggest me if any alternative.
>
> Thanks in advance to helpers !
>
> Regards,
> Anitha
>
>
>
>
>

"Wayne Snyder" wrote:

> I have never tried to access object directly from the code but you might try
> Report.table2.visibility=hidden..
>
> What I normall do is have the function return the appropriate value, 1 or 0,
> true or false, ect then call the function in the property expression ie
>
> =Code.myfunc("parameters")
>
>
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
>
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "Anitha Naidu" <AnithaNaidu@discussions.microsoft.com> wrote in message
> news:EAAB429A-0C1E-4F15-96E7-1130127902FE@microsoft.com...
> > Hi,
> > I have a main report which has some 10 tables/subreports i want hide some
> > tables/subreports based on some condition in custom code. for this i have
> > written a function in that the code below:
> >
> > If Parameters!langid.value="Chinese" then
> > table2.visibility=hidden
> > end if
> > Will the above code works? for me it display error as table2 is not
> > declared"
> >
> > Please suggest me if any alternative.
> >
> > Thanks in advance to helpers !
> >
> > Regards,
> > Anitha
> >
> >
> >
> >
> >
>
>