Thursday, August 16, 2007

SQL Reporting Services

I had a report that looked great in the browser but showed this error when exported to Excel:
"Subreports within table/matrix cells are ignored."

It's a limitation with the software. I removed the table and put my Fields and sub reports in a List control. I set the datasource and grouping properties for the List control and everything works fine now.