report generation

Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
Newsletter Subscription Center
page a complete list of our different newsletters.

Not Answered This post has 0 verified solutions | 17 Replies | 1 Follower

111 Posts
1,078 Points
Joined: 2012-11-15
Last Online:
2013-1-8 5:33
Location: visakhapatnam and india
balu posted on 2012-12-5 9:54

hai one and all,

i am generating a report in navision,

it consits of fields of  budgetline item,approved budget,cumilative prior,this prior,cumilative to date,unspent,%.

i am using g/l account table

in budgetline item-source expression is (budgeted amount)

approved budget,-source expression is (actual)

cumilative prior-source expression is (actual)

this prior,-source expression is (actual)

i am getting actual(amount) in cumilative prior and this prior,

but my requirement is that i need to get total fields for this cumilative and this prior(i have taken footer for this and given source expression as actual),even though i am not getting the total field in footer i showing 0.00 in total field ..

is there is any property we have to set for this report.

i am attaching the report what i have generated. 

All Replies

4,952 Posts
126,705 Points
Joined: 2009-2-17
Last Online:
2014-10-31 9:55
Location: Hyderabad, India
DynamicsNAVMVP
Moderator
Mohana replied on 2012-12-5 9:59

Did you try to add those fields in TotalFields property of G/L Account table?

111 Posts
1,078 Points
Joined: 2012-11-15
Last Online:
2013-1-8 5:33
Location: visakhapatnam and india
balu replied on 2012-12-5 10:39

ya i tried,

in total field field proprty of the report i have added even though i am not getting ,it showing 0.00

4,952 Posts
126,705 Points
Joined: 2009-2-17
Last Online:
2014-10-31 9:55
Location: Hyderabad, India
DynamicsNAVMVP
Moderator
Mohana replied on 2012-12-5 10:43

Are the fields by any chance FlowFields?

111 Posts
1,078 Points
Joined: 2012-11-15
Last Online:
2013-1-8 5:33
Location: visakhapatnam and india
balu replied on 2012-12-5 10:47

the field(actual) is a flow field

4,952 Posts
126,705 Points
Joined: 2009-2-17
Last Online:
2014-10-31 9:55
Location: Hyderabad, India
DynamicsNAVMVP
Moderator
Mohana replied on 2012-12-5 10:50

Did you add the field in CalcFields property also?

111 Posts
1,078 Points
Joined: 2012-11-15
Last Online:
2013-1-8 5:33
Location: visakhapatnam and india
balu replied on 2012-12-5 11:12

ya i have added in calcfilelds also eve though i am not getting

4,952 Posts
126,705 Points
Joined: 2009-2-17
Last Online:
2014-10-31 9:55
Location: Hyderabad, India
DynamicsNAVMVP
Moderator
Mohana replied on 2012-12-5 11:40

so How many dataitems you have and in which dataitem footer did you add?

Do you want the total of all dataitems or only one dataitem?

111 Posts
1,078 Points
Joined: 2012-11-15
Last Online:
2013-1-8 5:33
Location: visakhapatnam and india
balu replied on 2012-12-5 12:12

i have same table (g/.l account) three times as shown below i want cumprior(g/l account),thisperiod(g/l account) total in footer

4,952 Posts
126,705 Points
Joined: 2009-2-17
Last Online:
2014-10-31 9:55
Location: Hyderabad, India
DynamicsNAVMVP
Moderator
Mohana replied on 2012-12-5 12:17

you need total of cumprior and thisperiod dataitems?

Like if you have 100 in cumprior and 200 in thisperiod then 300 in footer?

if yes, take a global decimal variable and calculate the the total manually

111 Posts
1,078 Points
Joined: 2012-11-15
Last Online:
2013-1-8 5:33
Location: visakhapatnam and india
balu replied on 2012-12-5 12:25

i have cumprior dataitem(g/l account) and this prior(g/l account) and i need individuals total in footer section as shown below

4,952 Posts
126,705 Points
Joined: 2009-2-17
Last Online:
2014-10-31 9:55
Location: Hyderabad, India
DynamicsNAVMVP
Moderator
Mohana replied on 2012-12-5 12:38

Can you show us the sections screenshot also?

111 Posts
1,078 Points
Joined: 2012-11-15
Last Online:
2013-1-8 5:33
Location: visakhapatnam and india
balu replied on 2012-12-5 12:46

ya here it is

111 Posts
1,078 Points
Joined: 2012-11-15
Last Online:
2013-1-8 5:33
Location: visakhapatnam and india
balu replied on 2012-12-5 12:51

 

i have written code like this as shown below it is generating values but it was not showing total in footer section 

CumPrior - OnPreDataItem()

CumPrior.SETFILTER(CumPrior."Date Filter",'<%1',SDate);

ThisPeriod - OnPreDataItem()

ThisPeriod.SETFILTER(ThisPeriod."Date Filter",'%1..%2',SDate,EDate);

Report - OnPreReport()

SDate := "G/L Account".GETRANGEMIN("G/L Account"."Date Filter");

EDate := "G/L Account".GETRANGEMAX("G/L Account"."Date Filter");

111 Posts
1,078 Points
Joined: 2012-11-15
Last Online:
2013-1-8 5:33
Location: visakhapatnam and india
balu replied on 2012-12-5 12:59

1 ) even though i have removed footer and kept groupfooter in sections it was not getting the totalvalues,the output is as same(0.00).

2 )even though i have removed footer and kept groupfooter in sections it was not getting the totalvalues,the output is as same(0.00).and i have written some piece of code

CumPrior - OnAfterGetRecord()

CurrReport.CREATETOTALS(CumPrior.Actual);

ThisPeriod - OnAfterGetRecord()

CurrReport.CREATETOTALS(ThisPeriod.Actual);

Page 1 of 2 (18 items) 1 2 Next > | Get this RSS feed | Bookmark and Share