Filtering data in the ReportViewer using a drop down control

Paul S · Apr 7, 2008

Hi

I have a ASP.Net page with a ReportControl and a drop down control to filter
the data shown in the report.

However I cannot get any data displayed. To illustrate the problem I have
made a small demo. It is based on the AdventureWorks database.
The StateProvince table is displayed in the report and the ContryRegion
table is the source for the drop down control.

Here's my page

<body>
<form id="form1" runat="server">
<div>

</div>
<asp

ropDownList ID="DropDownList1" runat="server" AutoPostBack="True"
DataSourceID="SqlDataSource1" DataTextField="Name"
DataValueField="CountryRegionCode" Height="23px" Width="202px">
</asp

ropDownList>
<br />
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$
ConnectionStrings:AdventureWorksConnectionString %>"
SelectCommand="SELECT [CountryRegionCode], [Name] FROM
[Person].[CountryRegion]">
</asp:SqlDataSource>
<br />
<rsweb:ReportViewer ID="ReportViewer1" runat="server"
Font-Names="Verdana"
Font-Size="8pt" Height="400px" Width="613px">
<LocalReport ReportPath="Report1.rdlc">
<DataSources>
<rsweb:ReportDataSource DataSourceId="ObjectDataSource1"
Name="AdventureWorksDataSet_StateProvince" />
</DataSources>
</LocalReport>
</rsweb:ReportViewer>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
SelectMethod="GetData"

TypeName="AdventureWorksDataSetTableAdapters.StateProvinceTableAdapter">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1"
Name="CountryRegionCode"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:ObjectDataSource>
</form>
</body>

and here's my report

<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="AdventureWorksConnectionString">
<rd

ataSourceID>33fcbe7b-2c22-40af-8009-52a28721a8e8</rd

ataSourceID>
<ConnectionProperties>
<DataProvider>
</DataProvider>
<ConnectString>
</ConnectString>
</ConnectionProperties>
</DataSource>
</DataSources>
<InteractiveHeight>11in</InteractiveHeight>
<rd

rawGrid>true</rd

rawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:GridSpacing>0.25cm</rd:GridSpacing>
<rd:SnapToGrid>true</rd:SnapToGrid>
<RightMargin>2.5cm</RightMargin>
<LeftMargin>2.5cm</LeftMargin>
<BottomMargin>2.5cm</BottomMargin>
<rd:ReportID>03bcd1a3-b78c-49a9-b391-c2aff2a867fb</rd:ReportID>
<PageWidth>21cm</PageWidth>
<DataSets>
<DataSet Name="AdventureWorksDataSet_StateProvince">
<Fields>
<Field Name="StateProvinceID">
<DataField>StateProvinceID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="StateProvinceCode">
<DataField>StateProvinceCode</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="CountryRegionCode">
<DataField>CountryRegionCode</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Name">
<DataField>Name</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>AdventureWorksConnectionString</DataSourceName>
<CommandText>SELECT StateProvinceID, StateProvinceCode,
CountryRegionCode, Name
FROM Person.StateProvince
WHERE (CountryRegionCode = @CountryRegionCode)</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
<rd

ataSetInfo>
<rd

ataSetName>AdventureWorksDataSet</rd

ataSetName>
<rd:TableName>StateProvince</rd:TableName>
<rd:TableAdapterName>StateProvinceTableAdapter</rd:TableAdapterName>
<rd:TableAdapterFillMethod>Fill</rd:TableAdapterFillMethod>
<rd:TableAdapterGetDataMethod>GetData</rd:TableAdapterGetDataMethod>
</rd

ataSetInfo>
</DataSet>
</DataSets>
<Width>16.28968cm</Width>
<Body>
<ColumnSpacing>1cm</ColumnSpacing>
<ReportItems>
<Textbox Name="textbox1">
<rd

efaultName>textbox1</rd

