Showing posts with label ctp. Show all posts
Showing posts with label ctp. Show all posts

Friday, March 30, 2012

Problems with the Web ReportViewer Control

Problems with the Web ReportViewer Control

I'm using SQL Server 2005 Reporting Services Sept CTP and Visual Studio 2005 RC to develop an ASP.NET application. On one of my web forms I have placed the web ReportViewer control so that I can display reports from Reporting Services.

The .aspx code is:

<%@. Page Language="C#" AutoEventWireup="true" CodeFile="ReportViewer.aspx.cs" Inherits="ReportViewer" %>

<%@. Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >

<head runat="server">

<title>ReportViewer</title>

</head>

<body>

<form id="formReportViewer" runat="server">

<div>

<asp:Panel ID="PanelDisplayReport" runat="server" Height="100%" Width="100%">

<rsweb:reportviewer id="ReportViewerDisplayReport" runat="server" bordercolor="Navy" borderstyle="Solid" borderwidth="1px" height="100%" tooltip="Display Report" width="100%" Font-Names="Verdana" Font-Size="8pt" ProcessingMode="Remote">

</rsweb:reportviewer>

</asp:Panel>

</div>

</form>

</body>

</html>

The .aspx code-behind (in C#) is:

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

public partial class ReportViewer : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

this.ReportViewerDisplayReport.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;

this.ReportViewerDisplayReport.ToolTip = "/AdventureWorks Sample Reports/Company Sales";

this.ReportViewerDisplayReport.ZoomPercent = 90;

this.ReportViewerDisplayReport.ServerReport.DisplayName = "/AdventureWorks Sample Reports/Company Sales";

this.ReportViewerDisplayReport.ServerReport.ReportPath = @."/AdventureWorks Sample Reports/Company Sales";

this.ReportViewerDisplayReport.ServerReport.ReportServerUrl = new Uri(@."http://localhost/ReportServer");

}

}

As you can see, this is a very simply web form that is simply trying to display one of the reports from the AdventureWorks sample database and reports.

The problem is that the report will not display in the ReportViewer control. When I request the page, I see the ReportViewer's toolbar but not the actual report. I initially see the "Report is being generated" message in the control, where the report would normally be displayed. But, after the report is generated, no report, just the toolbar.

Anyway, does any one have any suggestions as to what's wrong?

Is there a bug in the ReportViewer control (for web forms) in Visual Studio 2005 RC?

Anything else???

Thanks in advance.


The problem is that height is set to 100% and doctype is set to XHTML. Either set the height to a fixed size (not a percent) or remove the line that sets doctype to XHTML.|||Thanks for this. I spent a couple of hours on this, I could have spent many more.|||You can also fix this problem by rendering the report synchronously. The control displays the report differently based on the method of rendering and calculates the actual height on the fly. When rendered synchronously, the calculated height is 0px, so nothing shows.

Monday, March 26, 2012

Problems with sql 2005 ctp september installation

