I have a report that populates the first dropdown based on a stored procedure. If the stored proc returns multiple rows the user will need to select a row in order to populate the second dropdown. This works fine. My question is: if the stored proc only returns one row I want to go ahead and automatically populate the second dropdown without making the user select the one and only option they have in the first dropdown. Is there a way to do this?
you could try refering to your stored procedure, suitably amended, under the default section of the parameter setup - if there's only one row that would be the default, otherwise NULL.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply