Site hosted by Angelfire.com: Build your free website today!

Hi,

The Page Footer is always displayed at the bottom of the page. In Crystal Reports XI, when I use the Section Expert to edit the properties of the Page Footer, I see that the "Print at Bottom of Page" option is enabled and greyed out, therefore I cannot edit this property.

The Group Footer is the correct place to display the signature. You indicated that you cannot use Group Footer for the signature but you didn't state why you cannot use it.

If the problem is that your query does not return a value that you can group on, consider revising your SQL schedule crystal report to return one more column that you can group on.

e.g.

select 1 alias GROUPVALUE, FIELD1, FIELD2 from MYTABLE where FIELD3 = 'somevalue1'

UNION ALL

select 2 alias GROUPVALUE, FIELD1, FIELD2 from MYTABLE where FIELD3 = 'somevalue2'

UNION ALL

select 3 alias GROUPVALUE, FIELD1, FIELD2 from MYTABLE where FIELD3 = 'somevalue3'

;

In your report you can group on GROUPVALUE column but only display the FIELD1 and FIELD2 values. In Group Header 1 you should document burster enable the New Page Before option. In Group Footer 1 http://www.4shared.com/office/Zvqa7SGVce/Crystal_reports_page_footer_pr.html you should display the signature.

I hope this gives you a new idea on Burst and delivery crystal reports how to implement the signature via Group Footer. The Page Footer simply cannot be moved.

IntegrateCrystalReports.gif

Jeff

https://answers.yahoo.com/question/index?qid=20080316014600AA20CUn