I have 2 parameters that are of type string. The user can enter anything they want in them. The third parameter is query based and uses the first 2 parameters to get a list of people. Is there a way I can prevent the third parameter from propigating until the first 2 are both filled in? The first 2 cannot be drop downs however, they are used in a wild card fashion.
Thanks!
Yes. Set the default on the text boxes to NULL.
Then it shouldnt try to populate until both are not null.
I just created a test report and it did not populate until both names were entered.
BobP
|||In RS2005? I just did the same thing, and the 3rd Parameter became available after I entered something in the 1st parameter (no values because the query is where firstname = @.param1 and lastname = @.param2). However, the real query is using firstname LIKE @.param1 and lastname LIKE param2 and thus populates the list as soon as I enter the first name. Which is confusing because param2 is empty. Any ideas?
|||Ah.. I see. I had the 'Allow blank value' selected. However, not pretty, it works.
|||So it IS working for you, right?
BobP
|||Yes.. thanks.
No comments:
Post a Comment