c# - How to fix SQL order by issue with Crystal Report
问题描述
I am facing sorting (order by) issue while binding data table with crystal report. This is my query "SELECT * FROM Payments WHERE (PayDate BETWEEN @startdate and @enddate) order by Id", Query returns sorted record in datatable but when I bind this result to crystal report it gets unsorted. Please suggest solution to this issue.
I have tried this code
DbCommand dbComm = BaseDB.CreatestrCommand();
dbComm.CommandText = "SELECT * FROM Pavti WHERE (PayDate BETWEEN @startdate and @enddate) order by PavtiNo";
//dbComm.CommandText = "SELECT * FROM Pavti WHERE PayDate BETWEEN " + fdt.ToShortDateString() + " and " + tdt.ToShortDateString() + " order by PavtiNo";
DbParameter dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@startdate";
dbParam.Value = fdt;
dbParam.DbType = DbType.Date;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
dbParam = dbComm.CreateParameter();
dbParam.ParameterName = "@enddate";
dbParam.Value = tdt;
dbParam.DbType = DbType.Date;
dbParam.Direction = ParameterDirection.Input;
dbComm.Parameters.Add(dbParam);
DataTable fieldData;
try
{
fieldData = BaseDB.ExecuteSelect(dbComm);
}
catch (Exception exc)
{
throw exc;
}
return fieldData;
I need sorted records in crystal report
解决方案
您的问题在报告中,而不是在查询中。使用报表设计器中的报表排序专家来确定要排序的字段。
推荐阅读
- xamarin - 有没有办法混合原生代码屏幕和 Xamarin 屏幕
- javascript - 正则表达式:在正则表达式中搜索相同的值
- raku - Perl6:无法调用此对象(REPR:P6opaque;Parallel::ForkManager)
- git - 显示公共存储库目录树
- bash - 为什么除非用大括号括起来,否则“set -x”(xtrace)输出不受重定向的影响?
- express - 连接闪光灯不在 Pug 中显示消息
- python - 如何将 panda DataFrame 中特定范围的元素转换为浮点数?
- c++ - 来自抽象基础的反序列化对于 boost 序列化失败
- python - 将 DataFrame 列连接成字符串
- c# - $Cond 和 $Eq 在 $Project - C# 驱动程序 MongoDB