Skip to main content

Posts

Showing posts with the label Crystal Report

Remove comma from a String in Crystal Reports

I have a little problem regarding with following in Crystal Report "Salary Sheet For "+ Monthname (month({PrintPaySlip;1.Salary_Date}))+ " "+ totext(TONumber({@FYear})) Outout will be like follwos. Salary Sheet For January 2,010 What i want is like follows (Without the comma) Salary Sheet For January 2010 So the soultion would be like this. "Salary Sheet For "+ Monthname (month({PrintPaySlip;1.Salary_Date}))+ " "+ totext(TONumber({@FYear}),0,"") Thanks for looking a simple function. but if you dont know.... it'll become Difficult.... Learn everything.... impossible but give a try...

Send Crystal Report DIRECTLY TO PRINTER WITH VB.NET || C#

I think you can understand with following code. SalesInvoice rpt = new SalesInvoice(); rpt.RecordSelectionFormula = SQL; rpt.SetDatabaseLogon("sa", "pwd"); PrintDialog prtdlg = new PrintDialog(); prtdlg.ShowDialog();rpt.PrintOptions.PrinterName = prtdlg.PrinterSettings.PrinterName; rpt.PrintToPrinter(prtdlg.PrinterSettings.Copies, prtdlg.PrinterSettings.Collate, prtdlg.PrinterSettings.FromPage, prtdlg.PrinterSettings.ToPage); Keep Programming.
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. All you have to change following property to false or Uncheck the Export option in Property Pages. You CR.WindowShowExportBtn = False Crystal Report Object in Visual Basic 6. (CR is refer to Crystal Report Object ) 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 a