efaultName>
<Width>12.69841cm</Width>
<Style>
<Color>SteelBlue</Color>
<FontFamily>Tahoma</FontFamily>
<FontSize>20pt</FontSize>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>1</ZIndex>
<CanGrow>true</CanGrow>
<Height>0.91429cm</Height>
<Value>Report1</Value>
</Textbox>
<Table Name="table1">
<DataSetName>AdventureWorksDataSet_StateProvince</DataSetName>
<Top>1.5cm</Top>
<TableGroups>
<TableGroup>
<Grouping Name="table1_StateProvinceID">
<GroupExpressions>

<GroupExpression>=Fields!StateProvinceID.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Sorting>
<SortBy>
<SortExpression>=Fields!StateProvinceID.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
</Sorting>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox7">
<rd

efaultName>textbox7</rd

efaultName>
<Style>
<Color>White</Color>
<BackgroundColor>#6e9eca</BackgroundColor>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>5</ZIndex>
<CanGrow>true</CanGrow>
<Value>
</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox8">
<rd

efaultName>textbox8</rd

efaultName>
<Style>
<Color>White</Color>
<BackgroundColor>#6e9eca</BackgroundColor>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>4</ZIndex>
<CanGrow>true</CanGrow>
<Value>
</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox9">
<rd

efaultName>textbox9</rd

efaultName>
<Style>
<Color>White</Color>
<BackgroundColor>#6e9eca</BackgroundColor>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>3</ZIndex>
<CanGrow>true</CanGrow>
<Value>
</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.53333cm</Height>
</TableRow>
</TableRows>
</Header>
</TableGroup>
</TableGroups>
<Width>10.28968cm</Width>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="StateProvinceCode">
<rd

efaultName>StateProvinceCode</rd

efaultName>
<Style>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>2</ZIndex>
<CanGrow>true</CanGrow>
<Value>=Fields!StateProvinceCode.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="CountryRegionCode">
<rd

efaultName>CountryRegionCode</rd

efaultName>
<Style>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>1</ZIndex>
<CanGrow>true</CanGrow>
<Value>=Fields!CountryRegionCode.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Name">
<rd

efaultName>Name</rd

efaultName>
<Style>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!Name.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.53333cm</Height>
</TableRow>
</TableRows>
</Details>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox4">
<rd

efaultName>textbox4</rd

efaultName>
<Style>
<Color>White</Color>
<BackgroundColor>SteelBlue</BackgroundColor>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>8</ZIndex>
<CanGrow>true</CanGrow>
<Value>State Province Code</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox5">
<rd

efaultName>textbox5</rd

efaultName>
<Style>
<Color>White</Color>
<BackgroundColor>SteelBlue</BackgroundColor>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>7</ZIndex>
<CanGrow>true</CanGrow>
<Value>Country Region Code</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox6">
<rd

efaultName>textbox6</rd

efaultName>
<Style>
<Color>White</Color>
<BackgroundColor>SteelBlue</BackgroundColor>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>6</ZIndex>
<CanGrow>true</CanGrow>
<Value>Name</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.55873cm</Height>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
</Header>
<TableColumns>
<TableColumn>
<Width>3.25cm</Width>
</TableColumn>
<TableColumn>
<Width>4.5cm</Width>
</TableColumn>
<TableColumn>
<Width>2.53968cm</Width>
</TableColumn>
</TableColumns>
</Table>
</ReportItems>
<Height>3.12539cm</Height>
</Body>
<Language>en-US</Language>
<TopMargin>2.5cm</TopMargin>
<PageHeight>29.7cm</PageHeight>
</Report>

Steven Cheng [MSFT] · Apr 8, 2008

Hi Paul,

From your description, you use Web ReportViewer control to display rdlc
client report on ASP.NET page and the report use a datasource which has a
control parameter from a dropdownlist. However, you found that when you
change dropdownlist selected value, the report doesn't refresh, correct?

Based on my local test, I think you need to add some code which refresh the
client report when the dropdownlist's selectedIndex changed. For example,
you can simply add the following code in "SelectedIndexChanged" event:

