Report Object Model?

Hi
I am looking for an object model to learn how to access report items an
conections (if available?) in code. Because the code window on report
properties is THAT programmer-friendly I have no idea where to start
accessing the items.
Thanks.
MarkusThe code window you are refering is used for writing small functions to be
used inside the report something like converting Dollar to pounds etc.
If for using connection and report items or anyother things, I suggest use
the RS web services, there are good samples available in SS online help to
start with.
Amarnath, MCTS
"MarkusPoehler" wrote:
> Hi
> I am looking for an object model to learn how to access report items an
> conections (if available?) in code. Because the code window on report
> properties is THAT programmer-friendly I have no idea where to start
> accessing the items.
> Thanks.
> Markus

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 Manager error

I am able to view reports by navigating directly to /ReportServer however the
report manager (/Reports/Home.aspx) gives the following:
ERROR.
Object reference not set to an instance of an object.
No other info is provided. I'm using SSL and RS SP2 is installed, SQL has
SP4. I've looked in the Reporting Services Log files but I don't see
anything there to help trap this error.
What "object" might this be? Any ideas about how to debug this?
Thanks,
Jeff Munson
University of WashingtonMaybe this will help someone?
When I hit https://localhost/SQLReports/Pages/Folder.aspx from the web
server itself and view source here is what's displayed in the HEAD tag:
(Note that the virtual directories are actually SQLReports and
SQLReportServer - this wasn't how I labelled them in my first post)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD> <script language="JScript" type="text/Javascript"
src="/SQLReports/js/ReportingServices.js"></script>
<TITLE>Report Manager</TITLE>
<link href="http://links.10026.com/?link=/SQLReports/styles/ReportingServices.css"type="text/css"
rel="stylesheet">
<META Name='Generator' CONTENT='Microsoft SQL Server Report Manager
8.00.1038.00'>
<META Name='Report Server' CONTENT='http://MYDOMAIN/SQLReportServer'>
<META Name='StackTrace' CONTENT='System.NullReferenceException: Object
reference not set to an instance of an object.
at
Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetReportServerAuthentication()
at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetWebRequest(Uri
uri)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at
Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
methodname)
at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain()'>
"JMunson" wrote:
> I am able to view reports by navigating directly to /ReportServer however the
> report manager (/Reports/Home.aspx) gives the following:
> ERROR.
> Object reference not set to an instance of an object.
> No other info is provided. I'm using SSL and RS SP2 is installed, SQL has
> SP4. I've looked in the Reporting Services Log files but I don't see
> anything there to help trap this error.
> What "object" might this be? Any ideas about how to debug this?
> Thanks,
> Jeff Munson
> University of Washington

Report loses all data !

Hi,
I have a reportviewer object on an asp.net page.
On this page (not in the reportviewer object) is also a button which pops up
a new window with a pdf document when clicked.
The report loads fine with all the info I want, when I refresh the page or
the report itself the information is still ok.
But as soon as I press the button for the pdf document, the document opens
fine, but it pops-up UNDER the other page, AND the reportviewer object LOSES
ALL DATA and displays this dreaded message : "To render a report, enter the
serverUrl and ReportPath."Eric,
I don't know a lot about ASP web pages, but I've got a notion that I thought
I'd share. As far as the PDF showing up under the webpage, it sounds like
the code for the PDF button doesn't have the Focus properties set properly.
You or your developer should check out that button code and make sure that
when clicked, it switches the focus from the current webpage to the new PDF
page.
As far as losing the data from the ASP page... I would say that is a code
issue with the button functionality too, rather than a Reporting Services
issue, but again, I don't know ASP, so I can't tell you exactly what the
problem is.
Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"Eric" wrote:
> Hi,
> I have a reportviewer object on an asp.net page.
> On this page (not in the reportviewer object) is also a button which pops up
> a new window with a pdf document when clicked.
> The report loads fine with all the info I want, when I refresh the page or
> the report itself the information is still ok.
> But as soon as I press the button for the pdf document, the document opens
> fine, but it pops-up UNDER the other page, AND the reportviewer object LOSES
> ALL DATA and displays this dreaded message : "To render a report, enter the
> serverUrl and ReportPath."|||Yeah I dont know much about ASP pages either, that is the problem :p
I tried using window.focus on my java script to put focus on the pdf page
when it opens, but that code is ignored. In the ASP newsgroup they suggest I
use window.modalDialog but that window cannot be reduced.
As for the report reloading with empty parameters, I temporarily countered
the problem by reloading the report after the button is clicked. But that is
a lame correction since the report reloads with default data and doesnt keep
its current state.
In a nutshell, im still at square one.
"Catadmin" wrote:
> Eric,
> I don't know a lot about ASP web pages, but I've got a notion that I thought
> I'd share. As far as the PDF showing up under the webpage, it sounds like
> the code for the PDF button doesn't have the Focus properties set properly.
> You or your developer should check out that button code and make sure that
> when clicked, it switches the focus from the current webpage to the new PDF
> page.
> As far as losing the data from the ASP page... I would say that is a code
> issue with the button functionality too, rather than a Reporting Services
> issue, but again, I don't know ASP, so I can't tell you exactly what the
> problem is.
> Catadmin
> --
> MCDBA, MCSA
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the back?
> @.=)
>
> "Eric" wrote:
> > Hi,
> >
> > I have a reportviewer object on an asp.net page.
> > On this page (not in the reportviewer object) is also a button which pops up
> > a new window with a pdf document when clicked.
> >
> > The report loads fine with all the info I want, when I refresh the page or
> > the report itself the information is still ok.
> >
> > But as soon as I press the button for the pdf document, the document opens
> > fine, but it pops-up UNDER the other page, AND the reportviewer object LOSES
> > ALL DATA and displays this dreaded message : "To render a report, enter the
> > serverUrl and ReportPath."

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