I have made an asp.net web application using VS 2008 to show crystal reports. I have used CrystalReportViewer control to show reports.
The table (sql server 2005 ) from which I have to fetch data has approximately 400000 records. I connect to it using OLEDB ( Microsoft OLEDB provider for sql server )
I have wrote the following code to achieve this :
[code]....
I have crystal report in asp.net 2.0 C# application..
It took me lot of time to show report at first time..
How to make fast to show report in some 10 sec or below..
I have used CKEditor in my ASP.NET pages. But after than, that pages are very slow. Is it possible that it is caused by CKEditor?
View 1 RepliesWhen I run my piece of SQL through SQL developer it takes less than half a second with an overall cost of 618 on the explain plan.
When I run the same SQL through .NET via the oracle.dataaccess.client connection it is impossibly slow taking over 5 minutes to run.
What could be causing this and what can I do?
I have two applications(A,B) both are developed in .NET3.5 and used LDAP services.Application-A in one screen we are fetching users with role "project Leads" and it is taking 10 min time
Application-B in login screen we are checking user is authenticated or not and it is taking 20 sec
Both the applications are using the same service then way there is a time span problem. Please suggest me what can I do to improve performance of application A?
Let's say you set maxRequestLength to the max number (2097151) (units are KB) and use the following code for your OnClick event for your submit button:
int int fileSize = FileUpload1.PostedFile.ContentLength;
if (fileSize < 2000000)//units are bytes
Label1.Text="too big";
else
{
FileUpload1.SaveAs(saveItHerePath);
Label1.Text = "Upload success.";
}
Why when a huge file is attempted does it take a minute to get to the OnClick event on the server? Because if maxRequestLength were set to that value 2000, it would immediately choke if you tried to upload a 500MB file. What is going on here? What are the best practices for using the FileUpload control? Is there a better alternative way of uploading or checking for file size?
I'm new to Visual Studio.NET . I need to integrate the crystal reports into an ASP.NET application. I generated Crystal report with the help of crystal report XI developer edition(Stand alone version and NOT from the one which comes from visual studio).
How to integrate this report with the web application.
I want to make a chart in web application i(ASP.NET using c#)
but i am not able to make a chart in crystal report
send me a sample of chart in crystal report
When i run the application locally it works fine but when i publish it n access from it it gives the error asEither the Crystal Reports registry key permissions are insufficient or the Crystal Reports runtime is not installed correctly.
View 2 Repliesto print a crystal report from the server's printer with a button on the web application.Assume that I have a ASP .NET Web Application, When i press the "print" button on the web application, the server which holds the web application prints the specific crystal report with specific data set. Is this possible? How I am going to make this happened?I am sorry to say that I'm very new to all these web programming,
View 3 Replieswhen I access any page of my ASP.NET MVC website first time, then this first request is slow. It needs about 4-5 seconds to load. But every following request to any page is fast.When I wait some minutes or a hour then every first request is slow again. Every following request is fast.
I think that IIS 7 is compiling the code and keep it in memory. After some time it will delete it from memory so it needs to compile it again.What can I do that every first request is as fast as every following request?
(Without precompiling my source, if possible)
We have just migrated our Application's reports from Crystal Report 10 To 12. But on conversion everything goes fine.Except the reports which are built on Typed data sets started genrating the Message "The report you requested requires further information".
with the login parameters dispalying on the page.{Note: we are using Visual Studio 2005 (framework2.0)}
e.g
Server name
Database name
user
password
Just like in title. It works much faster on IE (8, 9) than on firefox and chrome ?How is it possible ?
Whats more I had to disable cookies on aspxGridViews because I had bad requests all the time,
I know it's not the best practice to do, but unfortunately I created a page with multiple large dropdown lists and have them inside an ajax updatepanel. I found some work arounds using siderite's ajax updatepanel adapter:
http://fastlistadapter.codeplex.com/.
The performance is very good while I am debugging on my machine, but when I publish the site and post it to a win 2003 server the performance drops off almost as bad as when the fix isn't there.
I understand that using a 3rd party fix really isn't supported by most, but is there any obvious reason why debug performance would be much better than published site performance on the same exact code?
We recently migrated to v4 of .net. We are running iis 7 in integrated mode. When the site first starts its slow. I get that - it compiles for the first time. The odd thing is then we will go to certain pages and it seems to compile again. The next time i go that page its very fast. Nothing exceptional with the second page - but once that is hit the rest of the site is fast.
View 1 RepliesI want to mak a Dynamic Report Generator with the facility to create the report structure and change the report information.
whether I can use any crystal report generating tool or have to make my own report generator
Using VisualWebDeveloper 2010 on the development machine. All nice and fast.Using VisualWebDeveloper 2008 on the server. Server runs on Windows Server 2008 and has IIS 7.
It looks like that when 'table', a datatabe filled up in C# code behind, is getting longer, then the server (whether running the website on IIS or on the local host of VIsualWebDeveloper2008) is really slowing down. Checked it in debug mode and traced it down to
Adapter.Update(table);
Are there any know issues? Could it be that there is incompatibility between different version of SQL server or something like that? The update works, it is just awefully slow, but only on the server.
We have quite a few reports which were developed earlier in Crystal Reports 8.5. We are now planning to use these reports in our web application developed in VS 2008 (C#).
What dlls are needed for calling 8.5 in the application and how should they be added to the application while shipping it to the client?
They are also struggling to get the code running. Would also need the code to call the report with parameters.
I have already generated crystal reports but i've made them static. but now i want to make the user to select the criteria for generating the reports. for eg., in one of them i want to show monthwise data so user should be able to select the month and year and that would be passed as parameter and compared to the existing data. provide me with proper exact code that can be used for giving parameters in such a report using C#.
View 3 RepliesTrying to preview a crystal report in pdf format in web application by passing parameter but showing error message:
crReportDocument.Export()
missing parameter value
<CODE>
Dim crExportOptions As ExportOptions
Dim crDiskFileDestinationOptions As DiskFileDestinationOptions
Dim Fname As String
crReportDocument.Load(Session("rptFileName"))
CrystalReportViewer1.ReportSource = crReportDocument
CrystalReportViewer1.RefreshReport()
CrystalReportViewer1.ParameterFieldInfo.Clear()
Fname = "C:TempTemp.pdf"
crDiskFileDestinationOptions = New DiskFileDestinationOptions()
crDiskFileDestinationOptions.DiskFileName = Fname
crExportOptions = crReportDocument.ExportOptions
With crExportOptions
.DestinationOptions = crDiskFileDestinationOptions
.ExportDestinationType = ExportDestinationType.DiskFile
.ExportFormatType = ExportFormatType.PortableDocFormat
End With
If Session("rptType") = "PrintOption0" Then ' Without Parameter
' no need to do anything
ElseIf Session("rptType") = "PrintOption1" Then ' One Parameter
paramField.Name = "@UserID"
paramDiscreteValue1.Value = Session("rptParameter1")
paramField.CurrentValues.Add(paramDiscreteValue1)
paramFields.Add(paramField)
CrystalReportViewer1.ParameterFieldInfo = paramFields
End If
crReportDocument.Export()
Response.ClearContent()
Response.ClearHeaders()
Response.ContentType = "application/pdf"
Response.WriteFile(Fname)
Response.Flush()
Response.Close()
' delete the exported file from disk
System.IO.File.Delete(Fname)
</CODE>
The application basically displays a list of reports and allows the user to select a particular report to run. Once the report is selected, the appropriate parameter screen is displayed. The parameter screen contains options for displaying the report either as an Excel Spreadsheet or a PDF document.
When I run the application from within visual studio, it works fine. The reports display correctly in both formats.
THe problem is that once I publish the application (via msi installation file) to a Windows 2003 web server, the reports won't display. THe system just hangs. I added debug statements and the code is hanging during the ReportDocument.Load(Server.MapPath("/assetreport.rpt") command.
My deployment project includes the correct msm for Crystal Report 12 and the Web server also has the full blown version of Crystal Reports 12 installed.
In my system Visual studio 2008 with sp1 and Crystal Reports XI Release 2.In Visaul studio 2008 ,while adding add reference it showing crystal reports version 10 instead of 11.How to solve the version problem.
View 1 RepliesI am considering using Crystal Report 2008 as my tool of creating reports on my webpage.The only problem which I'm facing is that I have no control of the remote server which hosts my site (besides uploading files). I can't run a MSI to deploy the CR runfiles.I can't find anywhere in the CR user manual of how to deploy the runtime files without running the msi, and I'm not even sure it's possible.Have anyone deployed CR 2008 without running the MSI and without having to register any files?
View 8 RepliesI have a field in my dataset with type nvarchar(1000). when I link it to crystal reports, it converts it to a field of type string with length set to 100. As a result of that, the string in that field is being truncated on the report. How can I increase the string length to 1000? (I already checked the "Can grow" option).
View 3 RepliesI am getting error as below
Could not load file or assembly 'CrystalDecisions.CrystalReports.Engine,
Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304'
or one of its dependencies. The system cannot find the file specified