Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Suggested answer

ROI.exe - Accessing directly from VB.NET code

Posted on by 230

Hello,

I have built custom applications on top of Dynamics SL using VB.NET code and I need to run an SL report directly from the application.  Is it possible to directly call ROI.exe passing the required parameters to run an SL report from my application?  Meaning not using the SL  SDK or a customization with ROI.exe.  Thanks.

Mike

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: ROI.exe - Accessing directly from VB.NET code

    Hi Mike,

    Yes, it is possible to add the following References to your project and drag crystal ReportViewer control in your form:

    Please include,

    CrystalDecisions.CrystalReports.Engine

    CrystalDecisions.Shared

    You must declare the following variable in which event call you want to load the crystal report :

    Dim Rpt as ReportDocument

    Rpt.Load("xxx.rpt")

    CrystalReportViewer1.ReportSource = Rpt

    CrystalReportViewer1.Refresh()

    Please provide your DB connection information under the Load statement 

    Please let me know, how it goes.

    Thanks,

    Srikanth S

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: ROI.exe - Accessing directly from VB.NET code

    \\ServerNameGoesHere\solomon\"Solomon IV"\roi.exe 4 4 03630/run 'POSITIVEPAY' /template

     

    This is an example of a command line option to run a custom Crystal report (Positive Pay) in SL. The report template “PositivePay” selects the correct report format for report 03630 and the file output routing. The command is run by a logged in SL user.  I had the command set to run on a schedule that was managed outside of SL, with additional file handling done in the CMD file that called ROI to run the report.

    You might be able to do use similar commands as documented in the “Launch” command in the CustomizationMgrReferenceVBA.pdf user guide.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans