Generate Report From Student Database for each student

Question

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....

Kavi suja · Answer

:):):)

Sunny Sharma · Answer

I'm glad you did it... sorry for I couldn't respond in time was in the middle of something urgent. Cheers !!

Kavi suja · Answer

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.

Kavi suja · Answer

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.

Sunny Sharma · Answer

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?

Kavi suja · Answer

Layout It should be Mark Report Generated in Colleges which is send to Parents That's it contains NameDeptEach subject marks.

Sunny Sharma · Answer

any Idea of layout or design how you want them to be displayed?

Kavi suja · Answer

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.

Sunny Sharma · Answer

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.