=====================================

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs
e)
{
ReportViewer1.LocalReport.Refresh();
}

=========================

Here is the test page's aspx template:

===========================================
<form id="form1" runat="server">
<div>

<asp

ropDownList ID="DropDownList1" runat="server"
AutoPostBack="True"
onselectedindexchanged="DropDownList1_SelectedIndexChanged">
<asp:ListItem>1</asp:ListItem>
<asp:ListItem>2</asp:ListItem>
<asp:ListItem>3</asp:ListItem>
<asp:ListItem>4</asp:ListItem>
<asp:ListItem>5</asp:ListItem>
</asp

ropDownList>

</div>
<rsweb:ReportViewer ID="ReportViewer1" runat="server"
Font-Names="Verdana"
Font-Size="8pt" Height="400px" Width="400px">
<LocalReport ReportPath="PersonReport.rdlc">
<DataSources>
<rsweb:ReportDataSource DataSourceId="ObjectDataSource1"
Name="testdbDataSet_persons" />
</DataSources>
</LocalReport>
</rsweb:ReportViewer>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
SelectMethod="GetData"
TypeName="testdbDataSetTableAdapters.personsTableAdapter">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1"
DefaultValue="1" Name="id"
PropertyName="SelectedValue" />
</SelectParameters>
</asp:ObjectDataSource>
</form>

====================

Hope this helps.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

Thread-Topic: Filtering data in the ReportViewer using a drop down control
thread-index: AciYoA+7+I8LQKWSQbmB8LA/Psnk2g==
X-WBNR-Posting-Host: 87.48.170.130
From: =?Utf-8?B?UGF1bCBT?= <[email protected]>
Subject: Filtering data in the ReportViewer using a drop down control
Date: Mon, 7 Apr 2008 04:11:00 -0700

Hi

I have a ASP.Net page with a ReportControl and a drop down control to filter
the data shown in the report.

However I cannot get any data displayed. To illustrate the problem I have
made a small demo. It is based on the AdventureWorks database.
The StateProvince table is displayed in the report and the ContryRegion
table is the source for the drop down control.

Here's my page

<body>
<form id="form1" runat="server">
<div>

</div>
<aspropDownList ID="DropDownList1" runat="server" AutoPostBack="True"
DataSourceID="SqlDataSource1" DataTextField="Name"
DataValueField="CountryRegionCode" Height="23px" Width="202px">
</aspropDownList>
<br />
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$
ConnectionStrings:AdventureWorksConnectionString %>"
SelectCommand="SELECT [CountryRegionCode], [Name] FROM
[Person].[CountryRegion]">
</asp:SqlDataSource>
<br />
<rsweb:ReportViewer ID="ReportViewer1" runat="server"
Font-Names="Verdana"
Font-Size="8pt" Height="400px" Width="613px">
<LocalReport ReportPath="Report1.rdlc">
<DataSources>
<rsweb:ReportDataSource DataSourceId="ObjectDataSource1"
Name="AdventureWorksDataSet_StateProvince" />
</DataSources>
</LocalReport>
</rsweb:ReportViewer>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
SelectMethod="GetData"

TypeName="AdventureWorksDataSetTableAdapters.StateProvinceTableAdapter">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1"
Name="CountryRegionCode"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:ObjectDataSource>
</form>
</body>

and here's my report

<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefin ition"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="AdventureWorksConnectionString">

