Create Report in which columns are not predefined.

Hi friends i want to Create a report which columns will dynamic from stored procedure.I mean i can't predefined no of columns in my report.If my Stored Procedure's query contains 5 columns then 5 column should be display in report,if query contain 10 columns then report should display 10 columns.So my question is which report i should use.I should use RDLC,RDL,Crystal or any other ?? Please reply.thanks in advance.I am using VS 2010,Sql Server 2008 R2.

Thanks FADUGBA JEREMIAH,I have crete RDLC runtime and save the xml code of dynamically generated rdlc in DetailReport.rdlc .Now my problem is on top of winform i have keep one ComboBox,from which i can select which data i have to display in report.For first selected item it display report,then after it doesn't show report.

My code is as follow:

private void btnShow_Click(object sender, EventArgs e)

{

ReportViewer1.Reset();

ReportViewer1.LocalReport.DataSources.Clear();

string dsName = comboBox1.Text;

#region SQL

DataTable dt = new DataTable();

SqlConnection con = new SqlConnection("Data Source=SERVER;Initial Catalog=Test;User ID=sa;Password=sa");

SqlCommand cmd = new SqlCommand("SELECT * FROM dbo." + dsName, con);

SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(dt);

#endregion

ReportGenerator gen = new ReportGenerator(dt, dsName);

ds = new ReportDataSource(dsName, dt);

string xml = gen.GeneraReport();

XmlDocument xDoc = new XmlDocument();

xDoc.LoadXml(xml);

xDoc.Save(@"D:\\Surendra\\SSRS\\SSRS\\DetailReport.rdlc");

ReportViewer1.LocalReport.ReportEmbeddedResource = "SSRS.MainReport.rdlc";

ReportViewer1.LocalReport.DisplayName = "Main Report";

ReportViewer1.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(LocalReport_SubreportProcessing);

this.ReportViewer1.RefreshReport();

}

void LocalReport_SubreportProcessing(object sender, SubreportProcessingEventArgs e)

{

if (e.ReportPath == "DetailReport")

e.DataSources.Add(ds);

}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Fadugba Jeremiah12y ago
Accepted answer
use RDLC it worked for me
Surendrasinh Rathod12y ago
Thanks FADUGBA JEREMIAH,I have crete RDLC runtime and save the xml code of dynamically generated rdlc in DetailReport.rdlc .Now my problem is on top of winform i have keep one ComboBox,from which i can select which data i have to display in report.For first selected item it display report,then after it doesn't show report.

My code is as follow:
private void btnShow_Click(object sender, EventArgs e)
{
ReportViewer1.Reset();
ReportViewer1.LocalReport.DataSources.Clear();

string dsName = comboBox1.Text;
#region SQL
DataTable dt = new DataTable();
SqlConnection con = new SqlConnection("Data Source=SERVER;Initial Catalog=Test;User ID=sa;Password=sa");
SqlCommand cmd = new SqlCommand("SELECT * FROM dbo." + dsName, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
#endregion
ReportGenerator gen = new ReportGenerator(dt, dsName);
ds = new ReportDataSource(dsName, dt);
string xml = gen.GeneraReport();

XmlDocument xDoc = new XmlDocument();
xDoc.LoadXml(xml);

xDoc.Save(@"D:\\Surendra\\SSRS\\SSRS\\DetailReport.rdlc");

ReportViewer1.LocalReport.ReportEmbeddedResource = "SSRS.MainReport.rdlc";
ReportViewer1.LocalReport.DisplayName = "Main Report";

ReportViewer1.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(LocalReport_SubreportProcessing);
this.ReportViewer1.RefreshReport();

}

void LocalReport_SubreportProcessing(object sender, SubreportProcessingEventArgs e)
{
if (e.ReportPath == "DetailReport")
e.DataSources.Add(ds);
}