2024年终活动

DevExpress控件使用交流,DevExpress中国社区Dev联系电话 联系电话：023-68661681

所有资源

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

来源：本站原创   发布时间：2012-09-25   浏览：3075次

这个例子展示了在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控件中文网 [https://www.devexpresscn.com/]
本文地址：https://www.devexpresscn.com/post/356.html

用科技创就卓越

Create excellence with technology

  • 客户支持
  • 技术培训    /    咨询服务
  • 服务热线：023-68661681
  • QQ群：749942875
  • 邮箱：sales@evget.com

  • 微信

    在线咨询

微信公众号

官方客服微信

DevExpress控件中文网 版权所有 Copyright 2003-2024 渝ICP备12000582号-9 渝公网安备 50010702501022号

扫码咨询
电话咨询
023-68661681
 返回
顶部