<ConnectionProperties>
<DataProvider>
</DataProvider>
<ConnectString>
</ConnectString>
</ConnectionProperties>
</DataSource>
</DataSources>
<InteractiveHeight>11in</InteractiveHeight>
<rdrawGrid>true</rdrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:GridSpacing>0.25cm</rd:GridSpacing>
<rd:SnapToGrid>true</rd:SnapToGrid>
<RightMargin>2.5cm</RightMargin>
<LeftMargin>2.5cm</LeftMargin>
<BottomMargin>2.5cm</BottomMargin>
<rd:ReportID>03bcd1a3-b78c-49a9-b391-c2aff2a867fb</rd:ReportID>
<PageWidth>21cm</PageWidth>
<DataSets>
<DataSet Name="AdventureWorksDataSet_StateProvince">
<Fields>
<Field Name="StateProvinceID">
<DataField>StateProvinceID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="StateProvinceCode">
<DataField>StateProvinceCode</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="CountryRegionCode">
<DataField>CountryRegionCode</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Name">
<DataField>Name</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>AdventureWorksConnectionString</DataSourceName>
<CommandText>SELECT StateProvinceID, StateProvinceCode,
CountryRegionCode, Name
FROM Person.StateProvince
WHERE (CountryRegionCode = @CountryRegionCode)</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
<rdataSetInfo>
<rdataSetName>AdventureWorksDataSet</rdataSetName>
<rd:TableName>StateProvince</rd:TableName>

<rd:TableAdapterFillMethod>Fill</rd:TableAdapterFillMethod>

Paul S · Apr 8, 2008

You're absolutely right Steven - that solved my problem. --

Thanks a lot
Paul S

Steven Cheng said:
Hi Paul,

From your description, you use Web ReportViewer control to display rdlc
client report on ASP.NET page and the report use a datasource which has a
control parameter from a dropdownlist. However, you found that when you
change dropdownlist selected value, the report doesn't refresh, correct?

Based on my local test, I think you need to add some code which refresh the
client report when the dropdownlist's selectedIndex changed. For example,
you can simply add the following code in "SelectedIndexChanged" event:

=====================================

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs
e)
{
ReportViewer1.LocalReport.Refresh();
}

=========================

Here is the test page's aspx template:

===========================================
<form id="form1" runat="server">
<div>

<aspropDownList ID="DropDownList1" runat="server"
AutoPostBack="True"
onselectedindexchanged="DropDownList1_SelectedIndexChanged">
<asp:ListItem>1</asp:ListItem>
<asp:ListItem>2</asp:ListItem>
<asp:ListItem>3</asp:ListItem>
<asp:ListItem>4</asp:ListItem>
<asp:ListItem>5</asp:ListItem>
</aspropDownList>

</div>
<rsweb:ReportViewer ID="ReportViewer1" runat="server"
Font-Names="Verdana"
Font-Size="8pt" Height="400px" Width="400px">
<LocalReport ReportPath="PersonReport.rdlc">
<DataSources>
<rsweb:ReportDataSource DataSourceId="ObjectDataSource1"
Name="testdbDataSet_persons" />
</DataSources>
</LocalReport>
</rsweb:ReportViewer>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
SelectMethod="GetData"
TypeName="testdbDataSetTableAdapters.personsTableAdapter">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1"
DefaultValue="1" Name="id"
PropertyName="SelectedValue" />
</SelectParameters>
</asp:ObjectDataSource>
</form>

====================

Hope this helps.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

Thread-Topic: Filtering data in the ReportViewer using a drop down control
thread-index: AciYoA+7+I8LQKWSQbmB8LA/Psnk2g==
X-WBNR-Posting-Host: 87.48.170.130
From: =?Utf-8?B?UGF1bCBT?= <[email protected]>
Subject: Filtering data in the ReportViewer using a drop down control
Date: Mon, 7 Apr 2008 04:11:00 -0700

Click to expand...

Hi

I have a ASP.Net page with a ReportControl and a drop down control to filter
the data shown in the report.

However I cannot get any data displayed. To illustrate the problem I have
made a small demo. It is based on the AdventureWorks database.
The StateProvince table is displayed in the report and the ContryRegion
table is the source for the drop down control.

Here's my page

<body>
<form id="form1" runat="server">
<div>

