I am new to crystal reports... I am using a dataset for the report which gets data from stored procedure .. And i am using crystalreportviewer to view the report in .aspx page.. When i pass id to the .aspx page containing the crrystalreportviewer i get the above mentioned error.. I am clueless how to fix it..
View 2 RepliesI 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 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.
I have a new issue, i am working with crystal report 2008 in ASP.NET 2.0
I am trying to call Crystal report through ASP.NET page
the issue is, system DSN is not allowed to create on the server.
how i can create DSN and pass database credential through a ASP.NEt 2.0 page to call a crystal report
previousley i am doing like this on a local machine to call a report
crConnectionInfo.ServerName = "dsn_Name"
crConnectionInfo.DatabaseName = "DB_Name"
crConnectionInfo.UserID = "sa"
crConnectionInfo.password="password"
but i am not able to create or system DSN is not allowed to create on the production server.
please help that wt are the other way to call the crystal report 2008 through asp.net 2.0
i can develop crystal report with password itself.But, i want to pass values in to crystal report programatically..
View 1 Repliesi need to pass parameters into the crystal report...i am using asp.net with c#
View 1 RepliesCrystal
Reports Error when publishing a Website on to the Web Server---- The type initializer for 'CrystalDecisions.Shared.CrystalReportClientScriptManager' threw an exception
I'm trying to load up my website but I keep getting this error on page loads:
Server Error in '/' Application.
Configuration Error
Description:
An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Could not load file or assembly 'CrystalDecisions.CrystalReports.Engine, Version=14.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.
Source Error:
[Code]....
Line 17: <compilation targetFramework="4.0">
Line 18: <assemblies>
Line 19: <add assembly="CrystalDecisions.CrystalReports.Engine, Version=14.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
Line 20: <add assembly="CrystalDecisions.ReportSource, Version=14.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
Line 21: <add assembly="CrystalDecisions.Shared, Version=14.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
I'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.
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 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 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]....
ent system (Windows 7 x64) and live system (Server 2008 x64), and both with IIS7 I receive the following error message, after clicking the "Print" button in the printer selection popup."An error occurred on the server. Printing will be stopped. Would you like to view the error information?"If I click "y
View 1 RepliesWe have migrate from VS2005 to VS2010. CR2010 installed too.
We have 1 website and class project in one solution.
The assembly of web.config has point to new version of CR ver13 and also checked that the references is ver13 too.
WEB CONFIG:
[code]....
However in code behind, when "Go To Definition" the imported CrystalDesicions Namespace, it go to CR version10 location.
The class project has references to correct ver13.
In the end we get error of :
Error 17 The project currently contains references to more than one version of CrystalDecisions.CrystalReports.Engine, a direct reference to version 10.2.3600.0 and an indirect reference (through 'Web_cl.clsAccountRpt.GetAccountStatementSummaryRptDoc')
to version 13.0.2000.0. Change the direct reference to use version 13.0.2000.0 (or higher) of CrystalDecisions.CrystalReports.Engine. D:ProjectWebGlobal 4.0Web_developCpAdminReportFormAccountReportModule.aspx.vb 40 28 D:...Web_develop
The function in class has return ReportObject back to the website, because of the website reference did not really point to new version has causes this error. I have checked all references in web.config and project properties all is point to new version, but in program it seems still point to old one.
I am using the following code to pass parameter from VB to crystal report but getting the error messgae "Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))" while it trying to add the first parameter. This chunk of coding works in another VB perfectly. The only diffferent is the working one takes the parameter to stored procedure where the failed one I added parameter during crystal report design time.
[Code]....
I have recently tried to develope a crystal report using a clss file, like passing the class variable into report file. Passing the values and displaying was successful but when i click on the printer button or Export button in Crystal report viewer in my Aspx page, It is asking for Database name,Suser id and password for the Class file and which i never assigned and no there is no database to the class ... It is not allowing me to take the print out of the page..
View 6 RepliesI created a CR which data source is a store procedure. Within the store procedure there is one parameter. How to pass a value to the parameter and display CR on the screen?
View 1 RepliesI defined a report with a parameter (ID_Aluno) in Crystal Reports to show it in an .aspx page. The page is called by another page passing it a query string with the value I need as a parameter in the report. In the code behind file I tryed three different approches without success. What happen is that the report is showed without data, but when I open the parameter panel I see that the parameter is there (If I don't set the parameter value actually it complains that the parameter is missing, giving an arror).
Here is the code I used to set the parameter:
[Code]....
The First try (code not commented) is the one I would like to use because it is the shorter and simpler one.
Here is the mark up for the report source and report viewer:
[Code]....
Have I to declare or define something special in Crystal Reports for the parameter to be received and applied?
How to pass sql query to crystal report programmatically using c#
View 1 RepliesUsing Crystal Report to view reports on the site and noe able to pass parameters succesfully.
Heres the code:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Report.aspx.cs" Inherits="MATReports.Report" %>
<%@ Register Assembly="CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" Namespace="CrystalDecisions.Web" TagPrefix="CR" %>
[Code].....
I am developing a web application and I am using a crystal report for my project, how can I pass the query string to the crystal report using the database.
View 1 RepliesI'm passing some parameters to a CR report programatically and it was working fine, but now that I have added a new date parameter to the report, for some reason, it is prompting me to enter that parameter on screen (the user isn't allowed to set that parameter is the system who must set it.), I haven't changed a thing other than adding the new date parameter, and all the other parameters behave normal, just the date parameter is prompted even thought I've already set a value for the parameter.
This is the code I've got:
private void ConfigureCrystalReports()
{
crystalReportViewer.ReportSource = GetReportPath();
[Code]....
Just for the sake of things: I have checked that the parameter is indeed a date and that it is well formed. CR prompts me to enter it in the format (mm/dd/yyyy hh:mm:ss) so I pass date in that exact format (In fact I've even tried hard coding a well-formed date and it still prompts me to enter the date).
I need to pass some data from text box ( ie dump from textbox ) to crystal report how can ido it using formula field in c# i have textbox1.text="INDIA" how do i display the value from textbox in crystal rpeort using formula field.
View 1 Repliesi want to show a crystel report on page load of page. where i want to show report of those student who logged in the system and their session is created.
View 1 Repliesparameter field {?country}: string
allow diffrent values: true
selection record: table.country in {?country}
when i pass one parametrs it's works fine.
rd.SetParameterValue("country", DropDownListSalle.SelectedItem.Text);
my question is how can i passing multiples values (tokyo,usa,india,...) ?