Search results for query: *

Thanks lbass. You were exactly right. There were not many transactions that met the criteria for showing on the report and none of the "real" dates stuck out as being an issue.

I am using Crystal Reports 10. Oracle database. I have a date field that is my primary group field. One of the dates is 1/1/1700. This was a default value of some sort in this database as there are a number of occurrences of this date. If I put this field on the report it displays fine as...

Another option is to put your line below everything else in the section, then if you right click the line and select Format Line there is an option you can check that says Move To Bottom of Section When Printing. If you do this it should always print at the very bottom of your section.

I believe I responded to Crystalboy1's question in another post he had, but you can use this method to change the datasource location of a command object in Crystal Reports 10. If you select the command object and go to set datasource location. Then click the + next to Properties of the...

If you select the command object and go to set datasource location. Then click the + next to Properties of the datasource. It should have an entry that says Service and then the name of your datasource. If you select this, right click and then select Edit you can change the name of the...

I believe you can specify the number of decimal places you want to use in a numbeer field. So your code should say "Q" & TOTEXT(DatePart("Q",{Registration_List.DateOfClass}), 0) & "-" & TOTEXT({@Date - YY as #}, 0)

I stand corrected. Thanks RustyAfro. It turns out that I had omitted those portions of the query from the version that was "working" so I was seeing data. It turns out the problem was actually a bad data issue. They have corrected the data and the original report is now returning the desired...

It seems like if that were the case then at the bottom of my preview window it would show 0 of 1 records processed. It just shows 0 records like it never retrieved any records from the query that was processed against the database.

Record Selection ( (isnull({GES_ROL_WEB_RPT_SET.CNTRCT_ID}) AND isnull({GES_ROL_WEB_RPT_SET.ADMIN_UNIT_ID}) ) OR (not isnull({GES_ROL_WEB_RPT_SET.CNTRCT_ID}) AND isnull({GES_ROL_WEB_RPT_SET.ADMIN_UNIT_ID}) AND {@vw_cntrct_id} = totext({GES_ROL_WEB_RPT_SET.CNTRCT_ID})...

We are using Crystal Reports 10 with an Oracle 10 database. Some of the reports have used the Visual Linking expert to join two tables together. One of these tables is actually a materialized view. For the most part this seems to be working. However we recently ran into a situation where the...

rdharmar, No I have not found a solution yet (other than changing to use a native Oracle connection). The Oracle DBA today suggested that I contact DataDirect to see if their driver supports Oracle 10. I have not had an opportunity to do that yet.

I have both drivers installed and ran into the same error with both. Originally I had installed the ODBC driver for Oracle, for XML and for text as those are three that we have found use for at various times. After the errors and no resolution from Business Objects I went back and installed...

I tried the Wire Protocol Driver but got the same error that started this whole thread in the first place. So unless Business Objects or some of you good folks here on Tek-Tips can help resolve that problem, I think the native Oracle connection is the only viable solution at this point.

It is strange how these things work. Up until the point where we converted our database to Oracle 10G from 9I we had almost always used the Oracle ODBC driver. Since that "upgrade" we have had a number of reports where execution time went from seconds to minutes and the users are none too...

They don't actually go away. It is just that they are a separate stand alone installation in XI. However, as I found out there are definitely issues with actually getting an ODBC data source set up using it.

The best thing to do would be to do a Database show SQL query to get the code that is being executed and then log into a tool (using the same logon you are running the report with) where you can run the code besides Crystal (we use SQL Navigator to run Oracle code, I don't know what you might be...

Thanks synapsevampire. I was able to get the modified database connection code from Business Objects tech support for a native connection. Now there is no need to deploy these Crystal ODBC drivers. The reports run great using the native connection.

We are using that driver for two different reasons. WE are currently using Crystal 10 and our database was just converted to Oracle 10. I was doing research to determine what issues we might encounter when we migrate to XI when I discovered this problem. We had been using Oracle's ODBC driver...

Unable to connect incorrect logon parameters generally indicates problems logging onto the database (bad logon or password). Does this report have multiple data sources perhaps and the information is there for only one of them?

I have Crystal Reports XI Release 2 installed on a PC. The operating system is Windows XP. I am trying to setup an ODBC datasource using the DataDirect 5.1 Drivers (CR Oracle ODBC Driver 5.1) to make a connection to an Oracle data base. I have downloaded and installed the ODBC driver but when...