</div>
<aspropDownList ID="DropDownList1" runat="server" AutoPostBack="True"
DataSourceID="SqlDataSource1" DataTextField="Name"
DataValueField="CountryRegionCode" Height="23px" Width="202px">
</aspropDownList>
<br />
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$
ConnectionStrings:AdventureWorksConnectionString %>"
SelectCommand="SELECT [CountryRegionCode], [Name] FROM
[Person].[CountryRegion]">
</asp:SqlDataSource>
<br />
<rsweb:ReportViewer ID="ReportViewer1" runat="server"
Font-Names="Verdana"
Font-Size="8pt" Height="400px" Width="613px">
<LocalReport ReportPath="Report1.rdlc">
<DataSources>
<rsweb:ReportDataSource DataSourceId="ObjectDataSource1"
Name="AdventureWorksDataSet_StateProvince" />
</DataSources>
</LocalReport>
</rsweb:ReportViewer>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
SelectMethod="GetData"

TypeName="AdventureWorksDataSetTableAdapters.StateProvinceTableAdapter">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1"
Name="CountryRegionCode"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:ObjectDataSource>
</form>
</body>

and here's my report

<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefin ition"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="AdventureWorksConnectionString">

Click to expand...

<ConnectionProperties>
<DataProvider>
</DataProvider>
<ConnectString>
</ConnectString>
</ConnectionProperties>
</DataSource>
</DataSources>
<InteractiveHeight>11in</InteractiveHeight>
<rdrawGrid>true</rdrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:GridSpacing>0.25cm</rd:GridSpacing>
<rd:SnapToGrid>true</rd:SnapToGrid>
<RightMargin>2.5cm</RightMargin>
<LeftMargin>2.5cm</LeftMargin>
<BottomMargin>2.5cm</BottomMargin>
<rd:ReportID>03bcd1a3-b78c-49a9-b391-c2aff2a867fb</rd:ReportID>
<PageWidth>21cm</PageWidth>
<DataSets>
<DataSet Name="AdventureWorksDataSet_StateProvince">
<Fields>
<Field Name="StateProvinceID">
<DataField>StateProvinceID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="StateProvinceCode">
<DataField>StateProvinceCode</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="CountryRegionCode">
<DataField>CountryRegionCode</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Name">
<DataField>Name</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>AdventureWorksConnectionString</DataSourceName>
<CommandText>SELECT StateProvinceID, StateProvinceCode,
CountryRegionCode, Name
FROM Person.StateProvince
WHERE (CountryRegionCode = @CountryRegionCode)</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
<rdataSetInfo>
<rdataSetName>AdventureWorksDataSet</rdataSetName>
<rd:TableName>StateProvince</rd:TableName>

Click to expand...

<rd:TableAdapterFillMethod>Fill</rd:TableAdapterFillMethod>

Click to expand...

</rdataSetInfo>
</DataSet>
</DataSets>
<Width>16.28968cm</Width>
<Body>
<ColumnSpacing>1cm</ColumnSpacing>
<ReportItems>
<Textbox Name="textbox1">
<rdefaultName>textbox1</rdefaultName>
<Width>12.69841cm</Width>
<Style>
<Color>SteelBlue</Color>
<FontFamily>Tahoma</FontFamily>
<FontSize>20pt</FontSize>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>1</ZIndex>
<CanGrow>true</CanGrow>
<Height>0.91429cm</Height>
<Value>Report1</Value>
</Textbox>
<Table Name="table1">
<DataSetName>AdventureWorksDataSet_StateProvince</DataSetName>
<Top>1.5cm</Top>
<TableGroups>
<TableGroup>
<Grouping Name="table1_StateProvinceID">
<GroupExpressions>

<GroupExpression>=Fields!StateProvinceID.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Sorting>
<SortBy>

Click to expand...

<Direction>Ascending</Direction>
</SortBy>
</Sorting>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox7">
<rdefaultName>textbox7</rdefaultName>
<Style>
<Color>White</Color>
<BackgroundColor>#6e9eca</BackgroundColor>
<BorderColor>
<Default>LightGrey</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>5</ZIndex>
<CanGrow>true</CanGrow>
<Value>
</Value>
</Textbox>
</ReportItems>
</TableCell>

