Search results for query: *

Hi, When we export crystal report 8.5 to excel we face following problems: If Tabular option is selected, sections in the data get overwritten with report footer, or lables get shifted towards right. If subreport is used, alignment goes haywire. If Non-tabular is selected, the format of the...

Dear All, Our application uses "sa" user to login to SQL Server Database. The password of this user is present in the registry. If any user get to know the password, they can easily login to out database, take backup of it etc. How can this be prevented? Regards,

The program unit is a library procedure that resides on the DB server.

I receive the following error after attempting to run the report: REP-1401: 'beforereport': Fatal PL/SQL error ORA-06508: PL/SQL: could not find program unit being called The report versions that we use are: Report Builder 6.0.8.8.3 ORACLE Server Release 8.0.6.0.0 Oracle Procedure Builder...

We have an application developed using forms 6i and oracle8i. The clients upgraded the database to oracle9i. In the application we have started error ora_30926 "Unable to get a stable set of rows in the source tables". Will the application work as it is in oracle9i Or changes in the...

Hi, Is it possible to open a crystal report file on web by converting to an html? quisar

Thanks kenhamady. The solution you gave worked. The onl;y problem being if VAL happens to be an exact integer, it also loses its decimal place. We also have crystal reports v 8.5. I will try if this problem can be solved using 8.5 Thanks, Quisar

Will the problem be solved if I update to crystal report 8.5 Quisar

Thanks for replying JohnEck. I have tried this. If {Type} = "Q" then 0 else 2 then ,it formats both the columns with no zeroes. and If {Type} = "V" then 2 else 0 then the format of both the columns is formatted to 2 decimals. Do you have any other solution? Quisar

Hi, We are using crystal reports 7.0 and have used crosstab to print the below report: Branch1 Branch2 Total Qty Val Qty Val Qty Val Product1 1 9.5 2 8.1 3 17.7 Product2 2 3.7 3 3.2 5 6.9 . . The no. of products and branch...

Hi!! We have oracle database installed on a server. Our application created in VB is installed on all clients. The reports and executables are also only on the server. To access the database, reports and executables from clients we have registry on each client. Hence the database username and...

Hi!! We have oracle database installed on a server. Our application created in VB is installed on all clients. The reports and executables are also only on the server. To access the database, reports and executables from clients we have registry on each client. Hence the database username and...

Can you give more information on the problem. Like if there is any error or it says no data to be merged and still data not replicated. What replication,connection, other settings. Then I may be able to help. Quisar

Hi! What is an alternative to using 'LIKE' operator with recordsets. We have created a searching facility similar to a LOV in D2K. How do we filter the values sililar to this? % also doesnt work. Is there any code,control already available to do this? Thanks, Quisar

Hello, I need to identify the latest 5 rows inserted in my table. I am using a timestamp col for this. But in case of bulk insert that col has same values at times. I want it to be unique. How can i achieve this without adding another col in the table? Thanks, Quisar

Hello, I have merge replication setup using pull subscription. All tables are set with not for replication option. Now if there is a conflict which is not resolved at all does it resolve on its own after sometime. Because we had rows in conflict which were not resolved. Now the data is missing...

Hi, I have a VB project using SQL Server 2000. Now I want to use the same code for Oracle. Can this be done without changing the SQL statement used? Is there any tool in the database itself or any third party utility? Thanks, Quisar

Hi! We have few reports developed in sql server 2000. Now we want to change to oracle, the table structures etc being the same . I tries doing it by logging off and log in to oracle and using set location selecting the table from scott. After verifying the database, I get a message database...

Thanks sem and T. Blom. This is what I wanted. Quisar

Thanks, but this is not what I want. I have a date col in the table. I want the latest record entered. I record the date and time when the rec was inserted and want the last 2 records of the latest date. I hope you understand. Let me know if any clarification req. Thanks Quisar