Crystal Reports Error: A Number Is Required Here
Mar 15, 2012I have this code in my form (in load event) wherein there is a crystal report viewer: there is a "A number is required here" error in [Code]. how can I solve this error?
View 3 Replies
ADVERTISEMENT
Deploying Crystal Reports - Adding Crystal Reports To The Setup And Deployment
Jun 21, 2010I am working on VB.NET(Visual studio 2008)..I completed developing my application and i need to deploy the application. I tried it and faced problems in some areas like adding crystal reports to the setup and deployment. I created a setup file to my application and everything is fine except crystal reports...its showing the error like; An error occurred in crystalDecisions.Reports, crystalEngine threw exception.
View 2 RepliesSet Parameter For Number Of Records To Display In Crystal Reports XI
Jan 5, 2011I'm creating a report where I want to send a parameter for the number of records to display (I do not want to select the number of records in SQL) I have created a parameter field (?topN) and set the group to use this value which in design mode works well however when I try to set this parameter in vb.net code it does not work. The field which also displays the value shows the parameter correctly though.
View 2 RepliesSet Parameter For Number Of Records To Display In Crystal Reports XI?
May 22, 2010I'm creating a report where I want to send a parameter for the number of records to display (I do not want to select the number of records in SQL)
View 2 RepliesDB/Reporting :: Set Number Of Groups Per Page Programmatically In Crystal Reports?
Jul 8, 2009I'm designing a program using VS.NET 2008 and Crystal Reports 2008, and I want to give the user the option to set how many groups per page is viewed. I know I can do it using the Group Expert, but is it possible to set it programmatically in VS.NET?
View 1 RepliesCrystal Reports - Adjusting Space At Runtime Depending On Number Of Lines
Mar 24, 2008I am trying to design a report where one filed can be multiple lines and the other related field should be located below (See attached)
address may be 1 one or more lines, city state zip should be located just below.
I already have the field set to can grow, however the spacing is the issue. How do I make the spacing adjust at runtime depending on the number of lines in the field. I can space it to say 3 lines, but if the address filed is only 1 line it leaves a 3 line gap.
Crystal Reports - Error After Upgrade Vb
Jun 15, 2011i upgrade my project to vb.net by using visual basic. i get a error when run the crystal report.
[Code]...
my connection is Public Function ReportConnection(ByRef CrystalReport1 As Object, ByRef dsnname As String) As Boolean
[Code]...
2005 Crystal Reports : Name 'CrystalReportViewer1' Is Not Declared Error?
Oct 15, 2009I'm running through this tutorial found here: report_from_multiple_tables.htmwhich teaches how to pass a parameter text field on a vb form to an embedded Crystal Report in visual studio. I've followed it all the way through however when I attempt to build, I received the error:
Name 'CrystalReportViewer1' is not
declared.
[code].....
VB2005 Crystal Reports : Name 'CrystalReportViewer1' Is Not Declared Error?
Nov 20, 2010vb2005 crystal reports : Name 'CrystalReportViewer1' is not declared error
View 6 RepliesDifference Between Crystal Reports In Vb - Create Crystal Reports In Vb?
Apr 14, 2009tell me wat is the difference between crystal reports created in vb and in vb.net??how to create crystal reports in vb??
View 1 RepliesAsp.net - Crystal Reports Viewer: Failed To Open The Connection Error
Jun 19, 2012Currently I'm working on a piece of code that involves using the Crystal Reports Viewer to export .RPT files to PDF. My problem is that the code works on literally everything except the website I'm planning to eventually put it on.
When placed on the website it throws back the error "Failed to open the connection." which I believe is connected to the SQL Server connection that's formed in order to read data for the report itself.
The code itself is solid and works when used in a separate console application I built to test it whether said code is run on my local machine or on the server itself. It even runs when I test the website in Visual Studio's virtual host.
I've narrowed it down to being some sort of permissions issue, but I am not knowledgeable enough in the various permissions settings to figure out which ones specifically apply to this situation. It's worth mentioning that other pages on the website are directly connecting to the same database, but they are doing so directly through Linq instead of going through the Crystal Report Viewer.
So does anybody know which settings I need to modify in order to fix the connection error.An added note: One of the other suggestions is to make sure there's an ODBC DNS in place that matches the one being used by the code. I have created such a DNS already.
C# - Crystal Reports 2011 .Net 4.0 OS Installed On E: Gives Error When Running Report
May 4, 2012I have one PC whereby the OS has been installed on E: and it has no C: drive. Onto this I have installed my .Net 4.0 WPF Application which runs fine.
However, when I try to access a crystal report it gives the exception below. This user is able to access the report from its network location in windows explorer so I assume the act of asking Crystal to copy it locally is causing a problem?
Therefore, can anyone advise where the local copy will be created and/or how I can control this.
[Code]....
Error Connecting Password Protected Access Database To Crystal Reports
Apr 10, 2012How do I open my Crystal Report in VB code (RPT files) on password-protected Access 2007 database? Ever since I protected my database with password, my Crystal Report generates an error.
View 3 Replies.net - Crystal Reports Error: Cannot Find CrystalDecisions.Windows.Forms Version 10.2.3600
Nov 26, 2009I am refactoring an old program to use VS2008 (instead of VS2005) and the 2003 Crystal Reports merge modules no longer work on the client machine. I am using the CR version bundled with VS2008. Neither the CR10 merge modules downloaded from the SAP site work, nor the CR x86 msi.
Could not load file or assembly 'CrystalDecisions.Windows.Forms, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.
Creating Reports In Crystal Reports That Is Integrated Within Visual Studio 2008?
Aug 26, 2011I am creating reports in Crystal Reports that is integrated within Visual Studio 2008, and I noticed that some of the features are disabled. One is the ability to link tables with a Right Outer Join or Full Outer Join. I also cannot "Show SQL Query" in Crystal Reports. Is this something I can enable or do I have to purchase or upgrade?
View 1 RepliesCrystal Reports Connection Error "Invalid Authorization Specification"
Jan 12, 2010[Code]...
I am trying to generate crystal reports from visual studio..net 2008 and my database is created using SQL server management studio express 2005. I am getting login errors when using the OLE DB for SQL Server source. In studio express I use SQL server and windows authentication and I have tried leaving the user ID and password blank and putting in my login details but still getting the error. I have enabled multiple connections to the database.
Data - Getting The Error "This Field Name Is Not Known" While Opening Crystal Reports
Feb 3, 2011Working on a Migarition(VB6 to VB.Net(VS 2005)) application, where some of the reports are loaded in the application. The VB application is using the Crystal reports version 8. While migrating the application, we used the Crystal decisions and tried to load the report. Few of the reports are working fine, few are giving error(like boolean is required here, This field name is not known etc..). For few of the issues we have regenerated the report in CR XI it worked fine and few are giving the performance issue, but few reports are giving the same error as "This field name is not known".
To load the report we followed the steps.
1. Based on the user access level, the report connects to different DSNs.
2. Applies the LogonInfo to the report.
3. Sets the datatable as the datasource to the report
4. View the report.
If we run the application to load the report, it's throwing error as "This field Name is not known. Error in file C:Docs~UserLocal~TempSampleReport{EE6CC25A-D216-496C-AA95-E2F0C61718C6}.rpt:Error in Formula '{ViewReport.field} ="AB'"This field Name is not known".For this I have tried changing the setdatabaselocation in database expert.Still getting the error.The reports giving the error are using a View in it's Query. Is it causing the issue?
Intermittent Crystal Reports Error "The Request Could Not Be Submitted For Background Processing."?
Feb 2, 2010We are running Crystal Reports on a Windows Server 2008 with .NET framework 3.5 SP1. I have seen many causes of the general error "The request could not be submitted for background processing." on other forums, however they tend to be persistent and repeatable affecting just a single report due to a specific formatting issue with a specific report.We are seeing this error with the below stack trace, intermittently. It affects multiple different reports we have. It affects one particular report more frequently than other reports. Once a report is affected the same error will often appear in multiple reports at approximately the same time eg. for the next 10 minutes.The same report run with the same parameters may work when run again (soon after) or the application may need restarting before the report can be successfully re run. These reports all worked previously without issue. No change in server or code seems apparent which would have precipitated this error. All code behind for this is VB.NET We have had difficulty reproducing it in test environments and upgrading to the latest version of Crystal has not helped at all.
[code]...
Generating Reports Without Crystal Reports?
Dec 1, 2011How can we create a report in vb.net without using any crystal reports
View 11 RepliesCrystal Reports With .net?
Sep 26, 2011I am preparing crystal reports using vb.net 2008 with ms sql server 2005.everything is showing fine.. except that i want my report to be multiple column... I cant do this using "format multiple column" option because the data is not shown in details section. Actually i need to group the data in data.
e.g: i am preparing a warehouse report to know how much quantity of which products are left, products with 0 (zero) value are not displayed..
I want my reports to be as follows: item1 item_quantity item2 item_quantity item3 item_quantity
VB2010 Crystal Report Login Details Required?
Oct 17, 2011I am trying to grasp how to include a Crystal report in a program written in Visual Studio 2010.I have created a form in the program and included a Crystal Report Viewer on it. When I create a new Crystal report using the report wizard all seems well. However, when I debug/run the program I am asked to provide the database login ID and password. The database I am using was created with SQL Server 2008 R2, and was never created with login credentials.
I believe the problem is in the Crystal Report Viewer opening the report but have no clue about what steps to take to correct this. When I run the program with the Report Viewer minus a Report, the Report viewer runs successfully. But when I include a report it asks for the login ID and password.
Adding A Reports Application Or A Crystal Reports Application?
Dec 22, 2010I'm using VS 2008 to develop a solution which will report on data mostly contained in SQL Express databases, across two servers. It will be used by up to about 10 XP clients. I am unfamiliar with the Reports Applications. Will I need to buy extra licenses to use a Crystal Reports application? Why are they both included in VS? What is the basic difference between them?
View 3 Replies.net - Connecting To Crystal Reports 4.6 From VB?
Jul 26, 2009How can I connect to a Crystal Reports 4.6 report that connects to SQL Server 2005 as a data source, using Visual Basic?I don't want to specify the connection string in the report. I want to pass the connection from VB. Is there any way to do this?
View 1 Replies.net - Images In Crystal Reports?
Jan 28, 2011I am working on Windows Forms Projects.I am creating a report for customers.The report data is pulled from a "CustomerDetails" table.A field in the table is called "CustPhotoName", this holds a string which relates to an image file.
I Currently have a report set up which runs for a single customer by passing in a customer ID. Then using the passed in ID to populate a Dataset with an ImageRow and then a sub report with the image from the dataset.
I am wanting to set up this report where I can pass in an array of customer IDs and produce the reports (1 page per customer with image (if CustPhotoName has value))
.net - Unable To Use Crystal Reports In Asp.net?
May 14, 2009I have created reports using Crystal Reports in my asp.net application(vb). It was fine. But when I run it in another system, the report loading fails. So I modified my code like this.
sub Loadreport()
try
Dim sreport as new ReportDocument
sreport.Load(Server.MapPath("ClientList.rpt"))
[code]....
When the control comes to the line:-
sreport.Load(Server.MapPath("ClientList.rpt"))
it jumps to the catch block showing "Invalid Report path". But initially, the code was not showing any error. I haven't changed the path.
.net 2008 And Crystal Reports 10?
Mar 29, 2011I made a program in VB .net 2008 that has a form in which there is a Crystal Report Viewer object. Here is some code:
[Code]...
1. Some reports show tens and hundreds of thousands or records (they are required to do so, so no work-around is possible), thus the time it takes for the Crystal Report Viewer control to actually show the report is very long. I would like to display like a waiting dialog window WHILE the report is loading its records telling the user to wait for it to load.
2. Another idea would be to show the number of records currently loaded (and continuously updated as the report loads them) from the total number. This is actually shown in my reports when i open them with Crystal Reports 10, but NOT with the Viewer control on the form! How can i make it show this?
C# - Populate Crystal Reports With SQL?
Jun 30, 2010Since there doesn't seem to be any way to load old VB6 (ActiveReports) reports in .Net, I need to recreate dozens of reports in .Net. I'd like to do this in the least painful way possible.In VB6, the original authors simply did something like this for every report:
adoConn.ConnectionString = globalConnectionObject.ConnectionString
adoConn.Source = ReportFunctions.GetAllUsers()
GetAllUsers() returns an SQL string which selects a bunch of fields; those fields are then used in the report.Now:How can I do something similar in .Net (either using the built-in Crystal Reports, or the built-in "Microsoft Reporting Technology")?I can't get "Database Expert" to recognize globalConnectionObject (an ADODB.Connection object); and if I fill a dataset and do
report.SetDataSource(dataSet)
It tells me "The report has no tables."How do I populate a Crystal Reports report!? (the connection string/data location is not known at compile time)
Compile Crystal Reports Into An Exe
Jun 5, 2011I've recently made the switch from the Data Report to Crystal Reports 10. I've rewritten the reports our software uses and they are working fine in a nominal reports location.I have heard that Crystal Reports can be compiled into a single executable file which can be called through vb.net, rather than loading the report from a location.
View 1 RepliesCrystal Reports In 2010 Won't Appear
Oct 1, 2010I already installed crystal reports in my vb 2010. (i got it from the sap website) but crystal reports won't appear in the toolbar. i could add a new report, but i can't put it in my design form cause just like what i said, there's no crystal reports in the toolbox. i already checked crystal reports in the customize button of toolbar, but still it won't appear.
View 2 RepliesCrystal Reports In A PDF File?
Aug 5, 2009I am using the following code to output a Crystal Report to an ASP.NET application:
Dim rptDocument As New ReportDocument
Dim rptPath As String = Server.MapPath("Reports/Employees.rpt")
rptDocument.Load(rptPath)
[code].....