Designing Reports
kolaboy
Member Posts: 446
Hi Experts,
I am trying to design a report from scratch using the Cust. Ledger Entry table and the Detailed Cust. ledger Entry table as my dataitems so that i can display the payments made and the Finance charge Memos which have been applied for each customer.
The report should show the amounts paid under one column called amount and the finance charges under the finance charge column separately. The finance charge should show only the finance charge that are applied.
I tried doing this but my problem is, the finance charge column amounts are not showing the finance charges but addition of some figures which i don't know. Here is a text format of my objects:
Can anyone help me out to get this correct please!!!
Thanks
I am trying to design a report from scratch using the Cust. Ledger Entry table and the Detailed Cust. ledger Entry table as my dataitems so that i can display the payments made and the Finance charge Memos which have been applied for each customer.
The report should show the amounts paid under one column called amount and the finance charges under the finance charge column separately. The finance charge should show only the finance charge that are applied.
I tried doing this but my problem is, the finance charge column amounts are not showing the finance charges but addition of some figures which i don't know. Here is a text format of my objects:
OBJECT Report 50020 TwoDataItem
{
OBJECT-PROPERTIES
{
Date=18/07/07;
Time=[ 0:44:14];
Modified=Yes;
Version List=;
}
PROPERTIES
{
}
DATAITEMS
{
{ PROPERTIES
{
DataItemTable=Table21;
DataItemTableView=SORTING(Entry No.)
ORDER(Ascending)
WHERE(Document Type=FILTER(Finance Charge Memo),
Document Type=FILTER(Payment));
GroupTotalFields=Document Type;
}
SECTIONS
{
{ PROPERTIES
{
SectionType=Header;
PrintOnEveryPage=Yes;
SectionWidth=25650;
SectionHeight=846;
}
CONTROLS
{
{ 1000000009;Label ;0 ;0 ;1500 ;846 ;ParentControl=1000000008;
HorzAlign=Right;
VertAlign=Bottom;
FontSize=8;
FontBold=Yes;
MultiLine=Yes }
{ 1000000011;Label ;1650 ;0 ;1800 ;846 ;ParentControl=1000000010;
VertAlign=Bottom;
FontSize=8;
FontBold=Yes;
MultiLine=Yes }
{ 1000000013;Label ;3600 ;0 ;1200 ;846 ;ParentControl=1000000012;
HorzAlign=Right;
VertAlign=Bottom;
FontSize=8;
FontBold=Yes;
MultiLine=Yes }
{ 1000000015;Label ;5550 ;0 ;1650 ;846 ;ParentControl=1000000014;
VertAlign=Bottom;
FontSize=8;
FontBold=Yes;
MultiLine=Yes }
{ 1000000017;Label ;8100 ;0 ;1800 ;846 ;ParentControl=1000000016;
HorzAlign=Right;
VertAlign=Bottom;
FontSize=8;
FontBold=Yes;
MultiLine=Yes }
}
}
{ PROPERTIES
{
SectionType=Body;
SectionWidth=25650;
SectionHeight=846;
}
CONTROLS
{
{ 1000000008;TextBox;150 ;0 ;1350 ;423 ;SourceExpr="Entry No." }
{ 1000000010;TextBox;1650 ;0 ;1500 ;423 ;SourceExpr="Customer No." }
{ 1000000012;TextBox;3600 ;0 ;1200 ;423 ;SourceExpr="Posting Date" }
{ 1000000014;TextBox;5550 ;0 ;1500 ;423 ;SourceExpr="Document Type" }
{ 1000000016;TextBox;8100 ;0 ;1800 ;423 ;SourceExpr=Amount }
}
}
}
}
{ PROPERTIES
{
DataItemIndent=1;
DataItemTable=Table379;
DataItemTableView=SORTING(Customer No.,Posting Date,Entry Type,Currency Code)
ORDER(Ascending)
WHERE(Entry Type=FILTER(Application),
Initial Document Type=FILTER(Payment));
ReqFilterFields=Customer No.,Posting Date;
TotalFields=Amount,Credit Amount;
GroupTotalFields=Document Type;
DataItemLink=Cust. Ledger Entry No.=FIELD(Entry No.);
}
SECTIONS
{
{ PROPERTIES
{
SectionType=GroupFooter;
SectionWidth=25650;
SectionHeight=423;
}
CONTROLS
{
{ 1000000000;TextBox;150 ;0 ;3300 ;423 ;SourceExpr="Posting Date" }
{ 1000000002;TextBox;10800;0 ;1800 ;423 ;SourceExpr=Amount }
{ 1000000004;TextBox;4950 ;0 ;1500 ;423 ;SourceExpr="Customer No." }
{ 1000000006;TextBox;13500;0 ;1800 ;423 ;SourceExpr="Credit Amount" }
}
}
{ PROPERTIES
{
SectionType=Footer;
PrintOnEveryPage=No;
SectionWidth=25650;
SectionHeight=846;
}
CONTROLS
{
{ 1000000018;TextBox;10800;0 ;1800 ;423 ;SourceExpr=Amount }
{ 1000000001;TextBox;13650;0 ;1800 ;423 ;SourceExpr="Credit Amount" }
}
}
}
}
}
REQUESTFORM
{
PROPERTIES
{
Width=9020;
Height=3410;
}
CONTROLS
{
}
}
CODE
{
BEGIN
END.
}
}
Can anyone help me out to get this correct please!!!
Thanks
0
Comments
-
Hi exprts,
I am still waiting for you ideas on this post. I still can't make a headway.
I need your help Please!!!! ](*,) ](*,) ](*,)0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 322 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions