web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Business Central forum

Creating report to display time sheet data

(0) ShareShare
ReportReport
Posted on by 700

Hi All,

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 -

report 50100 "Timesheet Details"
{
Caption = 'Timesheet';
DefaultLayout = Word;
WordLayout = 'timesheetdetails.docx';
RDLCLayout = 'timesheetdetails.rdlc';
UsageCategory = ReportsAndAnalysis;
ApplicationArea = All;

dataset
{
dataitem("My Time Sheets"; "My Time Sheets")
{
column(Time_Sheet_No_; "Time Sheet No.")
{

}
column(Start_Date; "Start Date")
{

}
column(End_Date; "End Date")
{

}
column(Comment; Comment)
{

}

}
}
}

Thanks in advance !

Categories:
I have the same question (0)
  • Dynamics 365 Business Central Profile Picture
    700 on at

    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;

       dataset

       {

           dataitem("Time Sheet Header"; "Time Sheet Header")

           {

               column(No_; "No.")

               {

               }

               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(Quantity; Quantity)

               {

               }

               column(Posted_Quantity; "Posted Quantity")

               {

               }

               column(Comment; Comment)

               {

               }

               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

  • Suggested answer
    Stefano Demiliani Profile Picture
    37,166 Most Valuable Professional on at

    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).

  • Dynamics 365 Business Central Profile Picture
    700 on at

    How to get the Page Inspector? I have tried Ctrl+Alt+F1, but it didn't work.

  • Suggested answer
    Stefano Demiliani Profile Picture
    37,166 Most Valuable Professional on at

    No. tables are named "Time Sheet Header" and "Time Sheet Line".

    You can check tables via Page Inspector.

  • Dynamics 365 Business Central Profile Picture
    700 on at

    TS.png

    This is the data I want to display. Am I correct with the name of source table ?

  • Suggested answer
    Stefano Demiliani Profile Picture
    37,166 Most Valuable Professional on at

    Is "My Time Sheets" your source table (where you have the data)?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans