im using sap crystal report version 13.0.2000.0. i've 27,000 records to be printed but when i run my application the exception error is displayed "Out Of Memory".. i've my appliation in VS2010 and OS is server 64bit and 4GB RAM..
View 1 RepliesI am having one Asp.net 3.5 application with SQL Server 2005 backend. I am generating few complex crystal reports with some formula in crystal itself and complex paging and grouping constraints. Now we are planning to atomize this process. We have 10 reports on the screen so:
--user will click on each report
--report get open in Crystal Report Viewer
--User will generate PDF from crystal report.
Now, we are thinking to atomize this, rather than giving link to crystal, we want to generate PDF directly when that page opens rather than making above three steps. Is it possible to open Crystal report in memory, save it as PDF and close it? Well, we have data so you might think that why don't we directly generate PDF from data with the tools like iTextSharp or other but in that case what about the grouping, paging, formula which crystal handle itself?
Iam getting this error when ever viewing an Crystal Report Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
Source Error:
[Code]....
Stack Trace:
[Code]....
[AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.]
CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(Object& DocumentPath, Int32 Options) +0
CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.Open(Object& DocumentPath, Int32 Options) +95
CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened() +271
[Exception: Load report failed.]
CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened() +333
CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod, Int16 parentJob) +894
CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename) +84
ReportMonthlyViever.BindReport() +192
ReportMonthlyViever.Page_Load(Object sender, EventArgs e) +5
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
Im new in using crystal report. When I view the report, the records appear with many spaces in between of each record. How can I set then to just only one spacing after each record?
View 1 RepliesWhen 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 Repliesi've connected my crystal report to my database using database experts. now my problem is i want to display the total no of records..in each page .. i.e in database there are 50 records when i execute..it takes two page to print..now in first page there are 30 records and in second page there are 20..i want to display the value 30 at the end of page and 20 at the end of page.i.e how much the page contains the records that much it should print in page footer
View 3 RepliesI have a report, which has two sections namely Labour and Spares.In labour section no of records per page must be limited to 5 records and the Spares section have to limit to 10 records per page.If either Labour or Parts exceed the max limit the records must be shown in the next page. Limiting one section by using formulas can be done easily ...but it is very difficult control two sections simultaneously.
View 4 RepliesI am trying to find a way that would allow me to display the parameters that have been selected when there are no records found
For instance.
Pulling from a database with a employee table that contains name, address, city, state, zip, job titile and shift.
i then have two list boxes set up that collect the paramets for the reports. One for the job title and one for the shift.
i want to be able to say that no records are found for "managers" on "third shift" where managers and third shift are the parameters from the listboxes.
consider the example where there is a report which displays all products or a single product from a table through a drop down list selection. The dropdown list also has a '- ALL -' selection item So the resulting query might be
Select * from products OR
Select * from products where ID={id}
Now I have a single report , I am using sql CASE for differentiating between all products or a single product. Another approach is to pass a different value with where clause in report parameters like
[Code]....
What I like to know is what is the best approach? Is doing this inside query is best or specifying the where clause in the report parameters is right? I personally feel much safe with the SQL query CASE.
I know this is probably a pretty easy thing to do and it is if I can upload the file and store it onto the hard drive of the server. What I need to do is read the text file into memory and then parse through it one line at a time. Anyone have any code that demonstrates that?
View 8 RepliesActually I am developing one web application,in that application I used a gridview to display all the database records in a page. I provide hyperlink print for every row, if I click the print option, the particular record will be print in the crystal report..
View 1 RepliesWhen running my crystal report I got the follwoing erro r
Unhandled Exception: CrystalDecisions.CrystalReports.Engine.InternalException: E
rror in File C:DOCUME~1aliLOCALS~1Temp1 emp_8b7deeee-5769-4457-8c1f-f21fa8
c49cb5.rpt:
Failed to open a rowset. at ☻.☻N(String ♠-, EngineExceptionErrorID ♠0)
at ☻.☻I(Int16 ♠!, Int32 ♠")
at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export(ExportRequestCo
ntext reqContext)
at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export()
at CrystalDecisions.CrystalReports.Engine.ReportDocument.Export()
at CMP_BL_INC_W.Module1.Main()
Also I verified the database and no errors appeared, I use .NET 2003 and crystal report 9
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.
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 RepliesI wrote the following code for my report
[Code]....
But i am getting the follwing exception: Access is denied. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Runtime.InteropServices.COMException: Access is denied
I am having 'Full permission' to E:Documents and Settings hiru.TECH27SYSTEMSLocal SettingsTemp IIS is not installed in my system. Visual studio is installed in E: My project is in D: what should i do?
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 have developed few crystal reports using VS.2005 and now i want to deploy the same on my web server which is running Windows 2003 server and got installed only .net frame work 2.0.... so now i want to know how can i run those reports successfully and i have downloaded CRRedist2005_X86.msi and even crXIsp3 and 4 _net_server from business objects page and i do have Crystal Reports XI original CD.... while by using them can i run crystal reports on my web pages.
View 1 RepliesI want report generted based on value from querystring.
View 3 RepliesCrystal
Reports Error when publishing a Website on to the Web Server---- The type initializer for 'CrystalDecisions.Shared.CrystalReportClientScriptManager' threw an exception
I'm working on a site that ws developed using VS 2005 and the server where the site is running has Crystal Reports for .net 2.0 (ver 10.2.36)I will be making changes. I just ported the website to my local computer, and build the site using VS 2008, that comes with Crystal R. Basic.I haven't tested all the functionality of the site, so I'm not sure since all the pages that use C. Reports work ok.My main concern is about publishing the site I compiled to the server. Will things work, if I have Crystal R. Basic and the server has Crystal R. for .net 2.0.
View 2 RepliesI'm getting the "Load Report Failed" Error.
I have a web application designed using VS2008 & Crystal Reports for VS2008 (Ver. 10.5.3700). I'm using Framework 2.0 for deployment.
My development system is WinXp and my deployment system is Win2003 Server.
Here is what i have done -
1) Added a Crystal Report to my project "rptReport.rpt"
2) Added a Crystal Report Source (crSource) to my .aspx page.
3) Added Crystal Report Viewer to my page, with crSource as its Report Source.
This works fine when i run it on my development machine. But Gives a "Load Report Failed" error on my deployment machine.
This is what i have already tried doing on deployment server:
1) Giving IIS_WPG full control to temp folder.
2) Publishing with "Allow this precompiled site to be updatable." checked/unchecked.
Crystal reports are properly working on my local pc but not on server. I am using vs 2008 and install crystal report for Visual basic 2008 on server.but parameter count for CrystalReport is zero on server.
CrystalReportViewer.ReportSource = Session("Rpt" & Request.QueryString("ReportGroup") & Request.QueryString("ReportCode"))[code]....