768
i am working on extension 2.0
i am facing with error while reporting i have 2 data item now facing that how to link this data item
DataItemTableView Property ?
DataItemLink Property ?
need this two property how to use it in extension 2.0 ?
Thanks
report 50121 NewPSalesInvoiceReport
{
Caption = 'Sales Invoice Report';
ApplicationArea = all;
DefaultLayout = RDLC;
UsageCategory = ReportsAndAnalysis;
RDLCLayout = 'NewPSalesInvoiceReport.rdl';
dataset
{
dataitem("Sales Invoice Header";"Sales Invoice Header")
{
DataItemTableView = sorting("No.");
RequestFilterFields = "Sell-to Customer No.","No.","Posting Date";
PrintOnlyIfDetail = true;
column(CompNme;CompanyInformation.Name)
{}
column(CompName2;CompanyInformation."Name 2")
{}
Column(SelltoCustomerNo_SalesHeader;"Sales Invoice Header"."Sell-to Customer No."){}
trigger OnAfterGetRecord()
begin
CountryName := '';
IF CountryRegion.GET("Sales Invoice Header"."Sell-to Country/Region Code") THEN
CountryName := CountryRegion.Name;
end;
}
dataitem("Sales Invoice Line";"Sales Invoice Line")
{
DataItemTableView = SORTING("Document No.","Line No.");
DataItemLinkReference = "Sales Invoice Header";
PrintOnlyIfDetail= false;
Column(Amount_SalesLine;"Sales Invoice Line".Amount){}
trigger OnPreDataItem()
begin
SetRange("Document No.","Sales Invoice Header"."No.");
end;
}
}
trigger OnPreReport()
begin
CompanyInformation.GET;
CompanyInformation.CALCFIELDS(Picture);
IF CountryRegion.GET(CompanyInformation."Country/Region Code") THEN;
end;
var
CompanyInformation:Record "Company Information";
CountryRegion:Record "Country/Region";
CountryName:Text;
CustLedgerEntry:Record "Cust. Ledger Entry";
}
You can use DataItemLink like the following:
dataitem("Sales Header"; "Sales Header")
{
column("No"; "No.")
{
}
dataitem("Sales Line";"Sales Line")
{
DataItemLink = "Document Type"=FIELD("Document Type"),"Document No."=FIELD("No.");
column(Type; Type)
{
}
}
}
#1
André Arnaud de Cal...
291,784
Super User 2024 Season 2
#2
Martin Dráb
230,476
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