Click to expand...

Steven Cheng [MSFT] · Apr 8, 2008

You're welcome

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead

Paul S · Apr 9, 2008

Hi again
When I move this into my production code my subreports failed. I tried to
change my Page_load method so that this is always done - not just when is not
Postback

this.ReportViewer1.LocalReport.SubreportProcessing +=
new
Microsoft.Reporting.WebForms.SubreportProcessingEventHandler(LocalReport_SubreportProcessing);

When I select a different value in the drop down box I see that
SubreportProcessing is null in the Page_Load eventhandler.

- and everything works now !

What's the explanation for this

Steven Cheng [MSFT] · Apr 10, 2008

Hi Paul,

I haven't expected the subreport scenario here. Yes, I know that for sub
report in rdlc, we need to ad "SubReportProcessing" handler and add
datasource for subreport. As you said that the event handler is Null, how
did you originally attached the event handler? I agree that add event
wireup code in Page_Load is reasonable for event handler to be registered
on every request.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

From: =?Utf-8?B?UGF1bCBT?= <[email protected]>
References: <[email protected]>

<[email protected]>

Subject: RE: Filtering data in the ReportViewer using a drop down control
Date: Tue, 8 Apr 2008 23:47:01 -0700

Paul S · Apr 10, 2008

Hi Steven
Originally I did it also in the Page_load but

if (!this.IsPostBack) ..

I expected it only to be nescessary do be done once

Steven Cheng [MSFT] · Apr 10, 2008

Thanks for your quick reply paul,

for ASP.NET webcontrol, if you attach even handler in code, you need to
make sure the event handler attaching code get executed in each request(not
only in the first load).

Actually, this is also a common requirement for dynamically created
webserver control. You need to create the control instance and attach
event handler(if necessary) in each page request(in Init or Load). Only
attach once (when !IsPostBack) is not enough because in each request/load,
it will recreate the control structure and check event handler:

http://support.microsoft.com/kb/317794

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
=
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

References: <[email protected]>

<[email protected]>
<[email protected]>
<[email protected]>

Paul S · Apr 17, 2008

Thanks Steven
I got everything up and running now
One small comment - error tracking is really hard when the subreport fails
to load - not much help is provided in the error messages. Hope this gets
better in the future.

Steven Cheng [MSFT] · Apr 18, 2008

Thanks for your followup and the sincere comments.

For the subreport error handling, I also suggest you submit it to our
feedback center so that the DEV team can also get more on this:

https://connect.microsoft.com/feedback/default.aspx?SiteID=210&wa=wsignin1.0

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

Thread-Topic: Filtering data in the ReportViewer using a drop down control
thread-index: Acigd0F3MvAaE6dgRo+tkBu55AHCpg==
X-WBNR-Posting-Host: 87.48.170.130
From: =?Utf-8?B?UGF1bCBT?= <[email protected]>
Subject: RE: Filtering data in the ReportViewer using a drop down control
Date: Thu, 17 Apr 2008 03:39:04 -0700

Reportviewer not showing any data	0	Nov 3, 2008
How to expand properties and events in AJAX WebShop	0	Dec 28, 2006
Issue with Dynamic Dependent Drop Down Menu	0	Jan 25, 2008
Default Values being displayed in DetailsView	7	Dec 11, 2008
Drop down menues	0	Sep 2, 2003
drop down box not working in FireFox when on DIV	2	Dec 15, 2005
Problem Loading Data in to a Textbox located in MultiView that is in a Login View	0	Mar 7, 2007
Repeater control	1	Nov 30, 2007

Filtering data in the ReportViewer using a drop down control

Paul S

Steven Cheng [MSFT]

Paul S

Steven Cheng [MSFT]

Paul S

Steven Cheng [MSFT]

Paul S

Steven Cheng [MSFT]

Paul S

Steven Cheng [MSFT]

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads