(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › GROUP FOOTERS IN REPORTS
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic GROUP FOOTERS IN REPORTS (Read 743 times)
Louis Galvao
Full Member
***
Offline


"Sufferin' Succatash"

Posts: 265
Location: Canada
Joined: Feb 14th, 2005
GROUP FOOTERS IN REPORTS
Apr 13th, 2005 at 4:18pm
Print Post Print Post  
I encountered a problem in a new multi-group report where I tried to program an unbound field within the Group Footer.

I have 3 footers:  first footer contains a SUM - LE33; second footer contains the UNBOUND LE145 and the third footer contains another different SUM - LE120.

I tried to program LE145 as follows but received an operand error:

LE145 = LE33 / LE120

Is there a restriction in trying to program a field with references to Summary Calculation fields ?

Thanks,

Louis
  
Louis Galvao
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: GROUP FOOTERS IN REPORTS
Reply #1 - Apr 13th, 2005 at 5:56pm
Print Post Print Post  
Hello Louis,

The values of Summary Calculations can not be used in SBasic. The SBasic Programming is going to run before the values are assigned to Summary Calculation Elements.

You will need to do the sums in programming. Store the values in Global Statics and then use the Global Statics in your LE145 on Print Event.

Ex This would go in global code
Code
Select All
Stat gsTotalPeople as Int
Stat gsTotalCurrency as Double


This code would go in an element in your group body
Code
Select All
gsTotalPeople = gsTotalPeople + MyPeopleLE
gsTotalCurrency = gsTotalCurrency + MyCurrencyLE


Then in your LE145 programming event would go the following
Code
Select All
LE145 = gsTotalCurrency / gsTotalPeople


-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge