Generate Report From Student Database for each student

Kavi suja

Hi,

I want to generate report using VS 2010.I have table in MySql for Student Records.Now I've to generate report for each student seperately.That's I generate report using dataset which generate all student records at a time.But my task is to generate seperate record for each student.

Thanks is adnace guys....

9 Replies

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

Kavi suja13y ago
:):):)
0
Sunny Sharma13y ago
I'm glad you did it... sorry for I couldn't respond in time, was in the middle of something urgent. Cheers !!
0
Kavi suja13y ago
Hi,
Thanks for your co operation.Now I bring student Details seperately in each page By using GroupNameFields option. There I choose grouping based on Student Name. Now it's possible
to generate report for each student seperately.
0
Kavi suja13y ago
Hi,
I create one dataset.xsd file.There I attache my Data Base table.Then I drag Crystal Report Viewer from toollbox. In page load I done the following code.

protected void Page_Load(object sender, EventArgs e)
{
MySqlConnection connection = new MySqlConnection("server=localhost;User Id=root;password=MySqlAdmin;database=details");
MySqlCommand command = new MySqlCommand("Select * From smark", connection);
MySqlDataAdapter adapter = new MySqlDataAdapter(command);
//Customer _Customer = new Customer();
DataSet dataset = new DataSet();
adapter.Fill(dataset, "Customer");
ReportDocument CustomerReport = new ReportDocument();
CustomerReport.Load(Server.MapPath("CrystalReport1.rpt"));
CustomerReport.SetDataSource(dataset.Tables["Customer"]);
CrystalReportViewer1.ReportSource = CustomerReport;
CrystalReportViewer1.DataBind();
}

This generates all student details from my database at a time. But i didn't know how i bring seperate records from database in to report.
0
Sunny Sharma13y ago
ok... for now how do you generate this for all the students. I mean I want to know what the exact problem is? where are you stuck?
0
Kavi suja13y ago
Layout "It should be Mark Report Generated in Colleges which is send to Parents" That's it contains Name,Dept,Each subject marks.
0
Sunny Sharma13y ago
any Idea of layout or design how you want them to be displayed?
0
Kavi suja13y ago
Hi, I want to generate reports in web forms.I can generate all students records from Database.But i can't to generate for each students seperately.
0
Sunny Sharma13y ago
How and where you want to generate the reports... I mean in Winform, Webform or else? Try iterating on each student and fetching records. You can also fetch all the records in one go inside a datatable and query that datatable for each student.
0