Dynamic SSRS Parameter?

  • Assume a report with two parameters.

    The first parameter list uses a dataset which queries a table to supply a list of names.

    Is it possible for a second parameter to query a table using the first parameter's value?

    a la

    Select First_Name from mega_names

    WHERE

    Last_Name=Parameters!LastName.Value

    or...is there a way to populate the second parameter set as soon as the first parameter has "lost focus"?

    Appreciate any guidance...

    3G

  • what you need is cascading parameters. Pls go through this article.

    http://msdn.microsoft.com/en-us/library/aa337169.aspx

  • Doesn't get much more appropriate than that...perfect!

    Thanks!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply