Breaking news from around the world
Get the Bing + MSN extension
Check out the latest Business Central updates!Learn about the key capabilities and features of Dynamics 365 Business Central and experience some of the new features.
Download overview guide | Watch Business Central video
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | View virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
I have to create a report in Business Central which will display the details of time sheet of a particular user.
I followed the docs available and created a report but that report is completely empty.
As per the docs, I created the layout of report in the .rdl file generated. But still that layout is not getting reflected in the report.
Please provide direction to achieve the same. Moreover, how to fetch the data from time sheet into the report ?
Following is the AL code being used -
Thanks in advance !
Is "My Time Sheets" your source table (where you have the data)?
This is the data I want to display. Am I correct with the name of source table ?
No. tables are named "Time Sheet Header" and "Time Sheet Line".
You can check tables via Page Inspector.
How to get the Page Inspector? I have tried Ctrl+Alt+F1, but it didn't work.
Click on top right corner where you have the ? symbol, then select Help and Support and then click on "Inspect pages and data" (bottom of the page).
Yeah Ok.. I did it..Now the updated code is-
report 50100 "Timesheet Details"
Caption = 'Timesheet';
DefaultLayout = Word;
WordLayout = 'timesheetdetails.docx';
RDLCLayout = 'timesheetdetails.rdlc';
UsageCategory = ReportsAndAnalysis;
ApplicationArea = All;
dataitem("Time Sheet Header"; "Time Sheet Header")
column(Starting_Date; "Starting Date")
column(Ending_Date; "Ending Date")
column(Resource_No_; "Resource No.")
column(Owner_User_ID; "Owner User ID")
column(Approver_User_ID; "Approver User ID")
column(Open_Exists; "Open Exists")
column(Submitted_Exists; "Submitted Exists")
column(Rejected_Exists; "Rejected Exists")
column(Approved_Exists; "Approved Exists")
column(Posted_Exists; "Posted Exists")
column(Posted_Quantity; "Posted Quantity")
column(Status_Filter; "Status Filter")
column(Job_No__Filter; "Job No. Filter")
column(Job_Task_No__Filter; "Job Task No. Filter")
column(Date_Filter; "Date Filter")
column(Posted_Filter; "Posted Filter")
column(Type_Filter; "Type Filter")
What to do next
Business Applications communities