all groups > sql server reporting services > april 2007 >
You're in the

sql server reporting services

group:

NullReferenceException


NullReferenceException jcmag
4/4/2007 11:24:12 AM
sql server reporting services:
I have a report with a chart and a textbox. I use the 'navigation'
property of the textbox to jump to another report. When my request
returns an empty dataset I have the following exception:

[1580] w3wp!library!1!04/04/2007-20:16:26:: i INFO: Call to
RenderFirst( '/Reporting/ReportProjects' )
[1580] w3wp!processing!1!04/04/2007-20:16:26:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
An unexpected error occurred in Report Processing., ;
[1580] Info:
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
An unexpected error occurred in Report Processing. --->
System.NullReferenceException: Object reference not set to an instance
of an object.
[1580] at
Microsoft.ReportingServices.ReportProcessing.ReportObjectModel.FieldsImpl.ResetUsedInExpression()
[1580] at
Microsoft.ReportingServices.ReportProcessing.Action.ResetObjectModelForDrillthroughContext(ObjectModelImpl
objectModel, IActionOwner actionOwner)
[1580] at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeRICollection.CreateTextBoxInstance(TextBox
textBox, ProcessingContext processingContext, Int32 index, IScope
containingScope)
[1580] at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeRICollection.CreateInstance(ReportItem
reportItem, Boolean setupEnvironment, Int32 index)
[1580] at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeRICollection.CreateInstances(ReportItemColInstance
collectionInstance, ReportItemCollection reportItemsDef)
[1580] at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.Merge.CreateInstances(ParameterInfoCollection
parameters, Boolean noRows)
[1580] at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.Merge.Process(ParameterInfoCollection
parameters, Boolean mergeTran)
[1580] at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report
report, ProcessingContext pc, ProcessingContext context)
[1580] at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report
report, ProcessingContext pc, Boolean snapshotProcessing, Boolean
processWithCachedData, GetReportChunk getChunkCallback, ErrorContext
errorContext, DateTime executionTime, CreateReportChunk
cacheDataCallback, ProcessingContext& context)
[1580] at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension
renderer, DateTime executionTimeStamp, GetReportChunk
getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext
rc, CreateReportChunk cacheDataCallback, Boolean& dataCached)
[1580] --- End of inner exception stack trace ---


If I remove the textbox, all is fine (nothing is displayed)
Any idea ?
Re: NullReferenceException EMartinez
4/5/2007 5:42:09 AM
[quoted text, click to view]


Have you tried to include a dummy default single resultset and in the
main report filter that resultset out?

Enrique Martinez
Sr. Software Consultant
Re: NullReferenceException jcmag
4/5/2007 7:21:58 AM
[quoted text, click to view]

sorry but I don't understand what do you want me to do...
AddThis Social Bookmark Button