mibuso.com

Microsoft Business Solutions online community
It is currently Sun May 19, 2013 2:31 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: Get Total Fields
PostPosted: Sun Apr 29, 2012 1:17 pm 
Offline

Joined: Thu Apr 28, 2011 3:25 pm
Posts: 23
Country: Kuwait (kw)
Hi All

I have one report and i added in the report under Body Section a column Quantity*Cost how i can get the sum (Total) of this field in Footer Section

Regards,


Top
 Profile E-mail  
 
 Post subject: Re: Get Total Fields
PostPosted: Mon Apr 30, 2012 7:10 am 
Offline

Joined: Wed Apr 07, 2004 9:39 am
Posts: 338
Location: Bangalore
Country: India (in)
Hi,

Declare a decimal variable in the report, sum it in the OnAfterGetRecord of the dataitem from where you are reading the Quantity and Cost fields and then print the variable in the footer section.

Did I understand your question?

Chn


Top
 Profile E-mail WWW  
 
 Post subject: Re: Get Total Fields
PostPosted: Mon Apr 30, 2012 8:44 am 
Offline

Joined: Thu Apr 28, 2011 3:25 pm
Posts: 23
Country: Kuwait (kw)
Chinmoy wrote:
Hi,

Declare a decimal variable in the report, sum it in the OnAfterGetRecord of the dataitem from where you are reading the Quantity and Cost fields and then print the variable in the footer section.

Did I understand your question?

Chn


Thanks a lot for replying

I added a text box in report in body section then i go to text box properties in SourceExpr i added qty*cost now how i can get total of this field in footer.

I can get total qty and cost separate in footer but what i need the total of qty*cost

Regards,


Top
 Profile E-mail  
 
 Post subject: Re: Get Total Fields
PostPosted: Mon Apr 30, 2012 10:32 pm 
Offline
MVP Microsoft Dynamics NAV
Site Supporter

Joined: Fri Jun 06, 2003 9:01 pm
Posts: 6977
Location: L.I., New York
Country: United States (us)
See here:
http://msdn.microsoft.com/en-us/library/dd301337.aspx

_________________
Harry Ruiz
http://www.cosmeticsolutions.com
http://www.autismspeaks.org


Top
 Profile E-mail WWW  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: Google [Bot], vaprog and 12 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: