Show dynamic sql result set in Report Viewer
-
in aspx page, i have a reportviewer and ObjectDataSource as at below.
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Width="100%" > </rsweb:ReportViewer> <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="SELECT" TypeName="DataSet1.Expenses"></asp:ObjectDataSource>in codeprotected void Page_Load(object sender, EventArgs e) { DataSet ds=new DataSet(); ... adp.fill(ds) ReportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", ds.Tables[0])); }i'm sure dataset contains a table, but Reportviewer it doesnt show the result,why? -
in aspx page, i have a reportviewer and ObjectDataSource as at below.
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Width="100%" > </rsweb:ReportViewer> <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="SELECT" TypeName="DataSet1.Expenses"></asp:ObjectDataSource>in codeprotected void Page_Load(object sender, EventArgs e) { DataSet ds=new DataSet(); ... adp.fill(ds) ReportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", ds.Tables[0])); }i'm sure dataset contains a table, but Reportviewer it doesnt show the result,why?