CrystalReport需要花费一些时间来加载 [英] CrystalReport taking time to load

问题描述

我正在开发项目，需要在其中生成报告.我正在使用Crystal Report.并使用以下代码.

I am Developing project, where I need to generate report. I''m using Crystal Report. and using the following code.

SqlConnection con = new SqlConnection();
con.ConnectionString = Global.constr;
con.Open();
SqlDataAdapter da3 = new SqlDataAdapter("select * from salesDetails where sl='" + textBox1.Text + "'", con);
DataSet ds3 = new DataSet();
da3.Fill(ds3, "SalesDetails");
RptBill1 abc = new RptBill1();
abc.SetDataSource(ds3.Tables[0]);
crystalReportViewer1.ReportSource = abc;
crystalReportViewer1.Refresh();

其执行完美.但是
现在我面临两个问题:
1. CrystaReport花费太多时间来加载.如何快速加载报告.[我的表结构不允许我在sqlServer中实现索引]
2.如果我的salesDetails表包含多于29条记录，则转到下一页.现在，我的报表页脚包含销售总额，折扣总额等.转到下一页.
我的简单问题是如何通过设置页面的高度-宽度来更改CrystalReport的页面大小.那里有pageSize名称.但这与我的要求不符.我想要一种自定义格式来指定页面的高度和宽度.
请帮助我解决上述问题.

Its executing perfectly. But
now I am facing two problem:
1. CrystaReport taking too much time to load.How can I load the report very fast.[my table structure doesn''t allow me to implement Indexing in sqlServer]
2. If my salesDetails table contains more than 29 records then its goes to the next page. Now my report footer contains salestotal values,discount total etc. went to next page.
My simple question is how to change the page size of a CrystalReport by setting the page Height-Width. There we have pageSize names. but that doesn''t matche with my requrentment. I want a custom format to specify Height and width of the page.
Please help me to solve the above mentioned problems.

推荐答案

在代码项目中，我已经在这里回答了类似的问题.所以你去

Already I have answered similar questions here before in Code project. So here you go

OP写道:

1. CrystaReport加载时间太长.如何快速加载报告.[我的表结构不允许我在sqlServer中实现索引]

1. CrystaReport taking too much time to load.How can I load the report very fast.[my table structure doesn''t allow me to implement Indexing in sqlServer]

报表分析器:优化Crystal报表 [ ^ ]
优化报告效果 [优化Crystal报表 [ ^ ]
Crystal Reports使用.NET C#缓慢加载(SetDataSource) [ ^ ]

Report Analyzer: Optimize Crystal Reports[^]
Optimizing Report Performance[^]
Optimizing Crystal Reports[^]
Crystal Reports Slow Load Using .NET C# ( SetDataSource )[^]

OP写道:

2.如果我的salesDetails表包含多于29条记录，则转到下一页.现在我的报表页脚包含销售总额，折扣总额等.转到下一页.

2. If my salesDetails table contains more than 29 records then its goes to the next page. Now my report footer contains salestotal values,discount total etc. went to next page.

限制晶体报告上每页的记录数 [限制记录数将显示在Crystal Report中 [

LIMITING THE NUMBER OF RECORDS PER PAGE ON A CRYSTAL REPORT[^]
Limiting the number of records to be displayed in Crystal Report[^]

OP写道:

我的简单问题是如何通过设置页面的Height-Width来更改CrystalReport的页面大小.那里有pageSize名称.但这与我的要求不符.我想要一种自定义格式来指定页面的高度和宽度.
请帮助我解决上述问题.

My simple question is how to change the page size of a CrystalReport by setting the page Height-Width. There we have pageSize names. but that doesn''t matche with my requrentment. I want a custom format to specify Height and width of the page.
Please help me to solve the above mentioned problems.

水晶报告显示问题 [在Windows中创建自定义纸张尺寸或表格 [ ^ ]
Crystal报表页面大小 [报告模型 [

Crystal report display problem[^]
Create custom paper sizes or forms in Windows[^]
Crystal report page size[^]
Reporting Model[^]

这篇关于CrystalReport需要花费一些时间来加载的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！