vb.net - Hide / show line programatically in report -
i using vb.net , reportviewer generate report. need programmatically hide line depending whether checkbox checked or not. (a simple if statement).
how call this? how refer reportviewer's line element? how tell hide/show?
thank in advance
if checkbox ticked/unticked before loading report, easiest way achieve using reportparameters
.
reportparameters
allow pass values rdlc report. once report loaded, can define report behavior based on parameter values.
code before loading report:
'retrieve checkbox value dim ischecked boolean = yourcheckbox.checked 'create new parameter send report dim parameters new list(of reportparameter) parameters.add(new reportparameter("checkboxvalue", ischecked)) 'send parameter report reportviewer.localreport.setparameters(parameters)
and after you've added code, need define parameter in .rdlc
file well. .rdlc
file open in visual studio, go report
menu , select report parameters
.
to consistent code, should add parameter named checkboxvalue
, click ok
close window.
finally in .rdlc
report designer, should select textbox or label , use expression editor (right-click textbox/label want show/hide , select expression
)
here you'll need write expression based on logic:
iif(expression boolean, truepart object, falsepart object)
this expression:
iif(parameters!checkboxvalue.value = false, yourtextbox.visible = false, yourtextbox.visible = true)
Comments
Post a Comment