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