Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
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 and Operations TechTalks | Customer Engagement TechTalks | Talent 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