Post reply

Exporting SSRS Report to Excel

  • February 4, 2010 at 11:57 am

    #216336

    Hello All! First post! I have an SSRS report with a table in it that gets refreshed daily and emailed to the report users on a daily basis. It's been requested for it to have Filtering on the columns already enabled or in place when they open the spreadsheet from the email (manual way of doing it is in Excel, goto Home tab>Sort & Filter>Filter).

    Is there a way to set this in the design of the report? Report property or setting? I hope the answer is yes and that I just haven't found it yet.

    Thanks in advance!

    Jeff.

  • February 8, 2010 at 2:31 pm

    #1115821

    Hi Jeff,

    You can definitely do that.

    You can create a Multi Value Parameter for the report .Then create a Filter for the table in the Table Properties.You can have an expression (Sumthing like ColumnValue IN Parametervalue)which filters the values.In the preview , the user can select the values for what he wants the report.

    Thanks,

    Nemo

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

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