hello there, thank you guys over there who were giving me the idea to this question. I finally managed to solve my problem and might help also other to post here. 1.I just created two independent subreports on my main reports 2. I linked my main report parameters to subreports parameters so that when the parameter in main report receives values from the application it will pass those values to the sub reports parameters at runtime.

Hi David, Thanks for the reply. I am using stored procedures that require three parameters from the its caller. Based on the data supplied to the stored procedure data will be generated from various table. Can u give me some hint on how to do so using sub-reports. here is my sample code for calling stored procedure to generate report. dim rpt as new myreportname rpt.SetParameterValue("@studid", DataGridView1.CurrentCell.Value) If ComboBox3.SelectedItem IsNot Nothing And TextBox3.Text IsNot Nothing Then rpt.SetParameterValue("@term", CInt(ComboBox3.SelectedItem)) rpt.SetParameterValue("@academicyear", TextBox3.Text) GradeReportForm.CrystalReportViewer1.ReportSource = rpt GradeReportForm.StartPosition = FormStartPosition.CenterParent GradeReportForm.WindowState = FormWindowState.Maximized GradeReportForm.CrystalReportViewer1.PrintReport() Else MsgBox("Please Set Term and Academic year to Generate Report") End If I am grateful for any help you may give me. with regards,

Try to search in code project/ google before posting a question Go through This.... Reading and Writing Excel using OLEDB[^] Thanks Rajesh B --> A Poor Workman Blames His Tools <--

Repeating the same useless statement does not change the fact the you've asked a VERY general question that isn't really answerable. Without further detail, like what you mean by "data" and how this data is supposed to be formatted, it's pretty impossible to answer your question. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008 But no longer in 2009...

OCR maybe Steve Jowett ------------------------- Real programmers don't comment their code. If it was hard to write, it should be hard to read.

Parameters generally used as a selection or displaying some information ie user name, department. They are not meant for passing in the report data itself. The Crystal Report should take the data from data sources like dataset, object collections, or directly from the database itself, not by passing in as parameters one by one.

solved

u mean using stored proc (somevariable + autonumber) as Columnname, can u give me some hint, if u have thank u in advance.

i have got the solutions to my problems, thanks the support i received from u

Do not repost. It is considered rude here. It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

thank u guys, i got the solution to my problems

thanks perspx, i had some clues from your reply. But do u have any sample code to do so based my sample? thanks again