一个sql语句

[andy19801210]

我的sql语句是这样写的，但怎么在报表中显示不出时间呢？
sqlStr = "SELECT SUM(CAST(BUY_NUM AS numeric)) AS buy_num, SUM(CAST(MONEY AS NUMERIC)) AS money, " +" COUNT(USER_NO) AS COUNT, max(B_DATE) FROM M_BUYDETAIL WHERE ";
if( i == 1 )
for_year = Convert.ToString(int.Parse(cboYear.Text) - 1);
else
for_year = cboYear.Text;
sqlStr += "b_date between '" + for_year + reader["datestar"].ToString() + "' and '" + cboYear.Text + reader["dateend"].ToString() + " 23:59:59'";
reader.Close();
SqlDataAdapter da = new SqlDataAdapter(sqlStr, sg_mainForm.m_connStr);
da.Fill(dsSum, "BuyTotal");
MessageBox.Show(dsSum.BuyTotal[i].ToString());

crReportDocument.SetDataSource(dsSum);
crv.ReportSource = crReportDocument;

[delbrueck]

如果SQL中用了公式就要注意了