footer total amount in report give me 0 although values are found

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 by put this fields in g/l entry section in report when i make group footer it work good as following:

12 550

13 700

but when i put total in footer the result is 0 why can any one solve this problem to me .

my report section as following:

g/l account,body

no name

g/l entry,body

posted date g/l account no document no amount

g/l account group footer

amount(work good)

g/l account footer

amount(this is problem) it give 0 why although i write in pre section of two table

G/L Account

G/L Entry

CurrReport.CREATETOTALS(“G/L Entry”.Amount);

please any one help me

thanks

Are you running the report for any particular G/L Account or for all?

Run it for any particular G/L Account…

Hi

May be this helps you

Try this simple report designed in NAV 2009 R2 if you are using differnt version then remove the RDL Data section

OBJECT Report 50104 GL Account group
{
OBJECT-PROPERTIES
{
Date=10/04/12;
Time=17:12:57;
Modified=Yes;
Version List=ASHISH;
}
PROPERTIES
{
}
DATAITEMS
{
{ PROPERTIES
{
DataItemTable=Table15;
OnPreDataItem=BEGIN
CurrReport.CREATETOTALS(“G/L Entry”.Amount);
END;

ReqFilterFields=No.;
}
SECTIONS
{
{ PROPERTIES
{
SectionType=Body;
SectionWidth=12000;
SectionHeight=846;
}
CONTROLS
{
{ 1000000013;TextBox;900 ;0 ;1500 ;423 ;SourceExpr=“No.” }
{ 1000000015;TextBox;3450 ;0 ;4500 ;423 ;SourceExpr=Name }
}
}
{ PROPERTIES
{
SectionType=Footer;
SectionWidth=12000;
SectionHeight=423;
}
CONTROLS
{
{ 1000000001;TextBox;7500 ;0 ;1800 ;423 ;SourceExpr=“G/L Entry”.Amount }
{ 1000000003;TextBox;750 ;0 ;2250 ;423 ;FontSize=8;
FontBold=Yes;
SourceExpr=‘Total’ }
}
}
}
}
{ PROPERTIES
{
DataItemIndent=1;
DataItemTable=Table17;
DataItemTableView=SORTING(G/L Account No.,Posting Date);
OnPreDataItem=BEGIN
CurrReport.CREATETOTALS(“G/L Entry”.Amount);
END;

TotalFields=Amount;
GroupTotalFields=G/L Account No.;
DataItemLink=G/L Account No.=FIELD(No.);
}
SECTIONS
{
{ PROPERTIES
{
SectionType=Body;
SectionWidth=12000;
SectionHeight=423;
}
CONTROLS
{
{ 1000000000;TextBox;1050 ;0 ;1200 ;423 ;SourceExpr=“Posting Date” }
{ 1000000002;TextBox;3000 ;0 ;1500 ;423 ;SourceExpr=“G/L Account No.” }
{ 1000000004;TextBox;5400 ;0 ;1500 ;423 ;SourceExpr=“Document No.” }
{ 1000000006;TextBox;7500 ;0 ;1800 ;423 ;SourceExpr=Amount }
}
}
{ PROPERTIES
{
SectionType=GroupFooter;
SectionWidth=12000;
SectionHeight=423;
}
CONTROLS
{
{ 1000000017;TextBox;7500 ;0 ;1800 ;423 ;SourceExpr=“G/L Entry”.Amount }
{ 1000000005;TextBox;750 ;0 ;2250 ;423 ;SourceExpr='Total for ’ + “G/L Account No.” }
}
}
}
}
}
REQUESTFORM
{
PROPERTIES
{
Width=9020;
Height=3410;
}
CONTROLS
{
}
}
REQUESTPAGE
{
PROPERTIES
{
}
CONTROLS
{
}
}
CODE
{

BEGIN
END.
}
RDLDATA
{
}
}

OK thank you very much