Report Manager Error - Object reference not set to an instance of an object.

Hi,
I can browse to my ReportServer without a problem. But when I try to
browse to the Report Manager I get the following error - Object
reference not set to an instance of an object.
I checked the log file and I'm seeing the following (snippet)
Object reference not set to an instance of an object
at
Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetReportServerAuthentic= ation()
I'm Running SQL Server 2000 SP4
SQL Reporting Services 2000 SP1 (I know...)
This has been working fine up to know but suddenly seems to have broken
down. I've seen 2 other posts of this nature on google groups but
neither with a resolution.
Can anyone help me out please'
Thanks,
Gear=F3idok, I got it.
It was a default HTTP header in the root folder in IIS that was set
that caused this. Removed this and left it blank and it worked fine
for me.
Gear=F3id
Gear=F3id wrote:
> Hi,
> I can browse to my ReportServer without a problem. But when I try to
> browse to the Report Manager I get the following error - Object
> reference not set to an instance of an object.
> I checked the log file and I'm seeing the following (snippet)
> Object reference not set to an instance of an object
> at
> Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetReportServerAuthent=ication()
> I'm Running SQL Server 2000 SP4
> SQL Reporting Services 2000 SP1 (I know...)
> This has been working fine up to know but suddenly seems to have broken
> down. I've seen 2 other posts of this nature on google groups but
> neither with a resolution.
> > Can anyone help me out please'
> > Thanks,
> Gear=F3id

Report item expressions can only refer to other report items within the same grouping scope or a

I still don't get this. I want to reference another textbox. I've tried these expressions below and get the same error. For instance, I'm referencing this from textbox6. I've put the data in a group, doesn't work. How do I reference different reportitems? Thanks

=ReportItems!textbox15

=ReportItems!ThresholdIncome.value

=ReportItems!ThresholdIncome.value,"table1_Group1"

You should be able to reference textboxes in the same or a containing scope. This first expression would return you the textbox object. The second one should work if ThresholdIncome exists in the same or a containing scope. You can't explicitly specify the scope of a report item. Therefore the 3rd one wouldn't work. What error did you get with these expressions?|||

Fang - Thanks for your help. Error I'm getting is what is in the subject -

Report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope.

So does that mean I need to add a group and the textboxes can only know about each other in that group, but not any other textboxes on the report? That is what I don't understand. If it's all the same xml, why don't the controls know about each other?

|||You can refer to textboxes in that group, and the ones in the containing scope of that group (i.e. outer groups all the way up to the report level). But you can't refer to textboxes in an inner group. The reason is that when the report is rendered (combining layout information with data), there will be multiple instances of the inner groups. For example, if the outer grouping is by country and the inner grouping is by state, you'll get multiple states for USA. We wouldn't know from which inner group instance you want to get the textbox value.

Report instance

Dear All,

I want to create one report , and eache user use this reports can make instance of it with his choosen parameters , thanks to answer me how to do that

Regards

Try Reporting Services forum:

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1

Report GenerationObject reference not set to an instance of an object

I started a new thread as I was able to get more information on the error Im getting when I attempt to generate the report in report manager. Ive seen some solutions but nothing seems to work for my particular case. I am hopefull that this can be resolved "WITHOUT" ininstalling and reinstalling SSRS so any information would be helpful.

Here is the Soure Error and Stack Trace info:

Server Error in '/Reports' Application.

---

Object reference not set to an instance of an object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[NullReferenceException: Object reference not set to an instance of an object.]

Microsoft.Reporting.WebForms.WebRequestHelper.GetExceptionForMoreInformationNode(XmlNode moreInfo, XmlNamespaceManager namespaces) +18

Microsoft.Reporting.WebForms.WebRequestHelper.ExceptionFromWebResponse(Exception e) +358

Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension) +482

Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) +958

Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension) +84

Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +143

Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +75

System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154

System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

Hi,

Can you tell us what you are exactly trying to do, this way we can find out were you could be potentially going wrong...

Can you also look at your event log or the reporting services log files -this will give you more detail of the error caused...

One possible cause could be your connection and dataset, check these out.

Hope this helps.

|||

I can log into the report manager no problem-- its when I try to generate any report that I have this issue. The only thing that changed is I had to take the database offline for about a week and then brought it back online. All other permissions, roles etc have remained the same. When I try and generate the report I get the error in the middle of the screen and things are out of place -- print icon is where the report should be so is the refresh icon. I have included the info from the event viewer-- thanks in advance for any info that may help me avoid having to uninstall and reinstall ssrs

Event code: 3005

Event message: An unhandled exception has occurred.

Event time: 3/27/2007 8:48:19 AM

Event time (UTC): 3/27/2007 2:48:19 PM

Event ID: 68829be2d597449ca27166b54403c3a1

Event sequence: 2677

Event occurrence: 98

Event detail code: 0

Application information:

Application domain: /LM/W3SVC/1/root/Reports-2-128189799508346487

Trust level: RosettaMgr

Application Virtual Path: /Reports

Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportManager\

Machine name: HDSWEBK

Process information:

Process ID: 5360

Process name: w3wp.exe

Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:

Exception type: NullReferenceException

Exception message: Object reference not set to an instance of an object.

Request information:

Request URL: http://............./Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.2047.00

Request path: /Reports/Reserved.ReportViewerWebControl.axd

User host address: 128.138.29.6

User: AD\mcdermk

Is authenticated: True

Authentication Type: Negotiate

Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:

Thread ID: 6

Thread account name: NT AUTHORITY\NETWORK SERVICE

Is impersonating: True

Stack trace: at Microsoft.Reporting.WebForms.WebRequestHelper.GetExceptionForMoreInformationNode(XmlNode moreInfo, XmlNamespaceManager namespaces)

at Microsoft.Reporting.WebForms.WebRequestHelper.ExceptionFromWebResponse(Exception e)

at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)

at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)

at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)

at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)

at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Custom event details:

For more information, see Help and Support Center at