D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Reach to query of a report

  • 1.  Reach to query of a report

    Posted 16 days ago

    As a developer point of view, how can I check the logic and query of a standard report. While clicking on the menu item, it opens a filteration criteria form. There I right click -> Form Information -> Form Name and check the form, it's shows standard "SysOperationTemplateForm".

    How can I trail and reach till the report query and rpt file ?



    ------------------------------
    Hassan
    Arla Foods - Saudi Arabia
    ------------------------------


  • 2.  RE: Reach to query of a report

    SILVER CONTRIBUTOR
    Posted 16 days ago
    Hi,

    Could you please provide some more details like the report name you are looking for such that we can help you better. Also, please check the menuItem properties(like object and ObjectType) in Visual Studio.

    ------------------------------
    Regards,
    Chaitanya Golla
    Lead Architect
    ------------------------------



  • 3.  RE: Reach to query of a report

    Posted 16 days ago
    Suppose, I am trying to dig into the ​"Accounts Payable -> Inquireis and Reports -> Invoice -> Accrued Purchases excluding sales tax report" report's query.

    In visual studio, how can I know which menuitem for that report ?

    ------------------------------
    Hassan R
    Arla Foods - Saudi Arabia
    ------------------------------



  • 4.  RE: Reach to query of a report

    SILVER CONTRIBUTOR
    Posted 16 days ago
    Hi,

    Query name is VendAccruedPurchases. Please check the class VendAccruedPurchasesDP to know the underneath business logic.

    ------------------------------
    Regards,
    Chaitanya Golla
    Lead Architect
    ------------------------------



  • 5.  RE: Reach to query of a report

    Posted 16 days ago
    Thanks for your help.
    But how I can know this class & query name myself ? I cannot post a thread here for each and every report. I want the way to know it.

    ------------------------------
    Hassan R
    Arla Foods - Saudi Arabia
    ------------------------------



  • 6.  RE: Reach to query of a report

    SILVER CONTRIBUTOR
    Posted 15 days ago
    Hi,

    Please get familiar with the SSRS report architecture, as I mentioned above please check the properties of output menuitem of the report which provides the required details. DP class reveals the query and contract class used to generate the report. If you find any difficulty with other reports you can post your question as we are here to provide possible help.

    Refer below links:
    (How to Create SSRS Report in D365 )
    https://dhruvrthakar.blogspot.com/2018/07/how-to-create-ssrs-report-in-d365.html

    (SSRS Report development in Microsoft Dynamics 365 FO)
    https://www.axpulse.com/2018/07/16/ssrs-report-development-in-microsoft-dynamics-365-fo/


    ------------------------------
    Regards,
    Chaitanya Golla
    Lead Architect
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role