custom code in reports - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

custom code in reports

Author

Topic

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2006-09-18 : 23:34:55

hi friends
i wrote following custom code in report to hide/unhide a textbox in report

Public Function CheckVisibility(ByVal value As String) As Boolean
If value.tostring().length > 0
Return False
Else
Return True
End if
End Function

but i dont see this function when type in "code." in expression box ?
am using VS2005 standard edition, is it a restriction for this version ?

Cheers

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2006-09-18 : 23:35:16

i also tried using IIF in hidden property expression like below

=IIF(ReportItems!txtsub2name.Value.Length > 0,False,True)

but when i run the report i get following error

an error occured during local report processing.
the hidden expression for the textbox 'textbox1' contains an error. object variable or with block variable not set

whats wrong here ?

Cheers

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources