Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Report table data

Posted on by 105
Hi
 
For the below report, please could you review and advise which tables are being used to produce the report? We want to create something new in our dashboards and this report currently holds a lot of the data we want
 
Knowing where the data is coming from so we can see if we can gain access to them
 
  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 14,611 User Group Leader on at
    Report table data
    Hi Shaikh,
     
    It's a custom report build by your partner Robosol.
     
    If you have access to source code / source control you can check data items in report as shown below.
     
    This will list down all tables used for reports. 
     
     
    Regards,
    Saurav Dhyani
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 7,256 Super User on at
    Report table data
    As far as I know this is not an out of the box report in Business Central, or at least its not in the NA localization. If its a custom report you can simply ask your developer/partner that created the report for the tables used in the data set. 
     
  • Shaikh Zuber Profile Picture
    Shaikh Zuber 105 on at
    Report table data
    Hi Saurav sir,
     
    Can you please check the below screenshot.
     
  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 14,611 User Group Leader on at
    Report table data
    Hi Shaikh,
     
    Which localization you are using?
    Is this report from standard Microsoft Extension or ISV apps that you are using?
     
    Click on report and when request page is opened, Then Open Page Inspecting to Check Report No. (shortcut - Ctrl+Alt+F1)
     
     
    Then open Report Layouts page, filter page for report ID to check report from which extension.
     
     
    If report if from Microsoft extension, you can get source code in the Product DVD.
     
    If its product third part apps (ISV) then you may or may not be able to see the report source code.
     
    If it's from your PTE extension, then you should have code for the report dataset.
     
    Regards,
    Saurav Dhyani
     
     

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans