thanks that works great:laugh: with regards, Barathan.K Barathan.K barathank@gmail.com

Hi Friends, I am trying to load the dataset to populate my crystal report. While getting data i am using a formulae to calculate a profit margin here if any column has zero i have bypass the formulae calculation as it return some error. how to use conditional statements inside the Formulae like this if @Sale <> 0 and @Cost <> 0 ({@Sale} / {@Cost} - (1/100) * 100) * 100 so please help...:confused: Thanks in Advance. Barathan.K barathank@gmail.com

Hi murtuza, I think Method II Works Great!!. You want to set the Bottom Margin to 5.5" and rest as by default. HAPPY PROGRAMMING ! ;) With Regards, Barathan.K barathank@gmail.com

hi, You have Two Methods METHOD I If you need to change the size or orientation of a Crystal Report, you can do this in the VS IDE by right-clicking your report and navigating Designer >> Printer Setup. On the first tab, you can choose the paper size and orientation. Hit OK to return to the IDE, and the report canvas will automatically resize to what you just specified. I don't recommend setting any of the advanced printer options in your report unless you know the people printing the report will be using the same printer (such as a network printer). Also, if you can't fit your report on letter (or A4 for the metric world), the user is probably going to have to change the paper in the printer, which will more than likely cause some grumbling. METHOD II You can also change the bottom Margin of the paper to your custom size that is for half the page(5.5") you can do this in the VS IDE by right-clicking your report and navigating Designer >> Page Setup. Modify the margins. HAPPY PROGRAMMING ! ;) With Regards, Barathan.K barathank@gmail.com

hi my dear friend, always Try avoiding a user interface, inputs and message boxes in the service application or for starting the service. To make your service to start Automatically during the start up of windows in the serviceinstaller Open the service.vb design window, right click on it and select Add Installer option, which will add an installer project (called ProjectInstaller.vb) with two controls -- ServiceProcessInstaller1 and ServiceInstaller1 -- to our existing project. Open ProjectInstaller.vb, select the ServiceInstaller1 control, and open the property window. Change the StartType property to automatic if you want to start the service automatically during the OS Start Up. HAPPY PROGRAMMING! ;) With regards, Barathan.K Barathan.K