I'm trying to group rows like the one in the below image, but I'm having trouble grouping the rows after the details (column 4). Any ideas would be greatly appreciated.
Try it. Maybe helpful:-
Step 1:- Make a report RDLC File.
Step 2 :- Code
report 50121 "Sales Order List"
{
ApplicationArea = All;
Caption = 'Sales Order List';
UsageCategory = ReportsAndAnalysis;
DefaultLayout = RDLC;
RDLCLayout = 'SalesOrderList.rdl';
dataset
{
dataitem(SalesHeader; "Sales Header")
{
column(No; "No.")
{
}
column(SelltoContactNo; "Sell-to Contact No.")
{
}
column(SelltoCustomerName; "Sell-to Customer Name")
{
}
column(DocumentDate; "Document Date")
{
}
column(Amount; Amount)
{
}
}
}
requestpage
{
layout
{
area(content)
{
group(GroupName)
{
}
}
}
actions
{
area(processing)
{
}
}
}
}
Step 3 :- Make Layout by following below photo.
Also, Set The Page As A4. Then Make the layout as above.
Now, I will show all properties used in this rdlc file by providing screenshots of rdlc file.
Step 4 :- Tablix Properties.
Step 5 :- Group Properties.
Step 6 :- Property Used.
Step 7 :- Desired Output.