• State Verified Answer
  • Replies 6 replies
  • Subscribers 93 subscribers
  • Views 837 views
  • Users 0 members are here
Options
Related

Report validation script

rune hystad
over 1 year ago

I'm trying to create a report for IT Shop requests to be used by application managers. Since we have  > 30 000 products and no logical grouping parameters, i have just writtens this in the sql query:

WHERE pwo.DisplayOrg LIKE '%' + @Displayorg + '%'

In order to not let the users be able to leave the user prompted paramter empty, i want to somehow have a condition or value calculation to replace a nothing value. I'm not gluent in VB.Net, so are there anyone who have any ideas as to how do this, or other suggestions?

Parents
  • +1 over 1 year ago

    Do you really need to replace the empty value or isn't it enough to make the user-prompted parameter mandatory?

    But if it needs to be a particular fallback value you could use this in the validation script. (Edited: Corrected to use the right script type.)

    Dim str As String = Convert.ToString(Value)
If String.IsNullOrWhiteSpace(str) Then
	Value = "Your fallback value"
End If

Reply
  • +1 over 1 year ago

    Do you really need to replace the empty value or isn't it enough to make the user-prompted parameter mandatory?

    But if it needs to be a particular fallback value you could use this in the validation script. (Edited: Corrected to use the right script type.)

    Dim str As String = Convert.ToString(Value)
If String.IsNullOrWhiteSpace(str) Then
	Value = "Your fallback value"
End If

Children