{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 Juvenile、少年° 的问题《The row item structure object corresponding to a l》','https://www.manongdao.com/q-739877.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
I am very new to SSRS and am trying to generate a report using SSRS, I am able to pull the data on to the screen without any issues but when I try to export the data to an excel file, I am getting an error "The row item structure object corresponding to a line cannot be null" when there is data that spans multiple tabs in an excel. I am able to export to any other formats eg: PDF. After some googling I found that there is an issue with the SQL Server reporting version and Microsoft mentioned that they will release a patch to fix this issue but I dont see that there was any patch. I am using SQL Server Reporting Services Version 2007.0100.2531.00. Any pointers will be of great help.
相关问题
- Why does SSRS need to recycle the application doma
- Use multiple ReportItems in one expression in RDLC
- How to delete old subscriptions
- QUERY method of Soap request for SSRS and WCF test
- SSL/wallet error trying to access Oracle DB from S
相关文章
- SQL Server Reporting Services - Set default value
- Get list of reports from SSRS?
- SSRS tablix column CanGrow property for width?
- The report server cannot process the report or sha
- SSRS 2008 report not working with using a stored p
- Dataset with dynamic columns in tablix/matrix
- Bulk uploading images to SSRS
- SQL Server Reporting Services url parameters not w
The bug seems to appear every time you try to render completely empty pages (height = 0) in Excel. The problem is still there in SQL Server 2008R2 Reports, the Microsoft Connect Ticket mentioned by Peter is still active.
In my case I had a report with a single Tablix and no page breaks, no space on any side, so that no additional rows or columns would be created in Excel exports. When the report returns no rows and is rendered to Excel the stated error appears, so I added a new empty row with the visibility condition "=CountRows() > 0" and it works.
Depending on the version of SSRS you're using, it might be the problem described in this post on Microsoft Connect, which should be fixed in later versions of SSRS.
Also, it can be something with page breaks, or, as in my case, matrixes without data. When I hid the matrix without data (with
=CountRows("MyDataSet") = 0), the problem was solved.I have found the solution for the above issue, please don't provide the page break to table. Do one thing: put the table in to the rectangle and provide page break to rectangle. It worked for me.
If you have group in report then track below changes.
Right click Row group
Group Properties
Page Breaks
Remove checkbox from Also at the start of a group
Remove checkbox from Also at the end of a group
OK