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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / ROI.exe - Accessing di...
Microsoft Dynamics SL (Archived)

ROI.exe - Accessing directly from VB.NET code

(0) ShareShare
ReportReport
Posted on by Mike Sadowski 234

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

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

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

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans