动态创建报告 [英] Create Report Dynamically

问题描述

是否可以通过提供任何选择查询动态显示rdlc报告。



我想为用户提供一个按照自己的方式创建报告的功能。同时我将创建一个sql查询，通过Microsoft Report viewer获取所需的报告...



我知道这不容易，但有没有机会？



谢谢

解决方案

< blockquote>是的，这是可能的..



试试吧.... :)



1 ）.aspx.cs页面

 受保护  void  Page_Load（ object  sender，EventArgs e）
 {
 DataSet ds = GetDataSet（）; 
 ReportDataSource rds =  new  ReportDataSource（ 订单，ds.Tables [ 0 ]）; 
 ReportViewer1.LocalReport.DataSources.Clear（）; 
 ReportViewer1.LocalReport.DataSources.Add（rds）; 
 ReportViewer1.LocalReport.Refresh（）; 
 
 GridView1.DataSource = ds; 
 GridView1.DataBind（）; 
} 
 
  private  DataSet GetDataSet（）
 {
  var  conString = ConfigurationManager.ConnectionStrings [  dotnetConnectionString]; 
  string  strConnString = conString.ConnectionString; 
 
 SqlConnection conn =  new  SqlConnection（strConnString）; 
 conn.Open（）; 
  string  sql =  选择* FROM订单; 
 
 SqlDataAdapter ad =  new  SqlDataAdapter（sql，conn）; 
 DataSet ds =  new  DataSet（）; 
 ad.Fill（ds）; 
 
  return  ds; 
} 

.aspx page

< form id =   form1 runat =   server >  
< div> 
< asp：scriptmanager id =   ScriptManager1 runat =   server xmlns：asp =  ＃unknown >  
 < /   asp：scriptmanager  >  
< rsweb：reportviewer id =   ReportViewer1 runat =   server height =   600px width =   800px xmlns：rsweb =   #unknown >  
< localreport reportpath =   Reports\Report.rdlc >  
< datasources> 
< rsweb：reportdatasource /> 
 < /  数据源 >  
 < /   localreport  >  
 < /   rsweb：reportviewer  >  
< asp：gridview id =   GridView1 runat =   server xmlns：asp =  ＃unknown >  
 < ; /   asp：gridview  >  
 < /   div  & gt;  
 < /  表格 >  

Hi,

Is it possible to Show a rdlc report dynamically by giving any select query.

I want to give a functionality for user to create report by his own way.At the same time i will create a sql query for getting desired report through Microsoft Report viewer...

I know it is not easy but is there any chance??

Thanks

解决方案

Yes it is possible..

Just try this....:)

1).aspx.cs page

protected void Page_Load(object sender, EventArgs e)
{
    DataSet ds = GetDataSet();
    ReportDataSource rds = new ReportDataSource("Orders", ds.Tables[0]);
    ReportViewer1.LocalReport.DataSources.Clear();
    ReportViewer1.LocalReport.DataSources.Add(rds);
    ReportViewer1.LocalReport.Refresh();

    GridView1.DataSource = ds;
    GridView1.DataBind();
}

private DataSet GetDataSet()
{
    var conString = ConfigurationManager.ConnectionStrings["dotnetConnectionString"];
    string strConnString = conString.ConnectionString;

    SqlConnection conn = new SqlConnection(strConnString);
    conn.Open();
    string sql = "Select * FROM Orders";

    SqlDataAdapter ad = new SqlDataAdapter(sql, conn);
    DataSet ds = new DataSet();        
    ad.Fill(ds);

    return ds;
}

.aspx page

<form id="form1" runat="server">
<div>
    <asp:scriptmanager id="ScriptManager1" runat="server" xmlns:asp="#unknown">
    </asp:scriptmanager>
    <rsweb:reportviewer id="ReportViewer1" runat="server" height="600px" width="800px" xmlns:rsweb="#unknown">
        <localreport reportpath="Reports\Report.rdlc">
            <datasources>
                <rsweb:reportdatasource />
            </datasources>
        </localreport>
    </rsweb:reportviewer>
    <asp:gridview id="GridView1" runat="server" xmlns:asp="#unknown">
    </asp:gridview>
</div>
</form>

这篇关于动态创建报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！