report generation

Not Answered This post has 0 verified solutions | 3,322 Views | 17 Replies | 1 Follower

111 Posts
638 Points
Joined: 2012-11-15
Last Online:
2013-1-8 5:33
Location: visakhapatnam and india
balu posted on 2012-12-5 9:54 rated by 0 users

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

5,129 Posts
117,398 Points
Joined: 2009-2-17
Last Online:
2016-2-12 14:03
Location: Hyderabad, India
DynamicsMVP
ModeratorDynamicsNAV

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

  • | Post Points: 6
111 Posts
638 Points
Joined: 2012-11-15
Last Online:
2013-1-8 5:33
Location: visakhapatnam and india

ya i tried,

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

  • | Post Points: 6
5,129 Posts
117,398 Points
Joined: 2009-2-17
Last Online:
2016-2-12 14:03
Location: Hyderabad, India
DynamicsMVP
ModeratorDynamicsNAV

Are the fields by any chance FlowFields?

  • | Post Points: 6
111 Posts
638 Points
Joined: 2012-11-15
Last Online:
2013-1-8 5:33
Location: visakhapatnam and india

the field(actual) is a flow field

  • | Post Points: 6
5,129 Posts
117,398 Points
Joined: 2009-2-17
Last Online:
2016-2-12 14:03
Location: Hyderabad, India
DynamicsMVP
ModeratorDynamicsNAV

Did you add the field in CalcFields property also?

  • | Post Points: 6
111 Posts
638 Points
Joined: 2012-11-15
Last Online:
2013-1-8 5:33
Location: visakhapatnam and india

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

  • | Post Points: 6
5,129 Posts
117,398 Points
Joined: 2009-2-17
Last Online:
2016-2-12 14:03
Location: Hyderabad, India
DynamicsMVP
ModeratorDynamicsNAV

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?

  • | Post Points: 6
111 Posts
638 Points
Joined: 2012-11-15
Last Online:
2013-1-8 5:33
Location: visakhapatnam and india

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

  • | Post Points: 6
5,129 Posts
117,398 Points
Joined: 2009-2-17
Last Online:
2016-2-12 14:03
Location: Hyderabad, India
DynamicsMVP
ModeratorDynamicsNAV

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

  • | Post Points: 6
111 Posts
638 Points
Joined: 2012-11-15
Last Online:
2013-1-8 5:33
Location: visakhapatnam and india

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

  • | Post Points: 6
5,129 Posts
117,398 Points
Joined: 2009-2-17
Last Online:
2016-2-12 14:03
Location: Hyderabad, India
DynamicsMVP
ModeratorDynamicsNAV

Can you show us the sections screenshot also?

  • | Post Points: 6
111 Posts
638 Points
Joined: 2012-11-15
Last Online:
2013-1-8 5:33
Location: visakhapatnam and india

ya here it is

  • | Post Points: 5
111 Posts
638 Points
Joined: 2012-11-15
Last Online:
2013-1-8 5:33
Location: visakhapatnam and india

 

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");

  • | Post Points: 5
111 Posts
638 Points
Joined: 2012-11-15
Last Online:
2013-1-8 5:33
Location: visakhapatnam and india

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);

  • | Post Points: 6
Page 1 of 2 (18 items) 1 2 Next > | Get this RSS feed