Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cpagnani

    Report SCR8 ODBC Oracle8 show zero in decimal places

    File -> Database -> Convert database driver... from: pdsodbc.dll [ODBC] to: pdsora7.dll [ORACLE 7.x] Versione italiana File -> Database -> Converti driver database... da: pdsodbc.dll [ODBC] a: pdsora7.dll [ORACLE 7.x] Ciao e buon lavoro Claudio
  2. cpagnani

    Report SCR8 ODBC Oracle8 show zero in decimal places

    I worked around the problem by turning all my reports to native Oracle driver. Sorry I can't help you. Ciao Claudio
  3. cpagnani

    error in translation of selection formula into where clause

    I made a little mistake in both case there's NO 0 after decimal point or comma, but decimal point followed by nothing is good SQL for Oracle. Ken you're right, I change regional settings to U.S. and all is good. I think it's a bug in CR: regional settings can't affect SQL syntax. Unfortunately...
  4. cpagnani

    error in translation of selection formula into where clause

    Hi folks, I run a report (v8) against Oracle8 db, by a VB6 form, using Crystal OCX, setting inside selection formula {view.number_field} = 2001 When running in VB6 IDE it translates to view.number_field = 2001, (with final comma) giving Oracle error SQL command not properly ended. When...
  5. cpagnani

    Activex viewer prints blank page after each report page

    Hello folks! When I print my report with Print button in ActiveX viewer I get an extra blank page after every report page. I run my report by a ASP page, so no WEB or Page services running. I design report on same PC which acts as web server, so default printer used to design is exactly the same...
  6. cpagnani

    Printing blank pages in landscape

    Hello folks! I experienced same problem. When I print my report with Print button in ActiveX viewer I get an extra blank page after every report page. I run my report by a ASP page, so no WEB or Page services running. I design report on same PC which acts as web server, so default printer used...
  7. cpagnani

    Report SCR8 ODBC Oracle8 show zero in decimal places

    MS Access don't get the decimals so the problem is in the ODBC layer. It is always truncating. I chose the example to show that. Thanks for suggestions Ciao Claudio Pagnani
  8. cpagnani

    Report SCR8 ODBC Oracle8 show zero in decimal places

    Format seems correct: decimals 1.00, rounding 0.01. Same report on another PC with same version of Oracle Client works properly. Thanks Ciao Claudio Pagnani
  9. cpagnani

    Report SCR8 ODBC Oracle8 show zero in decimal places

    I'm writing a report with SCR 8 accessing Oracle 8 database through Oracle ODBC driver and Oracle client 8.0.5. The report reads a database field number(6,2). Field value is 1234.56 but the report shows 1234.00. Same report with native driver or MERANT ODBC Oracle driver works correctly. What's...

Part and Inventory Search

Back
Top