crystal report prints entire results from table.

See more:

C#

ASP.NET

CrystalReports

Hi Expert,

I am using vs.net 2008 and using asp.net c sharp.

I am producing report using crystal report based on category.

On report button click i have add following code.

Int64 currCatId = Convert.ToInt64(lstCategory.SelectedValue);
     try
     {
        // string queryStr = "SELECT cmp.campaign_name,cmp.campaign_status,cmp.start_date,cmp.end_date,cmp.num_sent,cmp.budgeted_cost,cat.category as cat_id   FROM  crm_campaign cmp INNER JOIN crm_category cat ON cmp.cat_id=cat.cat_id where cmp.cat_id=" + currCatId + "";
         string queryStr = "SELECT cmp.*   FROM  crm_campaign cmp  where cmp.cat_id=" + currCatId + "";


         ClassDtBaseConnect clsDtResult = new ClassDtBaseConnect();
         DataTable dt = clsDtResult.GetDataTable(queryStr);

         ReportDocument myreportDoc = new ReportDocument();
         myreportDoc.Load(Server.MapPath("TestingCrystalReport.rpt"));
         myreportDoc.SetDataSource(dt);
         CrystalReportViewer1.ReportSource = myreportDoc;
        // CrystalReportViewer1.RefreshReport();

     }
     catch (Exception Ex)
     {

     }

its showing proper results from database according to selected category.

But when i click print option from crystal report,it display all results from database without selected category and print all rows also.This problems also comes in exporting option.

How i print and export categorywise results.And crystal report is not compulsary for me.

Thanks in advance.