Skip to main content
How To Disable Export Button In Crystal Report

When you are taking crystal report printouts through a program, such as program written using vb6. you might have a problem how to disable Export button in print preview.

Preview window contain export Button

All you have to change following property to false or Uncheck the Export option in Property Pages.
You

 CR.WindowShowExportBtn = False

Crystal Report Object

Crystal Report Object in Visual Basic 6. (CR is refer to Crystal Report Object )


Preview window does not contain export Button

You can go to Property Pages by right click and choose Properties on Crystal Report Object

After you done those things you crystal Report print preview will showing like follows.



I was face to above problem. We implemented a software program which is written using vb6.
Cashier can take daily sale print out. before printing it is showing a preview to the user. So when the time pass user click export button and saved that report as a excel file. Then he modified the values and took printout to the management. That gives Security problem to the program and program become unstable. So we Disable Export Button to minimize the problem.
Labels:

Comments

Post a Comment

Popular posts from this blog

Execute *.sql with .NET

Do you ever want to execute slq statements at once. I mean SQL Script file. Normally we are using like following commands to Execute Single SQL statement. SqlCommand cmd = new SqlCommand(sSQL, conn); cmd.ExecuteNonQuery(); cmd.Dispose(); but this way you can execute one command at a time. We cannot execute SQL script using above command. Normal SQL Script Like this. if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__titleauth__au_id__0519C6AF]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[titleauthor] DROP CONSTRAINT FK__titleauth__au_id__0519C6AF GO CREATE TABLE [dbo].[authors] ( [au_id] [id] NOT NULL , [au_lname] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [au_fname] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [phone] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [address] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [city] [varchar] (20) COLL...
4 comments
Read more

Magento DB access denied

I got this error suddenly while accessing the magento site. SQLSTATE[HY000] [1129] Host 'user.workgroup' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' Solution use below command in console mysqladmin flush-hosts or log in to  mysql with a different host if its implemented on network environment and use below statement; FLUSH HOSTS; Or Restart the mysql server
Post a Comment
Read more