I use SQL server 2005 express on VS 2008 TS, I can make connection to DB from the server explorer but i cannot make connections from teh Crystal reports OLE DB connection wizard, the drop down box doesnt show my SQL server. How do i fix this?
View 2 RepliesI'm trying to use crystal reports in my database that i have made using vb 2010 and access 07, I'm trying to make a new crystal report in vb, have gone add new item, crystal report, etc but when i go to specify the new connection using the Microsoft office 12.0 access database engine )LE DB provider i keep getting a catastrophic failure error 0x8000fff?
View 2 Repliesi have a "Connection.vb" where all my Connection string stored and used by the entire program.i'm new to Crystal Reports.. and i want to changes its connection string based on the connection string i made... im using MS SQL 2008.. SQL Server Native Client 10.0 OLE DB Provider..
and here is my connection string."Provider=SQLNCLI10;Server=....SQLEXPRESS;Database=Blah;Trusted_Connection=yes"
i tried to google it.. but they are using different language, different database, and complex examples.
I have some Crystal Reports connecting to a Sql Server db that I would like to detect whether the connection is trusted or whether I need to supply the log on info (reports are not supplied by me so I can't control the connect method). If I just blindly supply login credentials, it won't connect if it is a trusted connection.The following does not work:
oRpt = oCR.OpenReport("C:MyReport.rpt")
if oRpt.Database.Tables(1).ConnectionProperties.Item("Integrated Security") = True then
'trusted connection[code]....
It gives the following error:Operator '=' is not defined for type 'IConnectionProperty' and type 'Boolean'.
I cannot find how create a construct in vb.net for IConnectionProperty. I can't find any documents from Crystal that explain it.I am using Crystal Reports XI - Developer
Currently 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.
I�m converting some Crystal reporting functions from VB 6.0 to VB .Net 2008, have reports up and running, and I�m not quite sure how to approach one aspect. The issue I have is most of the Crystal reports connect to a database and run a stored procedure. The connection properties are set up in the report usually pointing at the development region. At run time I need to be pointing to either development, user acceptance, or production. I know what environment I�m in from a configuration file but don�t know how to go about telling Crystal what environment and stored procedure to point at. In VB 6.0 it was:
CR1.Connect = "DSN=" & A.ReportServer & ";<<Use Integrated Security>>;DSQ=" & A.ReportManhattanDB
Where A.ReportServer and A.ReportManhattanDB contain the connection poperties. The stored procedure is passed via:
[Code]....
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.
View 2 RepliesI 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?
View 4 Replieshow to make crystal reports in 3.5
View 2 Repliesi make a connection with SQL server 2005 database using Wizard in Express Edition 2008,I have got data in my text field using dataset , but now I want to execute query for insert, select and update but I don't know my connection vaiable and how to execute query and get data .what kind of connection is this Adodb or oledb etc
View 5 RepliesI am a bit new to crystal reports even though I've been doing a bit of heavy lifting with it.I have this crystal report that has a datetime field.This field has a default datetime of 1753-01-01 00:00. Now I want this field to display only date like "01-03-2011" and also anywhere it sees the default date, it should display an empty string like To achieve this I used this formular (in the display string)
if CurrentFieldValue = DateValue('1753-01-01 00:00:00') then
''
else
totext(CurrentFieldValue)
This successfully changes the default date to empty string. But now I can no longer change the format to dates only.
When i make Setup of my project then my crystal reports keeps old database path how can i resolve it please help me.
View 2 Repliestell me wat is the difference between crystal reports created in vb and in vb.net??how to create crystal reports in vb??
View 1 Replies[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.
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?
View 1 RepliesHow can we create a report in vb.net without using any crystal reports
View 11 RepliesIam workin wid crystal reports have a problem i jus want to create a crystal report dynamically not by using crystal report wizard rather by using a blank crystal report and connecting to the database server and generating the report from the database manually....
View 1 Repliesi am using crystal report wizard and i want to put a search box in my crystal rpt but i don't know what i'm going to do
View 1 RepliesHow to create a crystal report in vb.net 2005 using data source wizard.
View 1 RepliesI have the RTM version installed. I am quite puzzled at this wizard. It works fine with SqlClient. But for Access databases, this wizard completely fails.In this wizard, I only have one option to do - setting the ConnectionString. [code]
View 1 RepliesI added an .xsd file to my project using the IDE After that, I right-clicked and chose Add->Query I chose a dummy connection and then >SQL statement->Update Then I changed the Query's modifier to public
Dim ta As New dsCC2000TableAdapters.UpdatesTableAdapter
ta.UpdateQueryTest()
The problem is... I can't seem to modify the connnection object at runtime (by using ta.connection = XYZ) It doesn't show up on ta variable's intellisense!
I added an .xsd file to my project using the IDE After that, I right-clicked and chose Add->Query I chose a dummy connection and then >SQL statement->Update Then I changed the Query's modifier to public
Dim ta As New dsCC2000TableAdapters.UpdatesTableAdapter ta.UpdateQueryTest() The problem is... I can't seem to modify the connnection object at runtime (by using ta.connection = XYZ)It doesn't show up on ta variable's intellisense!
I 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
I basically want to make this in my application, so our technicians have an easier time installing our software. So far, I made a form with 4 text boxes: Server name, user name, password, and a combo-box to select a database.Everything was pretty easy until the database selection code. Microsoft's wizard is very efficient, there's no wait time when the database combo box is being filled.[code]That code gets the databases just fine, but obviously if an exception happens the whole screen locks up and it might take a while to recover depending on what the database error is. My question is, can I make mine just as cool/efficient as Microsoft's?
View 1 RepliesI'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 RepliesHow 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 RepliesI 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))
I 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.
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?
Since 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)