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