DevExpress控件使用交流,DevExpress中国社区 售前咨询
当前位置： 首页 > 开发资源 » 示例代码 » 如何过滤ASPxGridView中基于选定行的XtraReport数据？

如何过滤ASPxGridView中基于选定行的XtraReport数据？

作者：zhuhm   来源：本站原创   浏览：Loading...次   发布时间：2012-09-25   评论：0条

这个例子展示了在ASPxGridView中如何过滤基于行选择的XtraReport 数据。XtraReport报表被置于一个单独的ASPxPopupControl 窗口中。最终用户能够重新定义窗口的尺寸并可在控制网页中移动窗口。当在ASPxGridView中没有被选行时，窗口会自动隐藏。

例中的关键点：

1）处理客户端ASPxClientGridView.SelectionChanged 事件从而跟踪行选择。

2）调用客户端ASPxClientGridView.GetSelectedFieldValues() 方法以检索选定行ID。

3）被选行的ID存于HiddenField中，以便稍后在服务器上可被随时调用。

4）通过客户端ASPxClientReportViewer.Refresh() 来启动服务器回调。

5）先前存在HiddenField中的ID用于生成XtraReport.FilterString 属性的表达式。

C# 

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%@ Register Assembly="DevExpress.Web.ASPxGridView.v9.1, Version=9.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
Namespace="DevExpress.Web.ASPxGridView" TagPrefix="dxwgv" %>
<%@ Register Assembly="DevExpress.Web.ASPxEditors.v9.1, Version=9.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
Namespace="DevExpress.Web.ASPxEditors" TagPrefix="dxe" %>
<%@ Register Assembly="DevExpress.XtraReports.v9.1.Web, Version=9.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
Namespace="DevExpress.XtraReports.Web" TagPrefix="dxxr" %>
<%@ Register Assembly="DevExpress.Web.v9.1, Version=9.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
Namespace="DevExpress.Web.ASPxPopupControl" TagPrefix="dxpc" %>
<!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>
<script language="javascript" type="text/javascript">

function OnGridSelectionComplete(values)
{
var sParam = "";

for(var i = 0; i < values.length; i ++) {
sParam += values[i].toString() + ",";
}

document.getElementById('HiddenField1').value = sParam;

if (values.length == 0)
{
ASPxPopupControl1.Hide();
}
else
{
reportViewer.Refresh();
ASPxPopupControl1.Show();
}
}

window.onload = function(){
ASPxPopupControl1.ShowAtPos(250, 50);
}

