Dataset selection based on report Param.

  • Hi, I'm developing some reports in SSRS (SQL2012) and the user want to see any one of the 2 data set values based on param in report.

    For example based on parameter value data set need to slecte,since SSRS report desgin reamins same. Only Data set needs to changed based on paramer value.

    In short Based on Param value select 1 data set (there are 2 different Dataset present in report) to report.

    Any input on this would be much appreciated

  • Probably several ways to do this.

    One would be to have two tablixes, one on top of the other and set one visible and the other not depending on which parameter value is chosen. Just set the Visible property

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

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