Reporting Services 2005 - Problems displaying a report via a ReportViewer control.

I have a report that displays fine in VS 2005 (in the Preview tab), and if I hit it via a URL in IE as a deployed report. However, when I embed it in a ReportViewer control for display on a web site, I get no data back for the report. I am using an Oracle database for the data source. None of the the logs in reporting services show anything wrong, there are no events in the event viewer to indicate any problems, Oracle logs also show no problems and no errors are returned to the page when the "View Report" button is clicked.

Anyone out there have a clue? I certainly don't.

Mike

The web site is executing the report viewer control with a certain (ASP.NET) user context. Most likely this account does not have any permissions to access the installation of the Oracle client software (or the Oracle client software is not installed at all on the web server).

Check this KB article for more details how to configure directory security: http://support.microsoft.com/?kbid=870668

-- Robert

|||

I thought the same thing at first, but permissions checked out fine. I found out that the problem is a rather esoteric interaction of Div and Table HTML element display characteristics during report generation (at least that's what the MSDN article says at http://msdn2.microsoft.com/en-us/library/ms252090.aspx).

The gist of it is that when you have the ReportViewer control properties set to render Asynchronously and have the height set to a '%' value (I was using 100%), the calculated height passed in the HTML is set to '0' so no report displays. You have the choice of using a fixed height and Asynchronous rendering or a percentage height and synchronous rendering.

Mike

|||

Thanks for posting your findings!

-- Robert

sql

Reporting Services

Authentication via internet explorer fails when connecting to reporting
services from a hostname other then the NETBIOS name.
for example my servers name is BOB
so if i do http://bob/ReportServer it works fine
I have an A record that points reportingservices.mydomain.com to BOB's ip
address
so if i go to http://reportingservices.mydomain.com/ReportServer I get the
user credentials box. How can I fix this?On Mar 2, 9:06 pm, Nick T <N...@.discussions.microsoft.com> wrote:
> Authentication via internet explorer fails when connecting to reporting
> services from a hostname other then the NETBIOS name.
> for example my servers name is BOB
> so if i dohttp://bob/ReportServerit works fine
> I have an A record that points reportingservices.mydomain.com to BOB's ip
> address
> so if i go tohttp://reportingservices.mydomain.com/ReportServerI get the
> user credentials box. How can I fix this?
It seems like you should check the authentication methods of the
virtual directory pointed to in IIS for http://reportingservices.mydomain.com/ReportServer.
Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||The virtual directory is just part of the default web site
"EMartinez" wrote:
> On Mar 2, 9:06 pm, Nick T <N...@.discussions.microsoft.com> wrote:
> > Authentication via internet explorer fails when connecting to reporting
> > services from a hostname other then the NETBIOS name.
> >
> > for example my servers name is BOB
> >
> > so if i dohttp://bob/ReportServerit works fine
> >
> > I have an A record that points reportingservices.mydomain.com to BOB's ip
> > address
> >
> > so if i go tohttp://reportingservices.mydomain.com/ReportServerI get the
> > user credentials box. How can I fix this?
> It seems like you should check the authentication methods of the
> virtual directory pointed to in IIS for http://reportingservices.mydomain.com/ReportServer.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>|||Hello,
I think this situation depends on security settings in IE.
Try to add http://reportingservices.mydomain.com/ website to your trusted
websites.
If still you 'll be prompted for login and password check security settings
in IE (for trusted sites).
Ensure that you have checked the last option for logging user (logging with
current user name and password).
I hope this will help.
Best regards,
Rados³aw £ebkowski
U¿ytkownik "Nick T" <NickT@.discussions.microsoft.com> napisa³ w wiadomo¶ci
news:2821371F-75FC-4BC7-A0E0-B7B01A512874@.microsoft.com...
> Authentication via internet explorer fails when connecting to reporting
> services from a hostname other then the NETBIOS name.
> for example my servers name is BOB
> so if i do http://bob/ReportServer it works fine
> I have an A record that points reportingservices.mydomain.com to BOB's ip
> address
> so if i go to http://reportingservices.mydomain.com/ReportServer I get the
> user credentials box. How can I fix this?

Reporting Service on NLB and Virtual Servers

Trying to get reporting Services to work under a Virtual Server that is NLB.
I can access the reports manager and Reports via the Default Web and basic
reports via the virtual server. The problem I cannot access the reports if it
requires a param specified by the user. It fails with a browser DNS error.
Does any know how to make this work. Like I said prior non-param, reports are
working fine. The error only happens with Param reports.
IE: Http://<Virtual IP>/ReportServer?/<Reports Folder>/<Report
Folder>/<report Name>
Another weird thing is this works in our test environment without NLB.Actually after some more investigation I've figured out what was causing the
below mention problem but now something else is weird.
Okay so here is the weird thing. I have created the VDirectories under my
site since we do not use the Default Web Site like most people. Anyway, The
problem I'm having is if I view the VDir on the site Http://<Ip
address>/reportserver I get a cannot connect error "cannot find server
....". The weird thing is if I change the ip address to All Unassigned for
the Site it works fine. Of course this is not acceptable either.
I haven't been able to find anything in regards to what might be causing
this.. Does anyone have a idea?
"James" wrote:
> Trying to get reporting Services to work under a Virtual Server that is NLB.
> I can access the reports manager and Reports via the Default Web and basic
> reports via the virtual server. The problem I cannot access the reports if it
> requires a param specified by the user. It fails with a browser DNS error.
> Does any know how to make this work. Like I said prior non-param, reports are
> working fine. The error only happens with Param reports.
> IE: Http://<Virtual IP>/ReportServer?/<Reports Folder>/<Report
> Folder>/<report Name>
> Another weird thing is this works in our test environment without NLB.

reporting service database name

Hi,
Is there a way to find out(via table lookup) which database in an
given instance serves as a reporter database?.
More specifically, i need to report on some reprots and i do not want to
check every database in an instance to find out which one is used by
reporting services.
regards
-sarab> Is there a way to find out(via table lookup) which database in an
> given instance serves as a reporter database?.
> More specifically, i need to report on some reprots and i do not want to
> check every database in an instance to find out which one is used by
> reporting services.
In Query Analyzer, use
EXEC sp_who2
and check the DBName column in the row where the ProgramName coumn has value
'Report Server'. Use the lowest SPID value if there are more rows with
identical info (lower SPID=ServerProcess ID means earlier connection;
services should be faster when connectiong to SQL Server than regular
users).
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||Additionally, you can use WMI to get all configuration settigs. Sample code
is in RS BOL, here is the MSDN link:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_wmi_4aci.asp.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:eRdZ%23l2sEHA.4040@.TK2MSFTNGP09.phx.gbl...
> > Is there a way to find out(via table lookup) which database in an
> > given instance serves as a reporter database?.
> >
> > More specifically, i need to report on some reprots and i do not want to
> > check every database in an instance to find out which one is used by
> > reporting services.
> In Query Analyzer, use
> EXEC sp_who2
> and check the DBName column in the row where the ProgramName coumn has
value
> 'Report Server'. Use the lowest SPID value if there are more rows with
> identical info (lower SPID=ServerProcess ID means earlier connection;
> services should be faster when connectiong to SQL Server than regular
> users).
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>

Reporting Items Toolbox

I am new to reporting services. Just installed the BI Dev Studio onto my SQL 05 machine. Everything is working fine. I can via the wizard create a basic report that connect to a SQL data store, runs a query, renders etc.

My problem - the BI Studio will not give me anything active in the toolbox. If I pull up the toolbox it shows me the general tab and that's it. If I do a 'show all' on the toolbox it will show me all available tabs in VS...including the one I want 'Report Items'. However all controls in the Report Items (pointer, textbox, line, table, matrix, etc.) are grayed out. As far as I can tell this means I would have to directly change the RDL in order to customize my report. I feel like I am missing something basic here.

Thanks in advanced for any insight.

Basic to say the least...Took me a couple hours for me to decide I might need to look around and install additional components from the install disc...which made me decide to close my BI Studio....which promptly asked me if I wanted to stop debugging...which prompted me to scream.

Not sure how debug started running in the first place I would have never thought to run debug on RDL. Anyway lame post. Sorry.