Best way to show report in web application

Question

1.00/5 (2 votes)

See more:

Can anyone tell me what is the best option to show report in web application.I have developed a web application using crystal report but it requires web sql server connection when it loads every time.So it takes long time to show report.I want a method which will show a report in minimum time.

Posted 20-Mar-14 3:44am

Sandip Paul 491984

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Raul Iloc · Answer 1 · 2014-03-20T04:02:00

Solution 1

This depends of the report complexity and data amount, but as I know Crystal Reports is one of the best solution for reporting, so maybe you have problem in your database structures (tables, relationships and indexes) that could be improved.

Posted 20-Mar-14 4:02am

Raul Iloc

Comments

Sandip Paul 491984 20-Mar-14 10:42am

ReportDocument cryRpt = new ReportDocument();
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables CrTables;
var path = Server.MapPath("reportfiles\\PTaxLoc.rpt");
cryRpt.Load(path);
crConnectionInfo.ServerName = "50.2.1.1";
crConnectionInfo.DatabaseName = "Apex";
crConnectionInfo.UserID = "DB_admin";
crConnectionInfo.Password = "dbAdmin1";
CrTables = cryRpt.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}

CrystalReportViewer1.ReportSource = cryRpt;
CrystalReportViewer1.RefreshReport();

This is my code .can you tell me is this anything wrong?

Raul Iloc 21-Mar-14 3:16am

The code seems to be OK, so your performance of your report depends on the design of your database, the amount of data used in your report, and the SQL server speed and loading.

Sandip Paul 491984 22-Mar-14 1:30am

instead of using dataset i am using a temp table in which i inserting the values from a gridview and then connecting the table with my report.is the way is correct? please suggest me...