how to make a subreport in .net

[Smish]

hi,


i want to create a subreport.i tried many ways bt am nt able to get the right output.
can please ne1 tell me how to go about it systematically.
thanx.

the task is xplained here in detail.
ex:

i hv a main report which gets displayed on th click of a item in a form in .net.

nw ths main report have fields.

class division students

3 A 23
4 b 43


now the task is...if i click on students..suppose 43 thn i should get a new report which will show the
name age

of students..
similarly if i click on 23 i need to get a report which displays the names of students from 3 class of div b.

so can ne i tell me hw to go about it....

thanx..

[kenobewan]

Please provide more information about platform, language, errors etc.

[Smish]

The crystal report which am using is embedded in .net vs 2003 .
c# ..
thanx..

[hodgesp]

Depending on how you conect to the database you use the connection for the main report and pass it to the sub report. I found the easiest way is to use a SQLDataAdapter and DataSet in design mode. The Adapter handles the connection and all you have to do is cycle through the sections of the report.

Here is some sample C# code: Note crReport1 is the Main Report, crSubRptName is the SubReport. Make sure the tables for the main report and the tables for the SubReport are included in DataSet1

SAMPLECode

this.sqlCommand1.Connection = sqlConnection1; 
this.sqlCommand1.CommandType = CommandType.Text; 
this.sqlCommand1.CommandText="Select * From Table1 Where Field1 
= " + someValue;
 
this.DataSet1.Clear(); 
 
this.sqlDataAdapter1.SelectCommand = this.sqlCommand1; 
this.sqlDataAdapter1.Fill(this.DataSet1,"Tabl1");
this.crReport1.SetDataSource(this.DataSet1);
//---subreport script---//
Sections crSections;
crSections = this.crReport1.ReportDefinition.Sections;                              
ReportObjects crReportObjects;
SubreportObject crSubreportObject;
ReportDocument crSubRptName  = new ReportDocument();                              
foreach (Section crSection in crSections) 
{
 crReportObjects = crSection.ReportObjects;
   foreach (ReportObject crReportObject in crReportObjects) 
    {
      if (crReportObject.Kind == ReportObjectKind.SubreportObject) 
         {
            crSubreportObject = (SubreportObject)crReportObject; 
            crSubreportObject.OpenSubreport( crSubreportObject.SubreportName).SetDataSource(this.DataSet1);
        }
     }
}
 
this.CrystalReportViewer1.ReportSource = this.crReport1; 
this.crReport1.PrintOptions.PaperOrientation = PaperOrientation.Landscape;//
this.crReport1.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.DefaultPaperSize;   //
this.CrystalReportViewer1.DataBind();                             
 
//---pdf export code---//
System.IO.BinaryReader strStream;
strStream = new BinaryReader(crReport1.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat));
Response.ClearContent();
Response.ClearHeaders();
Response.ContentType = "application/pdf"; Response.BinaryWrite(strStream.ReadBytes(Convert.ToInt32(strStream.BaseStream.Length)));
Response.Flush();
Response.Close();

[radcaesar]

For this, drill down reports using datagrid will be enough (with the help of table relationships) No need for crystal reports.

:)

[Smish]

hi all..
thanx..

but my requirement is to use crystalreports....

[hodgesp]

I use Crystal in my applications too. In fact I had a hard time finding code that worked for me as well but I finally did.

Add the tables, views, or stored procedure to the dataset in the design mode. Create your reports; main and subreport, then try the code I previously submitted. Substituting the name of your reports where noted. I also included some script to automatically export the report to pdf. You can take that out or attach it to a seperated button control if you want.

good luck.