</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<br />
<dxwgv:ASPxGridView ID="ASPxGridView1" runat="server" ClientInstanceName="gridView1"
AutoGenerateColumns="False" KeyFieldName="CategoryID">
<Columns>
<dxwgv:GridViewCommandColumn ShowSelectCheckbox="True" VisibleIndex="0">
</dxwgv:GridViewCommandColumn>
<dxwgv:GridViewDataColumn FieldName="CategoryID" VisibleIndex="1">
</dxwgv:GridViewDataColumn>
<dxwgv:GridViewDataColumn FieldName="CategoryName" VisibleIndex="2">
</dxwgv:GridViewDataColumn>
</Columns>
<ClientSideEvents SelectionChanged="function(s, e) {
gridView1.GetSelectedFieldValues('CategoryID', OnGridSelectionComplete);
}" />
</dxwgv:ASPxGridView>
<dxpc:ASPxPopupControl ID="ASPxPopupControl1" runat="server" HeaderText="Report"
AllowDragging="true" AllowResize="true" CloseAction="None">
<ContentCollection>
<dxpc:PopupControlContentControl ID="PopupControlContentControl1" runat="server">
<div style="background-color: Aqua; text-align: center; border: solid 1px; padding: 10px;
min-width: 550px;">
<dxxr:ReportToolbar ID="ReportToolbar1" runat="server" ReportViewer="<%# ReportViewer1 %>"
ShowDefaultButtons="False" Width="286px">
<Styles>
<LabelStyle>
<Margins MarginLeft="3px" MarginRight="3px" />
</LabelStyle>
</Styles>
<Items>
<dxxr:ReportToolbarButton ItemKind="Search" ToolTip="Display the search window" />
<dxxr:ReportToolbarSeparator />
<dxxr:ReportToolbarButton ItemKind="PrintReport" ToolTip="Print the report" />
<dxxr:ReportToolbarButton ItemKind="PrintPage" ToolTip="Print the current page" />
<dxxr:ReportToolbarSeparator />
<dxxr:ReportToolbarButton Enabled="False" ItemKind="FirstPage" ToolTip="First Page" />
<dxxr:ReportToolbarButton Enabled="False" ItemKind="PreviousPage" ToolTip="Previous Page" />
<dxxr:ReportToolbarLabel Text="Page" />
<dxxr:ReportToolbarComboBox ItemKind="PageNumber" Width="65px">
</dxxr:ReportToolbarComboBox>
<dxxr:ReportToolbarLabel Text="of" />
<dxxr:ReportToolbarTextBox IsReadOnly="True" ItemKind="PageCount" />
<dxxr:ReportToolbarButton ItemKind="NextPage" ToolTip="Next Page" />
<dxxr:ReportToolbarButton ItemKind="LastPage" ToolTip="Last Page" />
<dxxr:ReportToolbarSeparator />
<dxxr:ReportToolbarButton ItemKind="SaveToDisk" ToolTip="Export a report and save it to the disk" />
<dxxr:ReportToolbarButton ItemKind="SaveToWindow" ToolTip="Export a report and show it in a new window" />
<dxxr:ReportToolbarComboBox ItemKind="SaveFormat" Width="70px">
<Elements>
<dxxr:ListElement Text="Pdf" Value="pdf" />
<dxxr:ListElement Text="Xls" Value="xls" />
<dxxr:ListElement Text="Rtf" Value="rtf" />
<dxxr:ListElement Text="Mht" Value="mht" />
<dxxr:ListElement Text="Text" Value="txt" />
<dxxr:ListElement Text="Csv" Value="csv" />
<dxxr:ListElement Text="Image" Value="png" />
</Elements>
</dxxr:ReportToolbarComboBox>
</Items>
</dxxr:ReportToolbar>
<dxxr:ReportViewer ID="ReportViewer1" ClientInstanceName="reportViewer" runat="server" OnUnload="ReportViewer1_Unload">
</dxxr:ReportViewer>
</div>
</dxpc:PopupControlContentControl>
</ContentCollection>
</dxpc:ASPxPopupControl>
<asp:HiddenField ID="HiddenField1" runat="server" />
</div>
</form>
</body>
</html>

VB.NET 


