I use dynamic table for Telerik Report porpose.I already created Telerik Report but when I use Dataset I can not show the fields of table How can I show the values of Dataset in report.
Note : I did not define any field in design section because I do not know it and also Dataset is not empty
Since my T-SQL is dynamic, i can not assign fields to tables at the report design. I wonder how i can assign fields ?
my code is as follow;
private void rpt_MPDlist_NeedDataSource(object sender, EventArgs e)
{
SqlConnection connSomsys = new SqlConnection(ConfigurationManager.AppSettings["conStr"]);
SqlCommand selectCurrentYearTot;
selectCurrentYearTot = new SqlCommand("CNF_MPDRelatedModList_search",connSomsys);
selectCurrentYearTot.CommandType = CommandType.StoredProcedure;
selectCurrentYearTot.Parameters.AddWithValue("@table", this.ReportParameters["table"].Value);
SqlDataAdapter adapter2 = new SqlDataAdapter(selectCurrentYearTot);
DataSet ds = new DataSet();
adapter2.Fill(ds);
table1.DataSource = ds;
}
T-SQL code;
CREATE procedure CNF_MPDRelatedModList_search
(
@table as nvarchar (200)
)
AS
BEGIN
declare @filename as nvarchar (400)
declare @sql as nvarchar (4000)
set @filename=@table
declare @deneme as nvarchar (4000)
set @deneme='2'
set @SQL = replace(replace('select ATA_SB_NO,TITLE,MOD_NO,MP_NO,COMPLIANCE,EO_NO,NOTES from (SELECT ATA_SB_NO,TITLE,MOD_NO,cast (len (MOD_NO)as int) MD,MP_NO,cast (len (MP_NO) as int) MP,COMPLIANCE,EO_NO,NOTES FROM @filename )mst where MP >@deneme and M
D >@deneme' ,'@filename', @filename ),'@deneme',@deneme )
exec sp_executesql @SQL
END