I am using Crystal Report 10.2 version. I have applied paging, and when I open the 3rd page, the following error is raised:
Error in File C:WINDOWSTEMPStatReportNewV {94692B41-40A2-4F6A-9551-110BA7D78A37}.rpt: The request could not be submitted for background processing.
I m new in crystal report ?How to open a crystal report in new window but i want to pass parameter on parent window (web page)?
View 1 RepliesOur heavily-used VS2005 application uses CR (10.2) for an MSWord-formatted stream to a webservice, and for printing from a CRViewer. We continue to get "Failed to open report" or "The maximum report processing jobs limit configured by your system administrator has been reached". Once the error starts, the only remedy is recycling the application pool, disconnecting current users.
I have used the proper ReportDocument Close() and Dispose(), and even GC.Collect(), in Page_Unload. I upped the Print Job Limit from 75 to 300. After recycling I delete temp files.
1) Is there any way to monitor the use of the CR resources, to see when they increase and get close to the limit?
2) Is there any way to free them without having to disconnect users?
I suspect users are simply closing their browser after printing from an open CR Viewer. It would still go through Page_Unload, right? So maybe I would benefit from closing and disposing the CR Viewer in Page_Unload as well as the click that returns them to the application.
I had assumed that to permit users to page through the report, the CR Viewer had to have ViewState enabled, and remain open through Page_Unload.
in my project i have a gridview,and i provide a print option for every row...if i print the selected row it will be printed in the crystal reports..its working fine..what i need is ,when i click the print option it will opens in pdf format....i tried but when i click the print option a pop up box will displayed like open with and save us..i dont need like that.if i click the print option it will open directly in pdf format..how?
Here is my code
Dim CrystalReport As New ReportDocument CrystalReport.Load(Server.MapPath("CrystalReport.rpt")) CrystalReport.SetParameterValue("fname", fname) CrystalReport.SetParameterValue("lname", lname) CrystalReport.SetParameterValue("company", company) CrystalReport.SetParameterValue("desig", desig) CrystalReport.SetParameterValue("dept", dept) CrystalReport.SetParameterValue("tsalary", tsalary) CrystalReport.SetParameterValue("gsalary", gsalary) CrystalReport.SetParameterValue("npayable", npayable) CrystalReportViewer1.ReportSource = CrystalReport Response.Buffer = False Response.ClearContent() Response.ClearHeaders() CrystalReport.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, True, "Employee")
I am developing we application using Csharp on Visual studio 2008.How can I pass values from Page or GridView to a Crystal Report? For example I want some details on a Default.aspx want to appear on the Crystal report when I click on it. How do I pass theses values from Page to crystal report at Runtime?
View 3 RepliesI am working with Parametrized Crystal Reports. There are only two page called Source.aspx and Target.aspx.
[code]...
Only One text box data shows Not 2nd One.Can any one help me with this by checking my code?
I create an ASP.NET Crystal Report Web application using VS.NET 2010. In ASP.NET page, I stored two values in Session state and need to pass them as input parameters to Oracle stored procedure. In Crystal reports 2010 once you connect to a stored-procedure as data source, it automatically creates the parameter fields with Crytal Report Viewer. how I pass values to store procedure at runtime automatically.
Detail code:
1. ASP.NET page store the values in the Session:
Sesion.Item("CourseNumber")
Sesion.Item("StudentNumber")
2. I like to pass above values to the store procedure with IN parameters named P_CourseNo and P_StudentNo to print out the Crytal Report with Store Procedure as data source.
using crystal report in VS 2005 C#. I want to print multiple copies(3) of a same report in a single page. Is is possible.
View 1 RepliesI am using Crystal Report 2010 with C#, have a web form and want to display Page N of M to user in a Label while printing crystal repots. How can I implement this?
View 2 RepliesI got an ASP.net Page that display a Report.I need to display that report in a new page.
I'm thinking in passing the DataSet as a Session Variable.
Is there anyway I can open the PDF in a new page instead of the same page in ASP.net.
I am calling this code on click of a button. I want this to be opened in a new page.
Below is the code
ReportDocument fpReport = new ReportDocument();
fpReport.FileName = Server.MapPath("~/Report.rpt");
fpReport.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, false, "MyReport");
I am new to asp. I need to generate a report of a registration form in a new page. how to create a report in a blank page and download that page as a word or pdf document..
View 1 RepliesI have problem when i create a crystal report. follow the requirement from customer, i need to show a report that list all data of 3 tables that it does not have any relationship between them in only one Report. It will show:
Table A:
-- column A.1 | col A.2 | col A.3
Table B:
-- col B.1 | col B.2 | col B.3 | col B.4
Table C:
-- col C.1 | col C.2
So, how do i need to do to show the report same as above?
using vb.net 2005 and crystal reports. in the vb.net code I am querying the database, processing the results and then binding to the crystal report.
What I need to do now in the code is this: I need to create a new page to display the results so that there is one page for each row in the dataset that I'm binding to the report.
I have an asp.net ERP website with Master - Child (Content) Page architecture, where I have two buttons to view a report. One is to view report in crsyral report viewer and second is to view report as pdf.
I am exporting the report to pdf via report.ExportToHttpResponse(...). I am able to export it and it opens in a new tab of browser, thats fine! But opening report in some new tab looks like this tab is not a part of my website, you know it just show pdf, no header, no footer, no menus.
I want that when I click on View as PDF, it should export report to pdf and instead of opening into a new tab, it should open the pdf into same content page. I don't want to use report.ExportToDisk(....) because there are numerous reports in my application and user will view them many times a day. So exportToDisk will not be suitable as it will always export as a file to server and there will be a huge collection.
I have a webpage in my website, and this webpage inherits a masterpage
In the content area, I need to display some sql server reports. Depending on the link clicked, the url for the report is generated, and the report is to be displayed in the content area of the parent page.
For this, an iframe is used on the content page. Depending on the lick clicked, the url is generated dynamically, and asigned to the src attribute of the iframe.
Though this appraoch opens up the report fine, but it leads to some problems
1. Once the report is displayed, clicking any of the menu items in the master table , does not take any effect. Whereever the user might click, the url does not does not change and the sql server report is displayed.
2. On IE8, it results in a blank page. The sql server report is not rendered.
I have no problems viewing data on local machine but for some reason I cannot view that same report on the web. When i view source of the web page I can see data inside the javascript but the page is blank. What could I be doing wrong?
View 2 RepliesRuntime Error Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine. Details: To enable the details of this specific error message to be viewable on remote machines, please create a tag within a "web.config" configuration file located in the root directory of the current web application. This tag should then have its "mode" attribute set to "Off". Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's configuration tag to point to a custom error page URL. ----------------------------------- This error will be display when I am try to show the Crystal Report. Can anybody tell me what Property I have to ser in Windows Server 2008 R2 or in IIS7???
View 1 Repliesa myth has been passed to me by a senior who told me to 'always' design a crystal report using Add command and not through the table view (like selecting tables and linking them manually).I have been having a hard time writing the queries for master detail reports and making sub report links manually. It gets pretty confusing sometimes.I find it easy to design reports by just selecting two tables and dragging and dropping the link in crystal report designer.
View 1 Replies<connectionStrings>
<add name="SchoolEntities" connectionString="metadata=res://*/SchoolModel.csdl|res://*/SchoolModel.ssdl|res://*/SchoolModel.msl;provider=System.Data.SqlClient;provider connection string="Data Source=.;Initial Catalog=school;User
ID=sa;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient"/>
</connectionStrings>
how report read this connection string
using vs.net 2005, sql server 2005, creating windows form appI have a dataset that I bound to a crystal report as follows:
[Code]....
and in the Crystal Report in design view I added a Text Object called "myTxtObj".I am assuming that I can do something like this
[Code]....
However I'm not seeing the "myTextObj" with intellisense in the code behind in the form.so my question is: after binding a dataset to a report how to you bind column values to text objects on your crystal report?and actually one mor thing:I just ran the project and found out when I try to do the databind that i'm getting an error:"The report has no tables"how to solve this too?
I got a code from internet for creating Crystal reports in Visual studio 2008 .net. It shows on how to pass parameters from web form to Crystal reports. Everything is ok, except the report crystal report viewer. How can I declare and assign report crystal report viewer manually in Visual studio .net?.
[Code]....
Is it possible to show 3 "Crystal Report" in single "Report Viewer Control" page??My current code for 1 Crystal Report and 1 Report Viewer control Page is below:Below code Page name is "JpsCrystalReport.aspx"
using CrystalDecisions.CrystalReports.Engine; //for crystal report
using CrystalDecisions.ReportSource;
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLConnectionString"].ConnectionString);
[code]...
I want that when i click on button it redirects to "JpsCrystalReport.aspx" page as per condition given. Then on "JpsCrystalReport.aspx" page it should execute the 3 crystal reports as per conditions given on button click.Or I had to create 3 different "JpsCrystalReport.aspx" pages (that contains Report Viewer control) to show 3 Different Crystal Reports as per condition on button click?
I have a Registration form with two Buttons "Save" & "Report". When I click on "Save" the data will store in the Database. Now I want when click on the "Report" button the report of that particular will be produce in the Crystal report. How can I do that??
View 2 Repliesi upload my site on server but there is error in crystal report web.comfig there is error as belowParser Error Message:Could not load file or assembly 'CrystalDecisions.ReportAppServer.ClientDoc, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.
[Code]....