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
{
}
}