Formula Fields:
//
SetSectionIntro, Set Section to Intro.
Global StringVar SectionName;
SectionName := "Introduction";
//
SetSectionRev, Set Section to Revision.
Global StringVar SectionName;
SectionName := "Revision";
//
GetSection, returns the section name
Global StringVar SectionName;
The first two formula fields set the value of the global variable and the last formula field return the global variable value when called.
Outline:
My report have 2 group footer sections where I call the SetSection formula in each of the group footers. The global variable is not updating and only reflects the first SetSection call "Introduction".
Report layout:
Report Header
Page Header
Group Header #1
Details
Group Footer #1a
SetSectionIntro
GetSection //Returns the correct value as "Introduction")
Group Footer #1b
SetSectionRev
GetSection //Returns the incorrect value as "Introduction" and should be "Revision"
Report Footer
Page Footer
Any pointers or assistance is greatly appreciated. Let me know if that does not make sense?