Footnote dynamics vs textbox

[tampitt]

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

 

[kray4660]

You have to remember that by the time you get to the Report Footer you are looking at the last detail record. One way around this is to use shared variables (global variables are supposed to work, but I seem to have issues with them for some reason, but I digress) to store the value(s) you want to display in the footer. I am not sure how to do it in your case. The other possible way is to have a sub-report that builds your footnote on the fly, but I cannot think how to do it at this time.

 

[tampitt]

thanks anyway for the suggestion...yes som esort of sub report needs to be created...it look simple but of course it's not

 

[BettyJ]

It can be done on the Page Footer using subreport.

 

[BettyJ]

It can done in the Group footer too. Create a subreport. Add a formula to print the Notes.
(Just an eg. )

@Notes

[tt]whileprintingrecords;
if {emp.name} = 'Jen(1)' then
'1'& {emp.name} & "joined on " &{emp.DateJoined}
else if {emp.name} = 'Andrew(2)' then
'2'& {emp.name} & "joined on " &{emp.DateJoined}
else" ";[/tt]suppress details where @Notes= " "
Don't link (I believe this might be the problem)

Hope this helps.
Betty