**we are self-hosted**
I am trying to get Customer Number to disable when list is entered and list to disable when a customer number is entered. I already found this link which giver the suggestion of <<p1>> > 0, but I must be typing it in wrong. I tried customer_no >0 and (customer_no) > 0 and @customer_no >0 and (@customer_no) > 0. None of these worked.
Can anyone help?
Ashley Elliott
Database Administrator
St. Louis Symphony Orchestra
314-286-4198
ashleye@slso.org
Ashley,
The first thing is correct. The "p" number references the parameter you want to use. So, in the screenshot above, <<p1>> would correspond to your On Account Type string. So to disable customer_no when a list_no is entered, you would put <<p3>> > 0 in the customer line since you are referencing the list parameter there. Then, you would put <<p2>> > 0 in the list line since you are referencing the customer parameter there.
Always important to keep the parameter numbers in mind, because if you go back later and insert a new parameter to your report, you have to renumber your where/disable/etc... clauses.
Hope that helps!
John
Customer_no is set up as a string, so how do I say if p2 is null?
Ashley
You should be able to treat <<p2>> just like a regular SQL variable. So maybe something like ISNULL(<<p2>>,'') = ''
**SOLVED**
I got it figured out. Having just the <<p3>> > 0 in there effectively does the same thing. I really don't need a function in both lines.
Thanks,