Friday, February 22, 2013

Format Field Option in Crystal Reports

My requirement is to format all fields to a one font type, color and size.


Right click the field which you want to apply the format of it for others. Then click the Paint brush icon in tool bar.


Finally click the field which you want format.


Make Insert Queries for the Existing Data in MS SQL


Step 1 : Right Click the MS SQL Data Base. Go --> Tasks --> Generate Scripts 


Step 2 : Click the Next button.

Step 3 : Select the table/s data which you want to take as insert query. Then Click Next

Step 4 : Click the advance button and select the Types of data to Scripts option and set it to the Schema and data. Then give a path for save your query. 


Step 5 : Wait till the process compete and collect you query .