We help IT Professionals succeed at work.

SSRS 2008 Export to Excel using subreports loses data in Excel Filter

I am using SSRS 2008 and I have a report with 2 subreports.  The export to Excel works great, but when I view the data in excel, I add a filter to the top header row and when I try to filter the data by selecting the drop-down on a column, no data is shown in the filter.  If I run either of the reports (that are sub-reports) directly (without them being a sub-report), the filter works just fine when I export to Excel.

 
Comment
Watch Question

Commented:
i guess its a format issue u are facing!
if the cells are having numbers then u cannot filter with a condition like "begins with 123" etc....

what kinda filter are u applying........equal, contains??

a sample file would be really helpful of when the filter works and when it doesnt.


Tils.

Author

Commented:
I have attached 3 files.  "FilterWorks.xls", "FilterNoWorkie.xls" and "ScreenShots.doc"

FilterWorks.xls is from the report that is normally used as a sub-report, but I ran it by itself to show that filtering works fine when not used as a subreport.

FilterNoWorkie.xls is from my report that uses sub-reports and where the filter is not working.  You will need to look at the worksheet named "sheet7".

ScreenShots.doc has screen shots showing what I mean when I say the filtering is not working
FilterNoWorkie.xls
FilterWorks.xls
ScreenShots.doc

Commented:
there seems some problem, im unable to download your "FilterNoWorkie" file........ can u zip and add..
and i might be off in some time so may not be able to reply immediately.

Author

Commented:
here is a ZIP file of all 3 files
Issue.zip

Commented:
there is no "FilterNoWorkie" in your zip!!

Author

Commented:
try again - my bad
HereAreAllTheFiles-TrustME.zip
Commented:
check this out........its working now.
i jus removed the filter and applied it again. (no need to select the entire column before clicking on "autofilter")



Cheers,
Tils.
it-works---.zip

Commented:
*entire row*........ i meant and not *entire column*

Author

Commented:
That is awesome!  Thanks for the solution... that was a weird one :-)