如何快速检索水晶记录中的记录？ [英] how to retrieve fastly record in a crystal record?
问题描述
晚上好，我有一个问题记录是不是通过水晶报告在数据库中快速检索。视觉研究2010年sap水晶报告。你有什么想法从数据库快速检索数据。我在员工表中有超过100000条记录。请帮我。尽快。
我的代码是：----------
try
{
SqlDataAdapter da = new SqlDataAdapter（SP_Employee_Details，con）;
da.SelectCommand.CommandType = CommandType.StoredProcedure ;
Employee_DataSet13 ds = new Employee_DataSet13（）;
da.Fill（ds）;
Employee_Report rpt = new Employee_Report（）;
rpt.SetDataSource（ds.Tables [1]）;
crystalReportViewer1.ReportSource = rpt;
crystalReportViewer1.Refresh（）;
}
catch {}
感谢advence。
问候
呃。 Hem Raj Thakur
hi good evening to all I have a problem record is not fastly retrieve in database through crystal report. visual Studion 2010 sap crystal report. have you any Idea to retrieve fastly data from DB. I have more then 100000 record in a employee table. Please help me. as soon as possible.
and my code is :----------
try
{
SqlDataAdapter da = new SqlDataAdapter("SP_Employee_Details", con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
Employee_DataSet13 ds = new Employee_DataSet13();
da.Fill(ds);
Employee_Report rpt = new Employee_Report();
rpt.SetDataSource(ds.Tables[1]);
crystalReportViewer1.ReportSource = rpt;
crystalReportViewer1.Refresh();
}
catch { }
thanks in advence.
regards
Er. Hem Raj Thakur
推荐答案
一次有数百万条记录？为什么？这不是一个好方法。
在显示数据时使用分页/过滤。这里有一篇关于如何使用分页技术获取更少数据的文章。
SQL Server 2005分页结果 [ ^ ]
Sameway，使用选择公式 [ ^你可以过滤数据。过滤条件取决于您的要求。如显示特定客户详细信息或两个详细信息等，
在继续报告部分之前，您应该考虑优化数据库。检查此系列以进行数据库优化
优化SQL Server中数据访问的十大步骤：部分我（使用索引） [ ^ ]
在SQL Server中优化数据访问的十大步骤：第二部分（重新考虑因素） TSQL并应用最佳实践） [ ^ ]
在SQL Server中优化数据访问的十大步骤：第三部分（应用高级）索引和非规范化） [ ^ ]
优化SQL Server中数据访问的十大步骤：第四部分（诊断数据库性能问题） [ ^ ]
优化SQL Server中数据访问的十大步骤：第五部分（优化数据库文件并应用分区） [ ^ ]
查看有关Crystal报表中大数据处理的这些帖子/讨论
处理ASP.NET和Crystal中的大型数据集报告 [ ^ ]
尝试从CMC和Infoview查看时Crystal Reports无法加载 [ ^ ]
提高Crystal Reports 5.0中报表处理速度的提示 [ ^ ]（旧的但仍然可以在这里找到一些有用的细节）
如何提高Crystal Report的性能，使其运行得更快 [ ^ ]
Crystal Reports 2011慢慢运行一些报告 [ ^ ]
Crystal Runtime异常：指针无效 [ ^ ]
Crystal Reports 2011： Give'em他们想要什么！ [ ^ ]
检查这些以获得水晶报告优化
优化报告性能 [ ^ ]
优化Crystal Reports [ ^ ]
Crystal Reports：5次测试以获得最佳性能 [ ^ ]
Crystal Reports 2008 - >绩效改进技术 [ ^ ]
CrystalReports性能提示 [ ^ ]
加载测试Crystal Reports缓存功能 [ ^ ]
负载测试具有高可共享性缓存的Crystal Reports [ ^ ]
这就是我的全部......
Millions of records at a time? why? that's not a good way.
Use paging/filtering while displaying the data. Here an article about how to get less data using paging technique.
SQL Server 2005 Paging Results[^]
Sameway, using Selection Formula[^] you could filter data. Filter criteria depends on your requirement. Like displaying particular customer details or between two details, etc.,
Before proceeding reports section, you should consider optimize your database. Check this series for database optimization
Top 10 steps to optimize data access in SQL Server: Part I (use indexing)[^]
Top 10 steps to optimize data access in SQL Server: Part II (Re-factor TSQL and apply best practices)[^]
Top 10 steps to optimize data access in SQL Server: Part III (Apply advanced indexing and denormalization)[^]
Top 10 steps to optimize data access in SQL Server: Part IV (Diagnose database performance problems)[^]
Top 10 steps to optimize data access in SQL Server: Part V (Optimize database files and apply partitioning)[^]
Check these posts/discussions regarding large data handling in Crystal reports
Handling Large Data Sets in ASP.NET and Crystal Reports[^]
Crystal Reports Fails to load while trying to view from CMC and Infoview[^]
Tips to Improving Report Processing Speed In Crystal Reports 5.0[^](Old one but still you could find some useful details here)
How to increase the performance of a Crystal Report so it will run faster[^]
Crystal Reports 2011 running some reports slowly[^]
Crystal Runtime exception: Invalid pointer[^]
Crystal Reports 2011: Give'em what they want![^]
Check these for crystal reports optimization
Optimizing Report Performance[^]
Optimizing Crystal Reports[^]
Crystal Reports: 5 Tests for Top Performance[^]
Crystal Reports 2008 -> Performance Improvement Techniques[^]
CrystalReports Performance Tips[^]
Load Testing Crystal Reports Caching Features[^]
Load Testing Crystal Reports with High Shareability Caching[^]
That's all I have ....
这篇关于如何快速检索水晶记录中的记录？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
