[2008] Connecting Crystal Reports To SQL Using OLE (Login Failure ... Still)
Mar 14, 2009
I have been trying to connect a Crystal Report app. to a database. I have had a hard time with this. It is working on my dev box, but it will not work on any other boxes. I have read some posts about adding logon info and connection info. I have followed these posts, but I am still unable to connect. Here is what I have thus far:
How 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?
How 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.
I made a small VB.NET application which includes a Crystal Report. Running the Crystal Report on the machine I made it works perfectly. When I run the application on my laptop, the Crystal Report always prompts me for a login even though the database has no login set to it. I have tried passing in "Admin" and "" with code, but no luck. I'm working with an Access database, this is the code I have to load my Crystal Report:
If frmReport Is Nothing OrElse frmReport.IsDisposed Then frmReport = New frmReport End If frmReport.CrystalReportViewer1.ReportSource = "../../Reports/Klantenbeheer.rpt" frmReport.MdiParent = Me frmReport.Show()
I did look at Prevent login of ODBC Text driver in Crystal Report for Visual Studio 2010 but I'm not sure if it applies to my situation? I also tried setting the rpt's datasource to the datasource I work with in the application and then assigning that to the ReportSource, but no luck either.
I have deployed a Visual Studio executible module written in VB Net 3.5 SP 1 with Crystal Reports. When the user tries to view a report(s)they are prompted to login in to the data base that has been data sourced into the report module. The correct database was verified before the build was made. The developer is able to run the report in a run mode on the local machine where the VB project was created. In the properties section in the project the following check boxes pertaining to reports were checked on:
Crystal Reports Basic for Visual Studio 2008(x86, x64) Microsoft Visual Studio 2008 Report Viewer
Notes: If the executible module is deployed to a machine that has Visual Studio 2008 installed, the Reports run fine without a database login prompt.If the executible module is deployed to a machine that does not have Visual Studio 2008 installed, the user is prompted for a login. The data base is a SQL server 2008 database.
I am creating a visual basic project for class. It is all running as intended though I am not sure how to set up the login to database function. When you click the link for the specific report it should display the page. But I get a login to database page. I am just wondering how I set that up so that one can actually see the information. ie:
I 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?
I 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.
I 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?
I can create a program or web page that can display crystal reports. I have searched and searched with google but am still none the wiser. I foolishly assumed that there would just be some .NET SDK on the Crystal Reports website, and there isnt... there is a lot of talk about it, but no download link or anything.They are using Crystal 8.5 - does anyone have a clue how I can even get started with this? Will there be an SDK on the Crystal CD or something?
I need help in making my Crystal Reports in ASP.NET. I'm using VB.NET. This is my source code
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim myConnection As New OleDbConnection("Provider = Microsoft.Jet.OleDB.4.0; Data Source = " & Server.MapPath("Sartorius.mdb)")) Dim MyCommand As New OleDbCommand
[code]...
I'm having errors in making the orpt object. It says that CrystalReport1 is not defined though I already created a CrystalReport1.rpt file on my solution.
A couple of things firstly When I create a new Crystal Reports file (using the built in Crystal Reports in Visual Studio) I create a blank document. I then insert a Text label type text and goto properties and Visual Studio Exits with no rhyme or reason. No error. Anyone experienced this or get any ideas?
Secondly I have a form with a load of text boxes in a column/row arrangement and text labels as column headers. I then want to be able print these in nice view (I have a certain way I have to display the print out.
I have never used Crystal Reports but I thought this would be the way to go about it. Is this right or is there another easy way? If it is can anyone point me to any example (preferablly begginer and basic) that I can read and learn from?
I have a VB.NEt app developed on XP using Visual studio 2008. My crystal reports work fine on XP but if I install the app and try to run the reports on Vista I recieve the following error message - can somebody offer a fix.
I'm buiding an app that loads a crystal report document but it's loading the document from my local drive. I need to embed the crystal report i think because I don't want it reading from the local drive because I'm looking to deploy this to other users when it's done. Are there any other options?
Is there a way to make VS2008 work with the old (vs2005 crystal reports) assemblies and not require any updates to be installed in the client machines? We have upgraded a Visual Studio 2005 .net 2.0 solution to Visual Studio 2008. The purpose is to take advantage of the IDE improvements and because it supports multi targeting. The solution still has to be built against .net 2.0. It all works as advertised, we rebuild and run it in a machine with only .net 2.0 installed.
But during testing we get an exception when we try to show a Crystal Report that is included with the application. Then upon review we find out that without telling us, Visual Studio changed the references to the crystal assemblies and pointed our solution to the updated versions that come with vs2008, which requires crystal runtime be updated on client machines. We did try removing the references and adding the old ones but it won't compile.
I'm using my data objects in a crystal report. The thing is, when I select my object, it gets added to the field explorer table. My properties are listed except for the Nullable Type properties. Why would this happen. I've had quite a few issues yesterday as this is my first attempt at a crystal report in .Net. I thought I worked around them but now I've hit this snag.
We always get this error whenever we try to run the form that has the Crystal Reports viewer on the unit to which we deployed our application. Attached is the screenshot of the generated error and the complete error description.
does anyone knows how to develop dlls for crystal reports 2008?My OS is Windows7 x64 but i would like to develop dlls for x64 and x86, i won't mind to compile them separately.
this event works ok, but the problem is that I don't know what field was clicked. Should I use objectinfo or something else? VB.net won't recognize for example e.objectinfo.
I have upgraded an existing project to be developed on Visual Studio 2008 but I still need to target the .NET framework 2.0My project had the prerequisite Crystal Reports for .NET Framework 2.0 but Visual Studio 2008 reports that that "could not be found for bootstrapping"Now my users get the error:Could not load file or assembly 'CrystalDecisions.CrystalReports.Engine, Version=10.5.3700.0, ...' or one of its dependencies. The system cannot find the file specified.
I recently upgraded to Crystal Reports 2008 for the barcoding functionality. When we use the barcode in the report designer, it renders as expected, so we installed the Crystal Reports 2008 redistributable package on our dev server to test deployment, but we receive the error message listed below. I cannot locate any information about this issue on the business objects site, or azaleas site, or any info regarding deployment of barcoding functionality.
how to create a setup in vb.net that comes with a ms access database and the .net framework if it is not existing in the system.. and also a crystal report... and also i want my database go automatically to C:
I have created a data source connection to an access db by using the wizard in vs2008. I have then used this as a data source for crystal reports. My user would like to put the database on a network and reference it there. Is there a way to set a new path for this data source during runtime?
I created a service which monitors a few servers and file shares for exchange. Written in VB.NET 2.The service is installed and running fine(ish) but randomly and without any warning or entries in the event log it stops.Upon noticing it stops (the web front end that it generates stops working) we have to manage ther hosting server to attempt to start it again.If we simply try to restart it, it fails to start with a logon failure.