<%@ Page Language="vb" AutoEventWireup="true" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<%@ Register Assembly="DevExpress.Web.ASPxGridView.v9.1, Version=9.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
Namespace="DevExpress.Web.ASPxGridView" TagPrefix="dxwgv" %>
<%@ Register Assembly="DevExpress.Web.ASPxEditors.v9.1, Version=9.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
Namespace="DevExpress.Web.ASPxEditors" TagPrefix="dxe" %>
<%@ Register Assembly="DevExpress.XtraReports.v9.1.Web, Version=9.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
Namespace="DevExpress.XtraReports.Web" TagPrefix="dxxr" %>
<%@ Register Assembly="DevExpress.Web.v9.1, Version=9.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
Namespace="DevExpress.Web.ASPxPopupControl" TagPrefix="dxpc" %>
<!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>
<script language="javascript" type="text/javascript">
function OnGridSelectionComplete(values)
{
var sParam = "";
for(var i = 0; i < values.length; i ++) {
sParam += values[i].toString() + ",";
}
document.getElementById('HiddenField1').value = sParam;
if (values.length == 0)
{
ASPxPopupControl1.Hide();
}
else
{
reportViewer.Refresh();
ASPxPopupControl1.Show();
}
}
window.onload = function(){
ASPxPopupControl1.ShowAtPos(250, 50);
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<br />
<dxwgv:ASPxGridView ID="ASPxGridView1" runat="server" ClientInstanceName="gridView1"
AutoGenerateColumns="False" KeyFieldName="CategoryID">
<Columns>
<dxwgv:GridViewCommandColumn ShowSelectCheckbox="True" VisibleIndex="0">
</dxwgv:GridViewCommandColumn>
<dxwgv:GridViewDataColumn FieldName="CategoryID" VisibleIndex="1">
</dxwgv:GridViewDataColumn>
<dxwgv:GridViewDataColumn FieldName="CategoryName" VisibleIndex="2">
</dxwgv:GridViewDataColumn>
</Columns>
<ClientSideEvents SelectionChanged="function(s, e) {
gridView1.GetSelectedFieldValues('CategoryID', OnGridSelectionComplete);
}" />
</dxwgv:ASPxGridView>
<dxpc:ASPxPopupControl ID="ASPxPopupControl1" runat="server" HeaderText="Report"
AllowDragging="true" AllowResize="true" CloseAction="None">
<ContentCollection>
<dxpc:PopupControlContentControl ID="PopupControlContentControl1" runat="server">
<div style="background-color: Aqua; text-align: center; border: solid 1px; padding: 10px;
min-width: 550px;">
<dxxr:ReportToolbar ID="ReportToolbar1" runat="server" ReportViewer="<%#ReportViewer1%>"
ShowDefaultButtons="False" Width="286px">
<Styles>
<LabelStyle>
<Margins MarginLeft="3px" MarginRight="3px" />
</LabelStyle>
</Styles>
<Items>
<dxxr:ReportToolbarButton ItemKind="Search" ToolTip="Display the search window" />
<dxxr:ReportToolbarSeparator />
<dxxr:ReportToolbarButton ItemKind="PrintReport" ToolTip="Print the report" />
<dxxr:ReportToolbarButton ItemKind="PrintPage" ToolTip="Print the current page" />
<dxxr:ReportToolbarSeparator />
<dxxr:ReportToolbarButton Enabled="False" ItemKind="FirstPage" ToolTip="First Page" />
<dxxr:ReportToolbarButton Enabled="False" ItemKind="PreviousPage" ToolTip="Previous Page" />
<dxxr:ReportToolbarLabel Text="Page" />
<dxxr:ReportToolbarComboBox ItemKind="PageNumber" Width="65px">
</dxxr:ReportToolbarComboBox>
<dxxr:ReportToolbarLabel Text="of" />
<dxxr:ReportToolbarTextBox IsReadOnly="True" ItemKind="PageCount" />
<dxxr:ReportToolbarButton ItemKind="NextPage" ToolTip="Next Page" />
<dxxr:ReportToolbarButton ItemKind="LastPage" ToolTip="Last Page" />
<dxxr:ReportToolbarSeparator />
<dxxr:ReportToolbarButton ItemKind="SaveToDisk" ToolTip="Export a report and save it to the disk" />
<dxxr:ReportToolbarButton ItemKind="SaveToWindow" ToolTip="Export a report and show it in a new window" />
<dxxr:ReportToolbarComboBox ItemKind="SaveFormat" Width="70px">
<Elements>
<dxxr:ListElement Text="Pdf" Value="pdf" />
<dxxr:ListElement Text="Xls" Value="xls" />
<dxxr:ListElement Text="Rtf" Value="rtf" />
<dxxr:ListElement Text="Mht" Value="mht" />
<dxxr:ListElement Text="Text" Value="txt" />
<dxxr:ListElement Text="Csv" Value="csv" />
<dxxr:ListElement Text="Image" Value="png" />
</Elements>
</dxxr:ReportToolbarComboBox>
</Items>
</dxxr:ReportToolbar>
<dxxr:ReportViewer ID="ReportViewer1" ClientInstanceName="reportViewer" runat="server" OnUnload="ReportViewer1_Unload">
</dxxr:ReportViewer>
</div>
</dxpc:PopupControlContentControl>
</ContentCollection>
</dxpc:ASPxPopupControl>
<asp:HiddenField ID="HiddenField1" runat="server" />
</div>
</form>
</body>
</html>


本站文章除注明转载外，均为本站原创或翻译
欢迎任何形式的转载，但请务必注明出处，尊重他人劳动成果
转载请注明：文章转载自：DevExpress控件中文网 [http://www.devexpresscn.com/]
本文地址：http://www.devexpresscn.com/Resources/CodeExamples-256.html

关键字： 报表  XtraReport  ASPxGridView  ASPxPopupControl 

相关产品： DXperience Universal Subscription

上一篇： DevExpress DXCharts入门手册三：使用系列模板自动创建系列

下一篇： XtraReports实例教程一：为WinForms程序添加空白报表

评论列表

暂无评论

请谈谈你的看法 请使用IE或者Firefox浏览器，暂不支持Chrome！

昵称 不填则默认为游客评论

DevExpress DXperience DXv2 v12

DevExpress DXperience 下载 download

DevExpress购买、价格、授权

慧都控件网为DevExpress界面控件的中国地区唯一正式授权经销商，正版控件销售公司，授权代理商，经销商及合作伙伴。

电话：400-700-1020
        023-66090381

邮箱：sales@evget.com

>>如何选择正规控件购买渠道

相关资源