17,504
Like
Share
ReportWhen defining a dataset for a report in Business Central, you can use the following types of columns:
📄 A field in a table
Add a field directly from the data item’s table.
dataitem(Customer; Customer)
{
column(CustomerName; Name) { }
column(City; City) { }
}
Here,
Name and City are fields in the Customer table.📝 A variable
Use a variable declared in report.
dataitem(Customer; Customer)
{
column(Greeting; GreetingText) { }
}
var
GreetingText: Text[50];
procedure OnPreDataItem()
begin
GreetingText := 'Hello, Customer!';
end;
Here,
GreetingText is a custom variable added as a column.➕ An expression
– Use a calculated value or function result.
dataitem(SalesLine; "Sales Line")
{
column(TotalAmount; "Quantity" * "Unit Price") { }
}
Here, the column calculates
Quantity * Unit Price for each sales line.🏷️ A caption
– Labels or static text not tied to a specific table
dataitem(Customer; Customer)
{
column(ReportTitle; 'Customer Sales Report') { }
}
Here,
ReportTitle is a caption displayed in the dataset.Thanks For Reading...!!
Regards,
Khushbu Rajvi
*This post is locked for comments