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,

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

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

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

Hi I was using sql server 2000, where it is easy to get top n records by writing select top 2 * from emp. How is the same in oracle. Also select rowid from emp does not give any results. Why is that so? Quisar

When I change the password of administrator user in win 2000 professional, sql server(only client installed) is unable to connect to sql server 2000 server and gives connection error. Why does this happen? Quisar

Hi!! Can we change primary key of tables when used in replication? The problem I have is, There is a table with 2 primary keys, I want to add one more column as pk to this. I'm not able to do it since it is an allow null. I tried changing the null to not null after updating that column's...

Hi! How should we set retention period for replication in sqlserver 2000. There is an option in publisher properties in general tab "Subscription never expires" and "no. of days subscription can expire". Is this the same as setting retention period? I'm confused. Quisar

I have a stored procedure to which an int value numdays is passed. The following is the code in the SP. declare @purgedate datetime, @command varchar(1000), @database varchar(128), @numrows int, select @purgedate = dateadd(dd, -1 * @numdays + 1...

Hi! We have set identity cols as "Not for replication" and different range for the publisher and subscriber using merge replication. Now the subscriber we are getting an error "The identity range managed by replication is full and must be updated by a replication agent. The...

Hi! We have problem, we are using merge replication, it worked fine for 10 days. Now, data is getting transferred only one way and the other way is not happening. What must be the problem? We are able to ping both the ways. Thanks, Quisar