Reprt section trgger

sharad
Member Posts: 112
Hi all Friends
my problem is that i have following code in a report section named Print single record ,BODY(2)
PrintSingleRec, Body (2) - OnPreSection()
IF (ItemDimValue <> TempSalesInvoiceLine.Description) THEN BEGIN
ItemDimValue := TempSalesInvoiceLine.Description;
SizeDimValue:='';
LineAmount := 0;
GroupQty := 0;
UOM := '';
TempSalesInvoiceLine1.RESET;
TempSalesInvoiceLine1.SETFILTER(Description,'%1',ItemDimValue);
IF TempSalesInvoiceLine1.FIND('-') THEN
REPEAT
SizeDimValue += TempSalesInvoiceLine1."Description 2" + ', ';
GroupQty += TempSalesInvoiceLine1.Quantity;
ListPrice := TempSalesInvoiceLine1."Unit Price Incl. of Tax";
UOM := TempSalesInvoiceLine1."Unit of Measure";
"Disc%" := TempSalesInvoiceLine1."Line Discount %";
IF TempSalesInvoiceLine1."Line Discount %" <> 0 THEN
"UnitPriceExcl.VAT" := TempSalesInvoiceLine1."Unit Price Incl. of Tax" -
(TempSalesInvoiceLine1."Unit Price Incl. of Tax" * (TempSalesInvoiceLine1."Line Discount %"/100))
ELSE
"UnitPriceExcl.VAT" := TempSalesInvoiceLine1."Unit Price Incl. of Tax";
IF (TempSalesInvoiceLine.Type <> TempSalesInvoiceLine.Type :: "G/L Account") AND
(TempSalesInvoiceLine."No." <> RoundOffAc) THEN BEGIN
LineAmount += TempSalesInvoiceLine1."Amount To Customer";
SubTotal += TempSalesInvoiceLine1."Amount To Customer";
TfTotal += (TempSalesInvoiceLine1."Line Amount"+TempSalesInvoiceLine1."Line Discount Amount");
LineDiscAmount += TempSalesInvoiceLine1."Line Discount Amount";
END;
UNTIL TempSalesInvoiceLine1.NEXT=0;
//CurrReport.SHOWOUTPUT(TRUE);
BlankRow += 1;
END ELSE BEGIN
CurrReport.SHOWOUTPUT(FALSE);
END;
// Added By Devendra Gupta on 19/10/2010 for Round Off Value Start
IF (TempSalesInvoiceLine1.Type = TempSalesInvoiceLine1.Type :: "G/L Account") AND
(TempSalesInvoiceLine1."No." = RoundOffAc) THEN BEGIN
RoundOffAmt := TempSalesInvoiceLine."Amount To Customer";
CurrReport.SHOWOUTPUT(FALSE);
BlankRow -= 1;
END;
// Added By Devendra Gupta on 19/10/2010 for Round Off Value End
IF TempSalesInvoiceLine."Unit of Measure" <> '' THEN BEGIN
TFlag:=FALSE;TArrNum:=0;
ArrUnitExist(TempSalesInvoiceLine."Unit of Measure",TFlag,TArrNum);
IF TFlag=TRUE THEN
ArrQty[TArrNum] += TempSalesInvoiceLine.Quantity
ELSE BEGIN
ArrUnit[TArrNum] := TempSalesInvoiceLine."Unit of Measure";
ArrQty[TArrNum] := TempSalesInvoiceLine.Quantity;
END;
END;
TaxAmount += TempSalesInvoiceLine."Tax Amount";
now my question is that how can i manage this code in RTC report?
please help me I waisted so many time in this.
plzzz
my problem is that i have following code in a report section named Print single record ,BODY(2)
PrintSingleRec, Body (2) - OnPreSection()
IF (ItemDimValue <> TempSalesInvoiceLine.Description) THEN BEGIN
ItemDimValue := TempSalesInvoiceLine.Description;
SizeDimValue:='';
LineAmount := 0;
GroupQty := 0;
UOM := '';
TempSalesInvoiceLine1.RESET;
TempSalesInvoiceLine1.SETFILTER(Description,'%1',ItemDimValue);
IF TempSalesInvoiceLine1.FIND('-') THEN
REPEAT
SizeDimValue += TempSalesInvoiceLine1."Description 2" + ', ';
GroupQty += TempSalesInvoiceLine1.Quantity;
ListPrice := TempSalesInvoiceLine1."Unit Price Incl. of Tax";
UOM := TempSalesInvoiceLine1."Unit of Measure";
"Disc%" := TempSalesInvoiceLine1."Line Discount %";
IF TempSalesInvoiceLine1."Line Discount %" <> 0 THEN
"UnitPriceExcl.VAT" := TempSalesInvoiceLine1."Unit Price Incl. of Tax" -
(TempSalesInvoiceLine1."Unit Price Incl. of Tax" * (TempSalesInvoiceLine1."Line Discount %"/100))
ELSE
"UnitPriceExcl.VAT" := TempSalesInvoiceLine1."Unit Price Incl. of Tax";
IF (TempSalesInvoiceLine.Type <> TempSalesInvoiceLine.Type :: "G/L Account") AND
(TempSalesInvoiceLine."No." <> RoundOffAc) THEN BEGIN
LineAmount += TempSalesInvoiceLine1."Amount To Customer";
SubTotal += TempSalesInvoiceLine1."Amount To Customer";
TfTotal += (TempSalesInvoiceLine1."Line Amount"+TempSalesInvoiceLine1."Line Discount Amount");
LineDiscAmount += TempSalesInvoiceLine1."Line Discount Amount";
END;
UNTIL TempSalesInvoiceLine1.NEXT=0;
//CurrReport.SHOWOUTPUT(TRUE);
BlankRow += 1;
END ELSE BEGIN
CurrReport.SHOWOUTPUT(FALSE);
END;
// Added By Devendra Gupta on 19/10/2010 for Round Off Value Start
IF (TempSalesInvoiceLine1.Type = TempSalesInvoiceLine1.Type :: "G/L Account") AND
(TempSalesInvoiceLine1."No." = RoundOffAc) THEN BEGIN
RoundOffAmt := TempSalesInvoiceLine."Amount To Customer";
CurrReport.SHOWOUTPUT(FALSE);
BlankRow -= 1;
END;
// Added By Devendra Gupta on 19/10/2010 for Round Off Value End
IF TempSalesInvoiceLine."Unit of Measure" <> '' THEN BEGIN
TFlag:=FALSE;TArrNum:=0;
ArrUnitExist(TempSalesInvoiceLine."Unit of Measure",TFlag,TArrNum);
IF TFlag=TRUE THEN
ArrQty[TArrNum] += TempSalesInvoiceLine.Quantity
ELSE BEGIN
ArrUnit[TArrNum] := TempSalesInvoiceLine."Unit of Measure";
ArrQty[TArrNum] := TempSalesInvoiceLine.Quantity;
END;
END;
TaxAmount += TempSalesInvoiceLine."Tax Amount";
now my question is that how can i manage this code in RTC report?
please help me I waisted so many time in this.
plzzz
Sharad Gupta
Navision Technical Consultant & .Net Developer
Navision Technical Consultant & .Net Developer
0
Answers
-
You have to move the code to OnAfterGetRecord Trigger with IF ISSERVICETIER THEN BEGIn0
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
- 320 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