Friday, March 30, 2012

Reportviewer does not load properly in a content page

Hi all,

I have two (2) questions here:

1) I have a reportviewer control in an aspx page. It is remote access server report. Everything works fine from report server and in vs 2005. But Report does not load properly once put on a content page. The multi-value parameter dropdown list is not clickable! It worked in a non master/content page.

Here is my code for the page that does not work:

<%@. Page Language="C#" MasterPageFile="~/FysbReviewer.master" AutoEventWireup="true" CodeFile="ReportsMenu.aspx.cs" Inherits="ReportsMenu" Title="Report Menu" %><%@. Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<asp:Content ID="Content3" ContentPlaceHolderID="ContentPlaceHolder3" Runat="Server">

<rsweb:ReportViewer ID="ReportViewer1" runat="server" style="position:static" ShowParameterPrompts="true"
Font-Names="Verdana" Font-Size="8pt" Height="800px" ProcessingMode="Remote" Width="100%">
<ServerReport ReportPath="/FysbReports/Report1" />
</rsweb:ReportViewer>
</asp:Content>

Here is the code that reportviewer worked:

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

<%@. 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.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<rsweb:reportviewer id="ReportViewer1" runat="server" font-names="Verdana" font-size="8pt"
height="800px" processingmode="Remote" width="100%">
<ServerReport ReportPath="/FysbReports/Report1"></ServerReport>
</rsweb:reportviewer>

</div>
</form>
</body>
</html>

Question 2: How can I format the multi-value parameter prompts so that all selection are displayed as checkbox directly instead of clicking the dropdownlist and view the multple choices?

I know it is Friday afternoo. I want to say TIG Friday, but it looks like a long Friday afternoon ahead... Please help!

Hi,

From your description, it seems that your reportviewer works in a normal page but not in a master/content page, right?

Generally, for this kind of issue, the main issue is that the resource of ReportPath attribute of ServerReport maps doesn't exist. You should try to check the relative path of each resource to see if they match the relationship of your masterpage, content and the reportpath.

Second, the viewer does support multivalue parameters, but it doesn't have any concept of parsing based on comma or any other separator. When you supply the value from your textbox to the report, you will need to write your code and parse it on your own and supply the array of values to the ReportParameter object.

Thanks.

No comments:

Post a Comment