Search results for query: *

Hello! I'm using BOE XI and viewing my reports in ActiveX using viewrpt.aspx. All date fields in the reports appear as if the regional settings were set to US format which they are not. When viewing the reports in either Crystal Reports, InfoView or even using viewrpt.aspx combined with the...

I have a table of hierarchical data such as employee with column manager_id which references the same table employee. Data in the table is something like: employee_id employee_name manager_id 1 King 2 Greenberg 1 3 Faviet...

Hi! I installed CR 9 a few days ago along with RAS. It works fine but I can't find a way to hide the prompt for the username and password of the database. In version 8 I worked with Web Compononent Server and there were several ways I could do it. Any help will be appreciated. Tomaz

Hi! I'm using CrystalReports 8 and Oracle 8i. I'm trying to display a blob field in the designer but am getting "Not supported" error. The field is a jpeg image. Does anyone have the same problem? Tomas

I figured this out a long time ago, so I don't even remember what caused this error. Please check this: 1. Is your first parameter in the procedure 'in out'? 2. If you use odbc, did you check 'Procedure returns results'? 3. Does the odbc connection use cror815.dll? Regards, Tomaz

CrystalReports ver. 8.0 ActiveX viewer ver. 2.11.15.0 Users view our reports in their browser via WCS. When exporting to .rtf (from the viewer in the browser) the PageServer just stopped working and had to be restarted. When I tried exporting to .rtf from CrystalReports (on the web server)...

We just downloaded the new npviewer.exe (version 2.11.15.0) on all client machines. Then the printing of blank pages stopped. Hope this will help anybody with the same problem. Tomaz

My details section is 'formatted with multiple columns' and I don't know how to insert a blank column after specific fields. If the data is: A B C D I would like this (a blank column between C and D): A B C D If the data was placed in rows this would be very simple. I would just add a...

I have discovered the real problem! At first we were having the problem that our reports (A4) printed in letter format. If 'No printer' is selected or 'Default properties' is selected they would print as letter format (without blank pages). If 'Default properties' is not selected then it prints...

I have several reports that print a blank page after every page when printing from ActiveX. They have all Portrait orientation. Some reports are created on my computer, some are created on the computer that the web server is running on. If I print any of them from my computer they have no...

Sorry, maybe I really should have asked this somewhere else. But now I have the solution and I would like to write it here. It is very simple - you don't need the loop: CREATE OR REPLACE PROCEDURE cr_test( k_test in out crystal.tip_kurzor, table_name in VARCHAR2) IS query_str...

Does anybody use dynamic sql in their Oracle stored procedures. I'm just testing it and I'm getting the following error: ORA-00903: Invalid table name at line 8 (open-for) What am I doing wrong? Thanks for any help! Regards, Tomaz CREATE OR REPLACE PROCEDURE cr_test( k_test in out...

Hi! A user on a Windows 98 machine is accessing a report in her browser (IE), but the browser takes only the first 255 characters of the url. She gets the url from a java application. We assume that this is happening because of the Windows 98 as other users have no such problems. Does anybody...

It's working fine now. Some hints for those that still have problems: - make sure you have the file cror815.dll in winnt\system32\, not any old version - create an ODBC connection using that file (not an old one) - check "Procedure returns results" !! Hope This will help someone...

I have a report with three subreports and what bothers me is that when accessing it over the web the user has to enter the username and password four times. I would like to know whether there is some way to enter it only once - like subreport links for parameters. Thanks for any ideas! Tomaz

I have the same problem (report based on stored procedure) and would like to know if there is a solution in the url. Regards, Tomaz

Oracle's definition: CLOBs (Character LOBs) store large blocks of single-byte fixed-width character data from the database character set. We are using CLOBs in our database because varchar2 is limited to 4000 characters which is not enough for our purposes. Is there anyone using clobs? Tomaz

I haven't found anything on clobs in this forum. I'm using Oracle and would like to create a report with a clob field. I created a simple test table with an id and a clob field and when I want to preview the data I get the error ORA-00932: inconsistent datatypes. Is anyone using Oracle clobs...

I opened a new report and added the stored procedure and now I can't even add the parameters in record selection (they are not listed). Any ideas? Tomaz

I'm reporting off a stored procedure for the first time and have a few problems although I read all the white papers, FAQs etc. The sp has one 'in' parameter and one 'in out' (cursor). In the Record Selection Formula I wrote: {?sp_id}={?id} The first problem is that the Stored Procedure...