report generation

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. 


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


    -Mohana http://mohana-dynamicsnav.blogspot.in/

    Mohana | Blog | LinkedIn
  • In reply to Mohana:

    ya i tried,

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


    balu
  • In reply to balu:

    Are the fields by any chance FlowFields?


    -Mohana http://mohana-dynamicsnav.blogspot.in/

    Mohana | Blog | LinkedIn
  • In reply to Mohana:

    the field(actual) is a flow field


    balu
  • In reply to balu:

    Did you add the field in CalcFields property also?


    -Mohana http://mohana-dynamicsnav.blogspot.in/

    Mohana | Blog | LinkedIn
  • In reply to Mohana:

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


    balu
  • In reply to balu:

    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?


    -Mohana http://mohana-dynamicsnav.blogspot.in/

    Mohana | Blog | LinkedIn
  • In reply to Mohana:

    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


    balu
  • In reply to balu:

    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


    -Mohana http://mohana-dynamicsnav.blogspot.in/

    Mohana | Blog | LinkedIn
  • In reply to Mohana:

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


    balu
  • In reply to balu:

    Can you show us the sections screenshot also?


    -Mohana http://mohana-dynamicsnav.blogspot.in/

    Mohana | Blog | LinkedIn
  • In reply to Mohana:

    ya here it is


    balu
  • In reply to balu:

     

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


    balu
  • In reply to balu:

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


    balu
  • In reply to balu:

    I hope problem is you set to maintain the totals for one dataitem and expecting result from other dataitems.

    please create decimal variable and add the values to it manually each time..


    -Mohana http://mohana-dynamicsnav.blogspot.in/

    Mohana | Blog | LinkedIn
Related