Share
Report
281Dear Members,
I would like to know whether it is possible to create RDLC Report with a temporary table as its source table in Business Central. I tried with the code which I had attached below for your refference. I am able to design the report and but when I try to run the report by uploading it in the custom report layouts, I am getting the following error message: "The report couldn’t be generated, because it was empty. Adjust your filters and try again."
I had designed the report by inserting it (Fields) into the table. I am not able to get the values in the rdlc report as it shows the report is empty.
The code with which I had tried to create the report is as below:
report 50109 Reportname
{
UsageCategory = ReportsAndAnalysis;
ApplicationArea = All;
Caption='Test Report';
RDLCLayout = 'TestReport.rdl';
DefaultLayout=RDLC;
dataset
{
dataitem(Temporarytable_name; Temporarytable_name)
{
column(Amount;Amount)
{
}
column(AmountIncVAT;AmountIncVAT)
{
}
column(Bill_to_Name;Bill_to_Name)
{
}
column(Manufacturing_Orgin;Manufacturing_Orgin)
{
}
column(BusinessUnit;BusinessUnit)
{
}
column(DocumentNo;DocumentNo)
{
}
column(ItemNumber;ItemNumber)
{
}
column(Class;Class)
{
}
column(Order_Date;Order_Date)
{
}
column(ShipmentDate;ShipmentDate)
{
}
column(Product_Name;Product_Name)
{
}
column(Product_Type;Product_Type)
{
}
column(Quantity;Quantity)
{
}
column(VendorName;VendorName)
{
}
}
}
requestpage
{
layout
{
area(Content)
{
group(GroupName)
{
}
}
}
actions
{
area(processing)
{
action(ActionName)
{
ApplicationArea = All;
}
}
}
}
}
Can you suggest me ways to achieve solution to create a custom report from temporary table ..?
Thanks in Advance,
Saravanan M
All responses (
Answers (
