Hi
'm generating crystal report from database..
Here i have to generate only specific rows...
i have used sql query is SELECT * FROM [TABLENAME] WHERE COLOUMNAME=" ".
Here this works in query builder but not performing in crystal reports, it shoes again entire report.
here is my cs coding
obj.Open();
string sqlquery = "select * from xcd where batch='24-28'";
SqlCommand objcmd = new SqlCommand(sqlquery, obj);
SqlDataAdapter da = new SqlDataAdapter(objcmd);
DataSet ds = new DataSet();
da.Fill(ds);
CrystalReportViewer1.DisplayGroupTree = false;
CrystalReportViewer1.HasCrystalLogo = false;
ReportDocument rptdoc;
rptdoc = new ReportDocument();
rptdoc.Load(Server.MapPath("crystalreport2.rpt"));
rptdoc.SetDatabaseLogon("sxxx", "xxxxx");
rptdoc.SetDataSource(ds);
CrystalReportViewer1.ReportSource = rptdoc;
CrystalReportViewer1.RefreshReport();
have to modify any query or how???
SATHIYANARAYANAN