I have an excel report, with 10 columns on it. And each column has auto filters on it in Excel. When I develop this report, in SQL Reporting services 2000, how do i get the auto filters on the report. Basically, my question is, is there a way to GET AUTO FILTERS on a report in SQL RS 2000. Pl advise.
Thanks.
Adding auto-filters to Excel worksheets is not currently supported by the Excel renderer.
You'll have to add the auto-filters after the workbook is exported from RS.
-Chris
Hi Chirs,
Thanks very much for the reply. But the dilemma is that the users dont want the report rendered in Excel anymore. I am still going to render the report as a web link. Are there any options to add auto-filters to the report in SQL RS. Because xporting in Excel will not be in an option for me. Any input will be appreciated. Thanks.
