I'm working on a vb.net windows project using crystal reports for report generating.I'm using stored procedures as well.Stored procedures are used by crystal reports.When I run report with some parameters it gives error,like this " Unknown Query Engine Error ".I have checked the Stored Procedure and there is no problem with the SP, no extra parameters.
View 1 RepliesI have a project using Crystal Reports 2008, whenever I try to print the report, using the print button on the menu I get an error on one of my machines, the Crystal Print Dialog opens, completely empty and then I get a error from windows:
Windows has blocked this software because it can't verify the publisher.
Name: PrintControl.cab
Publisher: Unknown Publisher
This is only happening on my Windows 7 machine. The solution on my Windows XP machine works fine, even if I hit the site under XP from my 7 machine, so I'm assuming something didn't install properly on 7. Any ideas? The 7 machine print dialog comes up blank, just says Print on the title and then the error comes up. The XP machine Print dialog says Print in the title and says Crystal Reports Print Control before the print options come up.
I have a stored procedure, which I'm calling from ASP.Net application. I'm facing a problem in stored procedure when comparing values.Please check code below to get further details.
Stored Procedure:
ALTER PROCEDURE [dbo].[MyStoredProcedure]
(@ItemID nvarchar(50), @Weight1 float, @Weight2 float)
-- check remaining/available weight in items table
DECLARE @RemainingWeight float
SET @RemainingWeight = (SELECT RemainingWeight FROM items WHERE ItemID = @ItemID)
[code]...
I need to link 2 stored procedure in crystal report, passing same parameter id, i tried but getting error
"Unable to connect: incorrect log on parameters."
in this way i'm creating report.
1) Create Dataset(myTable.xsd) in App_Code folder
2) Create a blank Crystal Report, Field Explorer getting Database Fields, from Database Expert (ADO.Dataset Objects), selecting the
myTable.xsd Dataset
3) Drag the fields in Crystal Report n Execute
When 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
am using a crystal report with unparameterised stored procedure (i didn't use any parameter).
but i noticed the the report keeps the data from last "Refresh report data".
i hve crystal report which is wrking perfectly fine.. now i want to add paramter to my stored proc... but i am not able to add the same parameter on crystal report..i tried to add parameter in the parameter fields the crystal reports field explorer.. but when i verfiy database it still gives msg stored proc expects parameter which was not supplied..SQL State 42000 native error..
View 2 RepliesI am trying to allow users to grab their stored procs and call certain ones from within code. I can get the stored procedures and then fill a dropdown with them, but what I cannot find at this point is how to get the parameters that each stored procedure needs. I would like, once an SP is chosen from the dropdown to make a call to the db with that sp name and grab its paramter list so I can report what needs to be sent in to the user.
View 1 RepliesI have created a asp.net web site using Visual Studio 2008 and Crytal Reports. I have two small reports that work perfectly on my development machine, and I have tripple checked that I have added reference to the CrystalDecisions.CrystalReports.Engine in my project. I do not have any CrystalReports dll's in my bin folder but when select my project and then click on the properties window the following refereces are there.
CrystalDecisions.CrystalReports.Engine, CrystalDecisions.EnterpriseFrameWork, CrystalDecisions.Enterprice.InfoStore, CrystalDecisions.ReportAppServer.ClientDoc, CrystalDecisions.ReportSource, CrystalDecisions.Shared, CrystalDecisions.Web
I have tried publishing, I have tried creating a Deployment Package etc and I continue to get the same error. Is there some deployment assembly that I am supposed to include with my install etc.
In web application developed in asp.net 1.1 using vb.net. My application crystal reports working fine in my local machiene. when i placed in web sever it throws the error " File or assembly name CrystalDecisions.CrystalReports.Engine, or one of its dependencies, was not found."
Line 38: <compilation defaultLanguage="vb" debug="true"><assemblies>
Line 39: <add assembly="CrystalDecisions.CrystalReports.Engine, Version=9.1.5000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
Line 40: <add assembly="CrystalDecisions.ReportSource, Version=9.1.5000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/> Line 41: <add assembly="CrystalDecisions.Shared, Version=9.1.5000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
The following information can be determine why the assembly 'CrystalDecisions.CrystalReports.Engine' could not be loaded.
I am using NET 3.0
how to add a reference to CrystalDecisions.CrystalReports.Engine(crystal report),I tried, but its not working.
I want report generted based on value from querystring.
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.
Currently, I have a page contains a report. But while I need to load the report for several times , the latest one I got the err about
'crystaldecisions.crystalreports.engine.logonexception load report failed'
What's the problem?
a 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 RepliesCrystal
Reports Error when publishing a Website on to the Web Server---- The type initializer for 'CrystalDecisions.Shared.CrystalReportClientScriptManager' threw an exception
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 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 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 have store procedure: ALTER PROCEDURE dbo.GetAllInfoFromUsers(@name varchar(50)) AS select id, userName,password, role from tbl_users where userName=@name
Then I have Report.aspx page:
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server"
AutoDataBind="True" Height="1106px"
Width="876px" />
[Code]....
I have dataset (MyDataset) build out of store procedure. and I have StoreCrystalReport.rpt linked to MyDataset.
I am unable to see the filtered output in crystal report.
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 Replies