mibuso.com

Microsoft Business Solutions online community
It is currently Thu Jun 20, 2013 8:37 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: integer data item not work
PostPosted: Sat Apr 21, 2012 8:13 am 
Offline

Joined: Tue Mar 27, 2012 7:38 pm
Posts: 237
Country: Saudi Arabia (sa)
hi guys i make report as title daily receipt report this report consist of two tables

G/L Account

G/L Entry

this report as following

posted date g/l account no document no amount

12/03/2012 12 15 150

12/03/2012 12 16 200

12/03/2012 12 17 200

12/03/2012 13 18 300

12/03/2012 13 19 400

i make this report but what i need is to display total for every group in footer section or last of report but not after every group .what i need to show report as following
:

12/03/2012 12 15 150

12/03/2012 12 16 200

12/03/2012 12 17 200

12/03/2012 13 18 300

12/03/2012 13 19 400

12 550

13 700

how i make this as above i make this before by group footer but it display after every group but not suitable solution for me.

so that what i need is to add integer data item in last of report to display total for every group
i added but after added i insert g/l entry in this section of body of integer but result display as 0 and repeated more time why and how i solve proplem
please help me

thanks


Top
 Profile E-mail  
 
 Post subject: Re: integer data item not work
PostPosted: Sat Apr 21, 2012 7:29 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Thu Jan 02, 2003 6:37 pm
Posts: 7932
Location: Howell, MI
Country: United States (us)
Just adding an integer dataitem won't automagically create the grouping that you want. You have to think your way through this type of development task. If it were me I would probably think of something like a temporary table to store these group totals, and figure out a way to have a dataitem at the end either based on that temporary table or some other way to have the data out of the temporary table display in a regular body section.

You've been at this for weeks now, when are you going to get some help from a senior, or get a developer from your partner to do this for you? You won't get full on instruction from forums like this, you need someone to sit down with you and show you how to do this.

_________________
Daniel Rimmelzwaan
MVP - Dynamics NAV


Top
 Profile  
 
 Post subject: Re: integer data item not work
PostPosted: Sat Apr 21, 2012 7:36 pm 
Offline

Joined: Mon May 18, 2009 6:36 am
Posts: 792
Location: India
Country: India (in)
Your question is not much clear but as far as i understand based on your report output you want to print total document wise at the end of report or at footer place.
for this take a another GL Entry dataitem without any indentation having grouping on document no. and print only group footer section with total of amount field.

Do not forget to assign all filters to this dataitem that you have been applied above same dataitem.

_________________
Vijay Gupta
Changing the code is last step. Try to change processes first...


Top
 Profile E-mail  
 
 Post subject: Re: integer data item not work
PostPosted: Sat Apr 21, 2012 11:57 pm 
Offline

Joined: Tue Mar 27, 2012 7:38 pm
Posts: 237
Country: Saudi Arabia (sa)
this is good but what i write in filter to make grouping


Top
 Profile E-mail  
 
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], santoshmkcet and 16 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: