6 thoughts on “Creating a Table Report with Dynamic Columns

  1. Prawin

    Thanks for pointing out the omission. The column visibility expression would look something like this:
    =Fields!Product.IsMissing.
    I’ll post an update with this correction and a sample report as soon as I get a chance.

    Like

  2. Hi,
    I am a bit confused here..

    “Use the expression builder to create an expression that hides the column if that column is missing from the dataset result set:

    =Parameters!pQuery.Value

    Based on the above statement… one should use “=Parameters!pQuery.Value” as an expression..but i am getting an error “The Hidden expression used in tablix “tablix1” returned a datatype that is not valid…which actually makes as it just need True/False…but the value of the parameter would be query!

    Kindly let me know where I am doing wrong.

    Thanks,
    Prawin

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s