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

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


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 

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'))