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

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

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

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

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

When I wish to insert a stored procedure in my report I get the 'error' ORA-00000: normal, successful completion. If I click 'Add' once again I get the error ORA-01001: invalid cursor. I'm working on an Oracle database and the stored procedure does not execute another stored procedure. The...

Is there any way to use Oracle functions in CrystalReports? Thanks, Tomaz

I haven't been using stored procedures till now. Now I am connecting to the database and want to include stored procedures. It takes several minutes before the connection is established on one database and so long I didn't wait on another (both Oracle)! If I don't include stored procedures the...

When I insert a blob field in my report the preview doesn't display it. There's just an empty place although there should be data. Any ideas will be appreciated! Tomaz

I have read all the articles and FAQ on blobs but still have no solution to the error "Inconsistent datatypes" which I get when I want to display a blob field. I'm using an Oracle 8i database. I'll be grateful for any advice. Tomaz

I find web reporting very slow because I can't use indexes or server for speed. If I do use it I get the error message 'Error detected by database dll'. Also I can't view reports in my browser if they were created with the Crystal SQL Designer. How can I create reports for the web so that they...

I have two columns (id, code) from one table. Id is a number, code is a string. The correct output would be: 1,00 01245 2,00 01465 3,00 02546 But I get the output: 1,00 1 2,00 2 3,00 3 The code gets the same value as id but it is still a string. I get the same result...

I hope rank is the correct English word for the thing I'm looking for. I think that some data will describe the problem. Group Number Name Count({Field}) Rank 1 Person1 79 1 2 Person2 74...