Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / how to run SSRS Report...
Microsoft Dynamics AX (Archived)

how to run SSRS Report on local machine

(0) ShareShare
ReportReport
Posted on by munsif 1,534

hi experts,i have a basic question for all, i want to run ssrs report on local machine.. i have installed ax on my local system(laptop) with domain user. If i disconnect from domain server so the reporting generate issue "The system cannot contact a domain controller to service the authentication request. Please try again later"..


ok, its mean domain will necessary for Ax reporting,understood...but if so,then how ax run without domain...i mean how it wil open and allow me other action like Creation of P/O,s/o etc,,but when i come to view PO it give me the above mentioned error..so please guide me ..

Regards....

 

*This post is locked for comments

  • Suggested answer
    Faqruddin Profile Picture
    Faqruddin 1,869 on at
    RE: how to run SSRS Report on local machine

    As per my knowledge for any reports deployment Sql Server Reporting Services must be running on AX service account. This service account act as mediator between your AOS and SQL database and other Sql services. So once you disconnect cable from your PC/Laptop while working on AX you never get any error except reporting error and the buffer will help you to work on ax. Now close your AX and restart your pc and try to open AX you will get an error message Communication error "the server is unavailable". So basic requirement is system must joined the domain and all the services related to AX must be work on same service account..

  • Suggested answer
    Mohamed Asarafali Profile Picture
    Mohamed Asarafali 445 on at
    RE: how to run SSRS Report on local machine

    Dear Munisf,

    I hope the reply was bit late, I faced the same issue.. you need to connect the domain controller and full CIL and redeploy the reports, refresh the wcf configuration and run report. after that you can disconnect the domain which will run fine.

  • ColdIce Profile Picture
    ColdIce 110 on at
    RE: how to run SSRS Report on local machine

    Hi Munsif,

    Did you get any solution on your problem? I am facing the same issue and would like to know more about it.

    Thanks

    Shoaib

  • munsif Profile Picture
    munsif 1,534 on at
    RE: how to run SSRS Report on local machine

    then how it can be solved ...boss.

  • Ali Zaidi Profile Picture
    Ali Zaidi 4,657 on at
    RE: how to run SSRS Report on local machine

    I think Munsif, that your laptop is part of domain. and when you come out form Domain for example left office and use laptop at home. that is problem when you installed client and AOS server on same machine. Ax still working, but Reports did not run while outside of domain.

  • munsif Profile Picture
    munsif 1,534 on at
    RE: how to run SSRS Report on local machine

    i want to implement it in ax 2012 R3

  • munsif Profile Picture
    munsif 1,534 on at
    RE: how to run SSRS Report on local machine

    Thanks Deepak for kind and valuable response, now i want to implement a scenario in which mischarges against third-party(not customer/vendor) i.e sales tax charges,frieght charges,daweeo,clearence charges show on purchpackingslip report,Although it is implmented in ax 2009, i copied the same code of ax 2009 into ax 2012 R3,but not working and show 0 charges...so how it can be done...i am sending the ax 2009 code for mischarges......

    -----------***********************************------------------------------

    / this code for mischarges displaying on purchpacking slip report/

    Display str MiscChargesValues()

    {

    MarkUpTrans markupTrans;

    PurchLine purchLine;

    VendPackingSlipTrans tempVPST;

    str res;

    ;

    While Select SUM(Value) from markupTrans

    join purchLine

    join tempVPST

    Group by markupTrans.MarkupCode

    Where markupTrans.TransRecId == purchLine.RecId

    && markupTrans.TransTableId == purchLine.TableId

    && tempVPST.InventTransId == purchLine.InventTransId

    && tempVPST.PackingSlipId == VendPackingSlipJour.PackingSlipId

    && tempVPST.purchId == VendPackingSlipJour.purchId

    {

       res += "\n" + strfmt("%1", markupTrans.Value);

       totalCharges += markupTrans.Value;

    }

    return substr(res,2,strlen(res));

    }

  • Suggested answer
    Deepak Agarwal Profile Picture
    Deepak Agarwal 148 on at
    RE: how to run SSRS Report on local machine

    Hi Rehman,

    Yes, you can access AX from outside domain as well, but to run any report you must be in That domain. For more details please check event viewer. For first time use we need to deployed that report and without domain network system will not allowed you to deploy any report on server.

    I hope this will help.

  • munsif Profile Picture
    munsif 1,534 on at
    RE: how to run SSRS Report on local machine

    boss thanks for your kind response..currently i am disconnected from doamin,and then i open ax,so it run perfectly...no error regarding domain..but when i want to view any report,so domain error arise....i can't understand what happning..

  • Martin Dráb Profile Picture
    Martin Dráb 230,198 Most Valuable Professional on at
    RE: how to run SSRS Report on local machine

    I'm not sure what you're doing.

    Active Directory is mandatory for Dynamics AX. If AX can't authenticate a user, it mustn't allow access for him. Nevertheless if you need a local test environment or something, permanent connection to the domain controller clearly isn't necessary - the Demo VM from Microsoft is a proof.

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans