Search results for query: *

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...

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...

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...

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...

Hey All, I am having problems converting a string into a date, so that even users running the runtime package of Crystal (I have 8.5) don't get errors. The String sits as: "03/11/04 3/15/04" (w/o quotes) First, I had this: if length ({TRANS.COMMENTS}) >=8 then...

I have a report in Crystal 8.5 that works great, but has 4 or 5 subreports. When the end users run it, they are complaining that they must enter their login information too many times (once for each subreport). Is there any way to only make them log in once, since its the same database for all...