?
Solved

SSRS using ReportViewer not rendering if it has a sub report on it

Posted on 2016-09-13
11
Medium Priority
?
93 Views
Last Modified: 2016-09-24
I have a Parent report and a child report. Each individually function correctly when 2 parameters are passed to it. Unfortunately when I put the child report (subreport) nested or not nested on the parent it doesn't render. Any ideas?

 I have even put a plain form as the subreport... nothing but a header and it still will NOT render the parent.

Please help
0
Comment
Question by:Steve MacWilliams
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
  • 2
11 Comments
 
LVL 16

Expert Comment

by:Megan Brooks
ID: 41797280
What is it that is not rendering? The title seems to say that the report, both parent & subreport, doesn't render at all when the subreport is present. In your question, however, you seem to possibly be saying that the subreport doesn't render when added to the parent report. The phrase "it doesn't render" at the end of the question can be read in more than one way, depending on what "it" represents. Please clarify.
0
 
LVL 14

Expert Comment

by:Nakul Vachhrajani
ID: 41797311
Also - where is it not rendering? Does it render as expected in BIDS/SSDT and ReportBuilder? Or does it not render when viewed within a report viewer that is embedded into a WinForms or a Web application?

If the issue in on the report viewer, try exporting the report (Save As icon). I have seen instances where the body may not render properly on screen (some UI elements may be entirely missing), but when exported to PDF or Excel, everything is exported properly - indicating an environmental issue.

Finally, do you have data being pulled for the child report (you can verify if the query for the appropriate data set is fired or not using Profiler/Extended Events)?
0
 

Author Comment

by:Steve MacWilliams
ID: 41797568
Thank you. Let me clarify.
Within Visual Studio where I develop the report and sub-report the both render and they work perfect in BIDS/SSDT.

However when this is in production.  NIETHER the report NOR the sub-report render.  It is accessed/viewed via a url something like .../reports/ReportViewer.aspx?rptName=ReportName

In Production:
I have troubleshot by removing the sub-report from the parent and then the parent will render.
I then also create a separate 'link' to the sub report and it too will also render.

I am going to reinstall SSMS... I couldn't find profiler
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

Author Comment

by:Steve MacWilliams
ID: 41797737
Just as a FYI...
As another part of testing I recreated from scratch and in production it didn't render.
0
 
LVL 16

Expert Comment

by:Megan Brooks
ID: 41798272
Do you have a development server, or are you only testing in production? Do you have Windows admin access to a report server on which the problem is occurring, so that you can look at the Report Server logfiles? Do you have SELECT access for tables and views in the Report Server temp DB?

Are the subreport parameters simple ones, no available value lists, no defaults (or at least no defaults that are actually used)? Do the values supplied match the parameter data types?
0
 
LVL 14

Assisted Solution

by:Nakul Vachhrajani
Nakul Vachhrajani earned 1000 total points
ID: 41798470
A couple of things - the report renders fine in Visual Studio. Can you deploy it to your development SSRS server and render from there using the Report Manager (typically, http://<ServerName>/Reports)? If the report renders in development, but not in production when accessed from the reporting server, it will help us confirm whether or not this is an environmental issue.

On the sub-report, can you try creating an extremely simple sub-report that only has maybe a textbox with some static text only (no header, footer, tablix or any other component)? That way, we can confirm that there are no issues with respect to sub-report display configuration.

Once this works, confirm that you are passing the correct parameters to the correct database (the production report is not pointing to the development instance) and that parameters from the parent report are mapped correctly to the child report.
0
 

Author Comment

by:Steve MacWilliams
ID: 41798862
Megan
Do you have a development server, or are you only testing in production?  
Only testing in production

Do you have Windows admin access to a report server on which the problem is occurring, so that you can look at the Report Server logfiles?
No errors in log

Do you have SELECT access for tables and views in the Report Server temp DB?
Please explain, but yes I can query those tables

 Are the subreport parameters simple ones, no available value lists, no defaults (or at least no defaults that are actually used)?
Yes the are simple. No default values, but tried both ways

Do the values supplied match the parameter data types?
Yes
0
 

Author Comment

by:Steve MacWilliams
ID: 41798873
Nakul
A couple of things - the report renders fine in Visual Studio. Can you deploy it to your development SSRS server and render from there using the Report Manager (typically, http://<ServerName>/Reports)?
I can access the Report Manager. At a previous job I was able to click on the report and it would work. In this instance, I get the following error:

The report server has encountered a configuration error. Logon failed for the unattended execution account. (rsServerConfigurationError)
Log on failed. Ensure the user name and password are correct. (rsLogonFailed)
For more information about this error navigate to the report server on the local server machine, or enable remote errors



 On the sub-report, can you try creating an extremely simple sub-report that only has maybe a textbox with some static text only (no header, footer, tablix or any other component)? That way, we can confirm that there are no issues with respect to sub-report display configuration.
I had already tried this same non-rendering results
0
 
LVL 16

Assisted Solution

by:Megan Brooks
Megan Brooks earned 1000 total points
ID: 41798905
The unattended execution account is only used for certain types of connections. It is not unusual for it to be left unassigned, and if your report does something that requires it, report execution will fail the way you described above. Image file retrieval is one common use; there are others. A blog post that describes the various ways it is used can be found here.

Unless the use of the unattended execution account is accidental, you will need to configure it to eliminate that error, using the Reporting Services Configuration Manager.
1
 

Accepted Solution

by:
Steve MacWilliams earned 0 total points
ID: 41804598
That for trying experts. I found that by adding a default value the report was able to run.
0
 

Author Closing Comment

by:Steve MacWilliams
ID: 41813598
My solution resolved the problem.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question