Latest Posts

Wednesday, December 24, 2014

.NET Tip : Resolving Error "No Visual Studio Template Information Found"

To restore the default project templates in Visual Studio 2005


Step1 : Go to Visual Studio Command Prompt

Step 2 : Enter the below mentioned command and press Enter 
             
              devenv /installvstemplates


Reference : MSDN
read more...

Tuesday, July 8, 2014

Crystal Report Tip : Lines & Boxes over the watermark

Problem :  Lines & Boxes will always be under the Watermark Image in Crystal Report

Solution :   Using Sub Reports

Steps 

1. Create 2 separate reports. The 1st report will be the main report and the 2nd will be a sub report.
2. Place all page headers and footers on the main report.

Create a Sub report
3. Go to your sub report and place your data and lines on it.
 
Main Report
4. Right click on the PageHeaderSection and insert section below.
5. On the new PageHeaderSection, insert the image(your watermark) and set the section to Underlay Following Sections.
6. Again, right click on the PageHeaderSection and insert section below.
7. On the new PageHeaderSection, right click, Insert->Subreport
8. Select Choose a Crystal Report in a project, then click the 2nd report you've created.


The lines will be now on the top of the image! Just be sure to remove the borders of your sub report.

Reference from CodeProject 
read more...

Sunday, March 30, 2014

Oracle Tip: Recover Deleted Rows from a Table


Problem : Recover deleted rows from a table

Solution : Using timestamp you can recover the deleted data form a table. You can select the data and store it in another table for finding the missing data.



Select * from table1 as of timestamp(to_timestamp('2014-03-29 11:00:00','yyyy-mm-dd hh:mi:ss'))

read more...