September 8, 2008 02:07am pdt

1. chrismc 160,789
2. mlmcc 136,405
3. PFrog 111,752
4. jgv 105,501
5. rickchild 50,445
6. tshel 45,099
7. RWrigley 39,404
8. Yurich 28,248
9. peter57r 23,185
10. mark_wills 21,650
11. bdreed35 18,900
12. chapmandew 17,060
13. James0... 11,920
14. gdupadhyay 11,850
15. angelIII 11,520
16. nmcdermaid 11,500
17. EugeneZ 10,925
18. CRXIuser... 10,700
19. frodoman 10,060
20. ValentinoV 9,500
21. PedroCGD 9,200
22. wykabryan 8,850
23. analliah 8,450
24. zx10r 7,890
25. WilyGuy 7,500

1. chrismc 378,053
2. simon_kirk 325,252
3. mlmcc 289,649
4. PFrog 230,052
5. Yurich 198,317
6. jgv 105,501
7. frodoman 80,287
8. RWrigley 57,204
9. peter57r 54,647
10. rickchild 50,445
11. tshel 45,099
12. JestersGrind 44,855
13. bdreed35 43,525
14. Hillwaaa 36,822
15. ABaruh 25,650
16. angelIII 23,870
17. dnsvh 22,192
18. mark_wills 21,650
19. rhinok 20,394
20. CRXIuser... 18,694
21. chapmandew 17,060
22. amyhxu 16,580
23. rscowden 16,375
24. nmcdermaid 14,414
25. IdoMillet 14,200

07.24.2008 at 09:57AM PDT, ID: 23592828

	[x] Attachment Details

How To Use a Drop Down List With Reporting Services

Asked by UserName01100001 in Visual Studio 2008, SQL Reporting, .Net Editors & IDEs

Tags: ASP.NET 2.0, ASP.NET 3.5, FireFox

Greetings,
I am attempting to use the selected value in a drop down list to return report data. However, I am unable to pass the value from the drop down list to the parameter used to get the report data. It only returns data for the default value.Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:

           
           
             <asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource4"
        DataTextField="PropertyID" DataValueField="PropertyID">
    </asp:DropDownList>
    <asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
        SelectCommand="SELECT DISTINCT [PropertyID] FROM [tblWorkOrders] ORDER BY [PropertyID]">
    </asp:SqlDataSource>
    <br />
    <br />
    <br />
    <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"
        Height="400px" Width="400px">
        <LocalReport ReportPath="StaleRPT_0.rdlc">
            <DataSources>
                <rsweb:ReportDataSource DataSourceId="ObjectDataSource3" 
                    Name="MCP_DevUseOnlyDataSet_tblWorkOrders" />
            </DataSources>
        </LocalReport>
    </rsweb:ReportViewer>
    <asp:ObjectDataSource ID="ObjectDataSource3" runat="server" 
        OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" 
        TypeName="MCP_DevUseOnlyDataSetTableAdapters.tblWorkOrdersTableAdapter">
        <SelectParameters>
            <asp:ControlParameter ControlID="DropDownList2" DefaultValue="-1" 
                Name="PropertyID" PropertyName="SelectedValue" Type="Int32" />
        </SelectParameters>
    </asp:ObjectDataSource>

           
         

Keywords: How To Use a Drop Down List With Re…

	Title
1	Emails being sent back from this partic…
2	Access Report Prompt with Drop Dow…
3	parameter
4	Connection Was dropped by Remote h…
5	Sonicwall reports numerous spoofs an…
6	URGENT: Cannot drag and drop in XP…

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

How To Use a Drop Down List With Reporting Services

Asked by UserName01100001 in Visual Studio 2008, SQL Reporting, .Net Editors & IDEs

Tags: ASP.NET 2.0, ASP.NET 3.5, FireFox

About this solution