Solved

Subreport error SSRS 2008

Posted on 2009-05-11
2
1,133 Views
Last Modified: 2012-05-06
Hi Experts,

I have a main report with two subreports. I have code that hides a subreport if no data is present. There will never be data for both subreports at any one time. The report works perfectly if one or other subreports are on the main report, but returns an error if both are present. Both share the same parent record from the main form as a single parameter.

Error message is:

"An error occurred during local report processing.
Object reference not set to an instance of an object."

What is the issue here?


Kelvin
0
Comment
Question by:Kelvin Sparks
2 Comments
 
LVL 46

Expert Comment

by:tbsgadi
Comment Utility
Might be something to do with the cache data setting.
0
 
LVL 22

Accepted Solution

by:
Kelvin Sparks earned 0 total points
Comment Utility
Ended up being an issue with an expression to determine which was hidden.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how the fundamental information of how to create a table.

728 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now