RDLC SubReports Exporting to Excel Are Ignored
rdlc导出Excel时 如果报表嵌套了子报表 则在导出的excel表中 子报表区域显示‘忽略表/矩阵单元内的数据区域。’ 这是什么原因?
===========
单元格内嵌套的表格不能导出。如果作表头的话,可以不用嵌套的表格处理。如果是数据...那么建议不使用rdlc报表,特殊的报表自己写导出Excel的功能了,rdlc导出的Excel很难看
===========
出现这样的问题:
1.导出要是纯数据还行,不会出错(会都导出数据)
2.导出要是带表头的,那只能看你的细心去设置个细节的字段格子。
不过,导出还是要自己用手工画线的。(因为水晶报表是用各边框的线合起来格子)
===========
I have a RDLC report which has a table, calling a subreport N times. This works perfectly in the control viewer and when I export to PDF. Yet when I export to Excel, I get the following error:
Subreports within table/matrix cells are ignored.
===========
See MSDN forum link below...looks like this is not supported in 2000/2005, but there also seem to be some kludgey workarounds (nested lists). A Microsoft moderator claims that reporting services 2008 will export everything.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1520229&SiteID=1
===========
微软报表rdlc如果有一个单元格的数据超过一行,那在系统里面(Web)显示是正常的,会自动换行,但是导出excel单元格却不会自动换行,
必须在excel手动进行单元格高的拉大,才能看第二行的数据.
===========