Script Problems
My report is a simple query of a MS SQL table. However, I would like for the report to NOT print txtUnitPrice if the txtPartNumber is "Group". This is my VB script.
Public Class ReportScript
Private Sub GroupHeader1_BeforePrint(ByVal sender As object, ByVal e As EventArgs)
txtDescription.HideValue = "Page Break"
IIf(txtPartNumber.Text = "Group",txtUnitPrice.Visible = false,txtUnitPrice.Visible = true)
End Sub
Private Sub Data1_BeforePrint(ByVal sender As object, ByVal e As EventArgs)
IIf(txtPartNumber.Text = "Group",txtUnitPrice.Visible = false,txtUnitPrice.Visible = true)
End Sub
Public Class ReportScript
Private Sub GroupHeader1_BeforePrint(ByVal sender As object, ByVal e As EventArgs)
txtDescription.HideValue = "Page Break"
IIf(txtPartNumber.Text = "Group",txtUnitPrice.Visible = false,txtUnitPrice.Visible = true)
End Sub
Private Sub Data1_BeforePrint(ByVal sender As object, ByVal e As EventArgs)
IIf(txtPartNumber.Text = "Group",txtUnitPrice.Visible = false,txtUnitPrice.Visible = true)
End Sub