Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Group Footer
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Miscellaneous
Thread ID:
00192109
Message ID:
00194725
Views:
30
This message has been marked as a message which has helped to the initial question of the thread.
>Hi, Rich:
>
>>>>In report designer, double-click the group footer bar (the one that has "Group footer" written on it), and you'll get a small dialog box with "Expression to run" - one "on entry", the other "on exit". You can put your functions there, to be evaluated - and one of them may set a variable to denote that you're in the group footer. The group footer doesn't have to print anything (maybe just one horizontal line), but the variable will tell you when to print your group footer info in the page footer.
>>>>
>>>>I almost forgot that this possibility ever existed, and your question triggered some rusty memories :).
>>>>
>>> Today I wrote in Expression FSetTownEnd(), created function in the same directory as the Report, which contains just
>>>
>>> TownEnd=.t.
>>> return TownEnd
>>>
>>> and all works. When I tried to write in Expression: TownEnd=.t., this variable remains .f.
>>>
>>> So, I need to keep this simple function in the Report Directory (or may be in Progs Directory, when I include this report in the Project). It's not very
>>>convenient :(
>>>
>>> Thanks a lot for your advice again.
>>
>>If you just wrote .T. in the expression, it would have worked. What you wrote told VFP to evaluate whether TownEnd was equal to .T., and return .T. if they were equal and false if they were not equal. They were not equal at that point, so the expression returned .F.
>
> It's weird, but the function returns .T.
>
> I am confusing. I tried to change in GroupFooter Expression to run on entry to .t. instead of FSetTownEnd() and as a result I didn't see my total in the page footer. If I keep it FSetTownEnd() with function that I've described, I see the appropriate result. So, what do I need to change?
>
> As I wrote before, I created a variable TownEnd with .f. in value to store and .f. in initial value. This variable resets in the end of Group (in my case, then a town changes). I want to print total in the Page Footer using Print When when TownEnd (=.t.) Only my function allows me to achieve result. May be I do something wrong, but what? Could you please explain me?
>
> Thanks in advance,
> Nadya

I needed to be more specific. You said "I tried to write in Expression: TownEnd=.t.". Instead of TownEnd=.T., you should have just put .T. Your function which returns .T. works, so you don't have to replace anything. But it's doing more than you need to.

HTH,
Rich.
Rich Addison, Micro Vane, Inc., Kalamazoo, MI
Relax, don't worry, have a homebrew.
- Charlie Papazian, The New Complete Joy of Home Brewing
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform