高分求解，WINFORM水晶报表问题

[flers]

private void frm_bjd_Load(object sender, System.EventArgs e)
{
strconn myconn=new strconn();
SqlConnection sqlconn=new SqlConnection("data source=FLERS;initial catalog=xtdatabaset;persist security info=False;user id=sa;workstation id=FLERS;packet size=4096");
myconn.sqlconn.Open();
SqlDataAdapter myadapter;
xtbjd bjdrpt=new xtbjd();
sqlconn.Open();
myadapter=new SqlDataAdapter("select * from products where id<20",sqlconn);
DataSet rptds=new DataSet();
myadapter.Fill(rptds);
bjdrpt.SetDataSource(rptds.Tables[0].DefaultView);
this.crystalReportViewer1.ReportSource=bjdrpt;
sqlconn.Close();
}
private void frm_bjd_SizeChanged(object sender, System.EventArgs e)
{
this.crystalReportViewer1.Width=this.Width;
this.crystalReportViewer1.Height=this.Height;
}
问题：我select * from products where id<20没作用？一打开FORM时把整张表的内容分成123页，数据全部显示出来了，并不能执行达到我所要的结果呢？试了N次，重做了N次.RPT文件，用的是WIN2003+VS.net2003＋自带的水晶报表。

[flers]

有没有人相助一把，150分相送！
http://expert.csdn.net/Expert/topic/2781/2781641.xml?temp=.0388605

[eTopFancy]

rptds重新填充数据的时候清空以下

[saucer]

are you sure? check the size of the dataset?

myadapter.Fill(rptds);
int n = rptds.Tables[0].Rows.Count;

[zhpsam109]

select * from products where id<20
这个单独拿出来执行呢?

[flers]

谢谢个位了，用eTopFancy(你的美丽我的回忆) 方法OK，
有空请看http://expert.csdn.net/Expert/topic/3035/3035435.xml?temp=.2931482