ROI.exe - Accessing directly from VB.NET code

(0) Share

Report

Posted on by Mike Sadowski

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

*This post is locked for comments

All responses (2)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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.