Well i installed the 2005 ctp september.
It went well but it didn't installed the RS
The error log was:
ReportingServicesService!library!8!02/10/2005-11:56:34:: i INFO: Catalog SQL
Server Edition = Developer
ReportingServicesService!library!8!02/10/2005-11:56:34:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException:
The version of the report server database is either in a format that is not
valid, or it cannot be read. The found version is 'C.0.6.43'. The expected
version is 'C.0.8.39'. To continue, update the version of the report server
database and verify access rights., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException:
The version of the report server database is either in a format that is not
valid, or it cannot be read. The found version is 'C.0.6.43'. The expected
version is 'C.0.8.39'. To continue, update the version of the report server
database and verify access rights.
ReportingServicesService!library!8!02/10/2005-11:56:34:: Exception caught
while starting service. Error:
Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException:
The version of the report server database is either in a format that is not
valid, or it cannot be read. The found version is 'C.0.6.43'. The expected
version is 'C.0.8.39'. To continue, update the version of the report server
database and verify access rights.
well the installation erased my sql server i don't have the old db any more!!!
any idea what 2 do?In trying to assess what your current situation may be it would be
useful to know what OS you are installing on and which components you
attempted to install. As background, had you had earlier builds of SQL
Server 2005 / Visual Studio 2005 on the machine?
Andrew Watt
MVP - InfoPath
On Sun, 9 Oct 2005 00:38:01 -0700, "'" <@.discussions.microsoft.com>
wrote:
>Well i installed the 2005 ctp september.
>It went well but it didn't installed the RS
>The error log was:
>ReportingServicesService!library!8!02/10/2005-11:56:34:: i INFO: Catalog SQL
>Server Edition = Developer
>ReportingServicesService!library!8!02/10/2005-11:56:34:: e ERROR: Throwing
>Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException:
>The version of the report server database is either in a format that is not
>valid, or it cannot be read. The found version is 'C.0.6.43'. The expected
>version is 'C.0.8.39'. To continue, update the version of the report server
>database and verify access rights., ;
> Info:
>Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException:
>The version of the report server database is either in a format that is not
>valid, or it cannot be read. The found version is 'C.0.6.43'. The expected
>version is 'C.0.8.39'. To continue, update the version of the report server
>database and verify access rights.
>ReportingServicesService!library!8!02/10/2005-11:56:34:: Exception caught
>while starting service. Error:
>Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException:
>The version of the report server database is either in a format that is not
>valid, or it cannot be read. The found version is 'C.0.6.43'. The expected
>version is 'C.0.8.39'. To continue, update the version of the report server
>database and verify access rights.
>
>well the installation erased my sql server i don't have the old db any more!!!
>any idea what 2 do?|||Thanks for your reply (:
My OS is windows 2000 proffesional with sp4.
I try to install the DB & RS and thats all.
I installes the Express version and remove it by add/remove...|||Hi ',
I just upgraded from July to September this weekend....the only way to
do it that I found was to get rid of everything assocaited with SQL
Server including the underlying .net framework using the remove
programs control panel and then re-install...
It is a beta and you have to expect that nothing will be saved from one
drop to the next...as far as I am aware you cannot save your reporting
services databases betwenn different versions...it asked me to remove
them...it also even insisted on removing the virtual directories for
report services off my web server....
Hope this helps..
Peter
www.peternolan.com

Monday, February 20, 2012

Problems when I install SQL Express SP1 (CTP)

Hi All,

I have installed "SQL Server 2005 180 days evaluation" on Windows XP as default instance one month before. It runs fine.

However, today I try to install "SQL Express SP1 (CTP) - SQLEXPR_ADV.EXE" as a new instance name "SQLExpress", It prompt me that it could not install "SQL Server 2005 Management Studio Express" as existing "SQL Server 2005 Management Studio" already installed. So I have to install "SQLEXPR_ADV.EXE" but uncheck "SQL Server 2005 Management Studio Express". When setup has completed, I found the original "SQL Server 2005 Management Studio" is missing.

I try to re-install "SQL Server 2005 180 days evaluation" but it prompt me it is already installed, and cannot find "SSMS" option. Then I try to use "Add/Remove Programs" as control panel to Change "Microsoft SQL Server 2005", I still cannot find "SSMS" option.

Also, there is no another Start Menu folder for "SQL Express", but "Microsoft SQL Server 2005".

From the "SQL Server Configuration Manager" --> SQL Server 2005 Services, I found following instance running properly,

SQL Server Integration Services

SQL Server FullText Search (MSSQLSERVER)

SQL Server FullText Search (SQLEXPRESS)

SQL Server (SQLEXPRESS)

SQL Server (MSSQLSERVER)

SQL Server Analysis Services (MSSQLSERVER)

SQL Server Reporting Services (MSSQLSERVER)

SQL Server Reporting Services (SQLEXPRESS)

SQL Server Browser

SQL Server Agent (MSSQLSERVER)

When I install "SQL Express SP1 (CTP)", I have not change installation path, so it is default to the same path as "SQL Server 2005" at "%windir%\Program Files\Microsoft SQL Server\".

It seems that "SQL Server 2005 Express" overwrite the previous installation of "SQL Server 2005".

My question is how to install the previous "SQL Server 2005 Management Studio" rather than "SSMS Express".

I will be very appreciated to Any idea to my problem.

cheers,

Stanley Qian

Hi Stanley,

It is expected that SSMS and SSMSE do not run on the same computer. The problem here is related to SQL Server's Upgrade logic with regards to common tools such as SSMS and the fact that you are using Eval and Express Advanced.

I'm going to move this to the Setup forum since the Upgrade logic is their area. Go ahead and file an issue on this in the MSDN Product Feedback Center at http://go.microsoft.com/fwlink/?LinkId=51684.


Regards,

Mike Wachal
SQL Express team