Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yavvie
Starting Member
46 Posts |
 Posted - 2009-06-23 : 10:37:10
|
| I created two reports, both of them use one subreport implemented in their matrixes. One report works fine, the other one (since I added the subreport) throws an error.chunks!ReportServer_0-18!1288!06/23/2009-15:59:33:: w WARN: Rolling back shared chunk transaction for snapshot '3640d163-4c7b-4fe4-9022-cffb6240f52d', Permanent=False.library!ReportServer_0-18!1288!06/23/2009-15:59:33:: w WARN: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.NullReferenceException: Object reference not set to an instance of an object.webserver!ReportServer_0-18!1288!06/23/2009-15:59:33:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.NullReferenceException: Object reference not set to an instance of an object.When I delete the subreport from main report it works, when I add it again it fails.Subreport itself works fine.I tracked requests to my source procedure - the report calls also the subreport procedure for about half of its data, then it fails.Next I tried providing a ID parameter to the report and thus getting only one row of data - fails again.Tried calling the subreport using fixed value for parameter instead of cell value from the data source - failed.Tried calling the subreport without any parameters and setting them on the subreport itself - failed. (calling just the subreport with those fixed values was OK)I'm out of ideas what else to try and I really don't feel like creating the main report again :(Thanx for any help.I'm running on SQL 2008, reporting services 2008, windows server 2003. (Its the test server so I can't try it anywhere else.) |
|
|
yavvie
Starting Member
46 Posts |
Posted - 2009-06-24 : 04:44:19
|
| I have the solution... however stupid it isI found out that i cannot have subreport AND drillthrough at the same timeI changed the matrix properties and deleted from "Display can be toggled by this report item:" from the detail group properties and the subreport suddenly worked okay. When I put the drillthrough back it gave me the error again.So i'm goin to report to Micro and put here what they reply if they reply :) |
 |
|
|
|
|
|
NullReferenceException