Search results for query: *

Thanks Dave, this is great. I will look at how I can get this formatting including in the backend of the application prior to the view execution.

Hi all, I am working with a VIEW in SQL plus (9i or 11g) and for some reason when it is returning results (dollar amount column), it is leaving off the decimal places, essentially just rounding down. I know I can do a to_char on this (select to_char(amt,'999,999,999.99') from transactions) but...

I use Crystal Reports 2008 to connect to my Oracle database via a JDBC connection. Many times, when I am making a new parameter, or editing an existing one, the parameter "edit" screen locks up and Crystal changes to NOT RESPONDING, which it sits on forever. At the point where I am editing...

Hi All, I have been using Crystal 2008 (or Crystal 11) and connecting to Oracle using JDBC. It takes over a minute, sometimes longer for Crystal to connect to the database. I am moving a customer from Crystal 8.5 (which used the fast Oracle driver) to Crystal 2008 (which we now use the JDBC...

I am a newby to Quark and I want to take advantage of the "Mail merge on steroids" ability of the XData XTension. I have a 50 row tab delimited .txt file that I am trying to read information from to make a brochure with information about classes (price, location, instructor, etc). I downloaded...

I am very green to InDesign and need to make a project in a hurry. I am using a CSV data source to merge data in about programs/classes for a brochure (instructor, class name, prices, etc). I need to have multiple programs on each page, which I have successfully used the "Records per document...

I have recently installed Crystal XI Developer on a server at a client's site, and it overwrote some of the DLLs in C:\windows\system32... most notably LIBEAY32.DLL... but Crystal was working. There is another program (PC Charge) that I had previously installed and working (until I installed...

I really was trying to avoid installing the oracle client on this machine, as I will need to have Crystal on many machines. Is this possible? I thought I have seen it. Thanks for the response, any other ideas? Ben

Hey all, I am trying to connect to an oracle 9i database using an ODBC driver called DataDirect (using Crystal Developer 10). When I open the .rpt version of the report, I get the message "the database dll 'crdb_oracle.dll' could not be loaded". The report will work if I go into 'Set...

Turk, I was able to get into SQL successfully, so oracle is installed right. And I went into the add/remove programs to see what was set up for crystal, and the oracle entry was not under the 'Data access' section. I could not figure out how to add it, and I spoke to one of my co-workers. He...

Turk, The oracle client was installed before the Crystal developer's edition was put on there (I think). How can I check if the oracle client was installed when Crystal was installed, and does it matter? I am not sure what you mean about "Are you using CR Professional or higher ( Not...

Do I need to have an ODBC connection to the database set up here if I have oracle client installedon the machine? I do not have any oracle entries here for my other PCs. -Ben

Hey All, I get the below messages when running a Crystal 8.5 .rpt report, and trying to connect to an ORACLE database. When running the report, or clicking "Verify database", the messages come in this order: 1) The library "pdsora7.dll" cannot be found. Please check your installation. 2) Cannot...

Hey All, Crystal Reports v10 is giving an error when trying to connect to my oracle 9 database using JDBC. The error is "Logon Failed Details:JDBC Driver not found" I know that this type of connection can be done (according to CR), but I haven't been able to find out how to do it, or anyone...

I have found some info on connecting using JDBC, so I am trying that route. I am having problems connecting still, Crystal tells me "JDBC Driver not found."..... I'm sure this has to do with the JDBC driver path that I have given it. I just used the default as: JDBCDriverName =...

Hey All, I am wondering if there is a way to run a Crystal V10 report using an Oracle 9 DB without having the Oracle client software installed on the PC (PC has Win 2000). Is there some kind of ODBC driver I can use to connect to it? Can I use OLE? I have been reading thru the documentation on...

I have a membership info (mem_info) table and a contributions table (both hold member numbers). I simply want to show some of the fields from mem_info, where there is not a linked record in contributions table. Currently, I am linking the two tables by member_number, and family ID. The...

I am not sure where I will go from here, thanks for your help BEN

That CDate() function didn't work either. Actually I found out more information about what the problem is. When the report runs, it is supposed to ask for a parameter that goes to the first report(which happens OK), and then when it is supposed to ask for anohter date (which needs to be...

The data sits as 01/15/04, for example. So the numbers are always in the same place in the string. It is always MM/DD/YY. But I am having problems with the above given formulas. They work when users have the full version of Crystal installed on their machine, but not if they have just the...