When you create a sub report, it is a new report based on the parameters selected on the main report. That means altogether you will have 3 reports

 Drag Crystal Report viewer control from toolbox to form. Properties:
  Crystal Report Name: CRV1
  Report Source= or
  And call show () method
  DOCK=Fill (The control resizes while form is resized

  1. report header
  2. report footer
  3. page header
  4. page footer
  5. details

 using CrystalDecisions.Shared
  CrystalReport1 cr= new CrystalReport1;
  'here crystalreport1 is crystal report which we design.
  CrystalViewer1.ReportSource = cr;
OR
  we can directly print the report without showing report
  CrystalReport1 cr= new CrystalReport1;
  cr.PrintToPrinter(1,False,1,1);

 Choose File -> Options menu. In the Options dialog box Click the Database tab and ensure that Stored Procedures is selected. Selecting "Stored Procedures" automatically displays any available stored procedures when you log on to an SQL database.
Click OK to exit the Options dialog box.
On the Start Page, click Blank Report.
Locate and select the SQL Server data source that contains the stored procedure you want to use.
Click Next to go to the Connection Information dialog box.
Enter the required information to log in.
Click Finish.
Highlight an SQL stored procedure in the Stored Procedures folder, and click the > arrow to add it to the Selected Tables list.
The Enter Parameter Values dialog box appears.
Highlight a parameter in the Parameter Fields list.
Assign a value by typing into the Discrete Value box and then click OK.
You are returned to the Database Expert.
Click OK and create your report using the fields in the stored procedure.

 1.When you use ?refresh? button in crystal report viewer, it refreshes the report data.
 2.When you refresh data from the Preview tab, the Refresh Report Data dialog box appears.
  Select the "Use current parameter values" option to use the current parameter value.
Select the "Prompt for new parameter values" option to enter a new parameter value. When you select this option and click OK, the Enter Prompt Values dialog box appears.
The program now runs the report using the new value(s) you specified.

  1. In export- While exporting data formatting is lost.
  2. If database is having field whose length is more than 255 characters, then you cannot make formula using that field.
  3.When you browse data just by right clicking on the field then it displays that is there in the database not the data selected by the query.

  Yes we can use our SQL query, when developer select the table or the procedure name for create the report so at the place of them select Add Command and than a editor will display so there you can add ur query.