Home Dashboard Directory Help
Search

SSRS 2008 & 2012 Some data not rendered when subreport is nested, but render to PDF works OK by Alan Schofield


Status: 

Resolved
 as Won't Fix Help for as Won't Fix


1
0
Sign in
to vote
Type: Bug
ID: 775967
Opened: 1/7/2013 6:05:19 AM
Access Restriction: Public
0
Workaround(s)
view
1
User(s) can reproduce this bug

Description

The following issue shows in both our production environment (VS2008 and SQL2008 (not R2)) and my test environment (VS2010 and SQL 2012 dev edition). The issue is also present when running reports from the SSRS Server once deployed.

I have a series of sub reports which are nested up to about 4 levels deep.

The subreports are generally called from other sub reports which loop thru data repeating the report for each row found. For exmplae we have a 3 level category structure for product data. Umbrella/Super/Category.
A report will but run by the user for an Umbrella category, this will produce a report that contains a sub report for each relevant super category which in turn contains a report for each relevant category.

If I run the problem report on it's own, it runs fine, if I run the report nested 1 level from Visual Studio it works OK, at 2 levels deep the problem appears. Running the deployed report from the SSRS Server fails sometimes even at a single level of nesting.

Basically what happens is that the top row (column headers) render OK but the first row of data sometimes has the first cell blank. If I run the report, the un-rendered data is consistent (ie. the error shows i the same place every time, the same iteration of the subreport render). In one test I carried out, the sub-report is called 18 times within a single report, but only 4 times does it fail.

I know it's not a data issue as such as if I render to PDF it works perfectly, but rendering to screen, MHTML, XLS, XLSX, DOC, DOCX all show the same problem.


Data, RDL's etc can be supplied if required.

Some screenshots are attached showing output to 4 different renderers. PDF shows the output correctly, the others do not.
Details
Sign in to post a comment.
Posted by Microsoft on 10/31/2013 at 4:54 PM
Hello,
Thank you for submitting this feedback. After carefully evaluating all of the bugs in our pipeline, we are closing bugs that we will not fix in the current or future versions of SQL Server. The reasons for closing these bugs are following:
1.     The fix is risky to implement in the current version of the product (service packs)
2.     Scenarios reported in the bug are not common enough
3.     A viable workaround is available

If the issue is a critical business interruption, please call CSS (Customer Support Services).

Thanks again for reporting the product issue and continued support in improving our product.

Mariusz Cichomski
Program Manager, Microsoft | SQL
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
Word.PNG 1/7/2013 24 KB
XLSX.PNG 1/7/2013 24 KB
PDF.PNG 1/7/2013 52 KB
Screen.PNG 1/7/2013 25 KB