Search results for query: *

Hi all, I am using Crystal 10 integrating with vb.net 2003. What happened to the "NO_DATA" event or better yet, what is the best way to determine whether a report has returned no data or not in the .net environment using the Crystal 10 API? Thanks, I have scoured the web today and can find...

This seems like an obvious question but one I cannot find an answer to: Is there a way to connect a Crystal Report to a SQL SERVER database natively, i.e. without requiring an ODBC datasource? Code snippet: With crConnectionInfo .ServerName = "ServerName"...

I am using the hierarchical grouping feature in Crystal version 9.0. Problem is, I need data that is at the "same level" to be sorted by something other than the unique ID. Example using an "manager/employee" scenario: John Smith (Manager of . . . ) Alice Jones Sally Black Bobby...

I have a sql server database successfully installed (using msde) on a server running windows xp professional. I can connect to the database locally as well as remotely from any windows xp machine. However, when I attempt to connect on any machine running window 2000, I receieve an error stating...

I am attempting to execute a requery method of an ado recordset created using the Dataenvironment. Recordset queries an Access database. When I attempt to do so, I get the following error: 3219: Operation is not allowed in this context Anyone know why?

Just wondering what others are doing in deciding whether to use dataenvironment vs. adodc and why. I am trying to figure out the best strategy in developing a vb database.

Hi All, I am running into the following problem. I have an ADO recordset which represents a rather typical query of two tables, one a look up (One-side) of the other as follows: Select Table_Many.ForeignKey, Table_One.KeyDescription FROM Table_Many, Table_One WHERE Table_Many.ForeignKey =...

Here's a helpful hint that cost me over an hour to figure out. If you are using VB and Crystal's RDC and are wishing to return the value of a parameter field whose value has already been assigned, either in code or by the user, DO NOT use the VALUE property of the parameter field. It will...

I am encountering an error using the SelectPrinter method using Crystal RDC version 9.0 Here is a snippet of my code: Private Sub btnPrint_Click() Dim p As Printer For Each p In Printers If p.DeviceName = Me.ddPrinters Then...

Is there any Crystal feature that will allow an object (e.g. text field) to be suppressed when the report is printed or exported, but appear when it is viewed on screen?

I am using Crystal 9 and am creating a LINE chart; the ON CHANGE OF is month, and the SHOW VALUES are two fields, one storing a value to be counted, and the other storing a value to be summed. The line chart simple plots a line for each value by month. Question: is there a way to change the...

I just created a pie chart in version 9 and decided I did not like the data labels --- those call-outs from each slice of the pie that identify the slice. I removed them through Chart Options>General>Data Labels tab by clearing the SHOW LABELS check box. However, when I close the Preview Window...

I wish to write a VB application that supports its own file types, i.e. when a file is double-clicked in Windows, the application will start and display the file. I have successfully configured the file association in Windows, no problem. But question for the geniuses out there: once the file...

Just learning how to use the Data Environment designer and I am going by the book. After creating a connection to an Access database and a command to retrieve data from a single table, the following code is failing in the Form_Load Event: Private Sub Form_Load() Dim rs As ADODB.Recordset...

I created a database using the database configuration wizard provided with Oracle 9i installer (Personal Oracle). I then created a user, because I wanted to log in with that user using, say Access or Crystal. Problem was, WAY too many tables were being displayed. I only wanted a single table to...

I am attempting to connect to a Personal Oracle 9i database from Access 2002 using ODBC. The data source is configured correctly and tests successfully. However, when I try to link an Oracle database table, I receive the following Oracle Error message via ODBC: ORA - 12545 Connect Failed...

Hi Folks, I have read various thread regarding the NotInList Event, but none answer this simple question. Consider the code: Private Sub ClientCompanyName_NotInList(NewData As String, Response As Integer) Response = acDataErrAdded End Sub Should this code prevent the standard Microsoft...

I am running the following code: Public Sub Test() Dim gobjDb As ADODB.Connection Dim rst As Recordset Set gobjDb = New ADODB.Connection gobjDb.Mode = adModeReadWrite gobjDb.Open CurrentProject.Connection, "admin", "pass" MsgBox...

How do I programmatically access the RecordSource property of an Access form that is closed? I am familiar with the AllForms collection, as follows: Dim obj As Object Dim dbs As Object Set dbs = CurrentProject Set obj = dbs.AllForms(0) But when I proceed to do the...