Hello

I'm not sure if there is a way to dynamically linking the footnote in the report footer section to some formulas from details section? here is an example:

=============================================================
employee gender date joined
John      M      03/21/2010
Keith     M      02/15/1998
Jen(1)    F      11/22/2000
Jane      F      10/27/2012
Andrew(2) M      05/05/2007       

Note:
(1) Jen joined us 2000 as contractor
(2) Andrew started with us in 2000, left 2001 then comeback 07
==============================================================

I can have a formula something like
===================================
if {emp.name} = 'Jen' then
   '1'
else if {emp.name} = 'Andrew' then
   '2'
else if ........
====================================
This would work for details section but as soon as I put this in either Page footer or Report Footer section, it doesn't work...am I missing something?

thanks in advanced

TT

you could use a variable to hold the footnotes. as you add them in the detail section you would increment the footnote variable, and then display it in report footer.

the details would be something like:
shared stringvar footnotes;
local stringvar crlf := chrw(13) + chrw(10);

if (what ever triggers a footnote) then
footnotes := footnotes + crlf + "(" + totext((your footnote number), 0, "") + ")" + {table.field}; //assuming the comment from a field
""// hides the output of the growing footnote


in the report footer, the formula would like:
shared stringvar footnote;
mid(footnote, 3) //removes the first crlf (which is 2 characters)

also set the formula in the report footer to Can Grow.

HTH

I just want to place a note in the footer, just text nothing else