Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / ROI.EXE
Microsoft Dynamics SL (Archived)

ROI.EXE

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I have developed an SL screen using the SDK where I want that screen to then launch a crystal report through ROI but I need to pass a parameter value to the report to be used as part of a select criteria.  So, my screen has a print button which uses CallApplicWait to launch ROI passing a couple of parameters (one being the ROI report ID followed by the /RUN parameter and the second parameter being the filter value (a calendar year) with PRMSEP value between the two parameters.  This successfully launches the report but I have been unable to figure out how to pick up the second parameter of the ROI call within the Crystal Report definition so it can be used as a filter.  There does seem to be a U2lsol4 function for this purpose.  If anyone knows how the Crystal Report formula should be defined to pick up this second parameter it would be most appreciated.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: ROI.EXE

    Ajit,

    Thanks for the response.  What you provided was how to pass parameters from the program code to ROI including things like wanting to do a print preview.  This part I already knew.  What I was looking for was how to retrieve a passed parameter from the Crystal Report side.  In my case, the front-end screen has a field for the calendar year that I want to pass to the report and have Crystal Report then use that passed calendar year as a filter to limit the report to that year.

  • Ajit Kannan Profile Picture
    Ajit Kannan 1,240 on at
    RE: ROI.EXE

    Hi Rick,

    Below are the sample code to pass the multi parameters 

    Dim ParmStr As String

            ParmStr = "XXXXXX/RUN" & PRMSEP

            ParmStr = ParmStr & "XXXXXX/FORMAT" & PRMSEP

            ParmStr = ParmStr & " {TableName.Project} = " & SParm(Buffervalue.project) & " and {TableName.pjt_entity} = " & SParm(Buffervalue.pjt_entity) & "/WHERE" & PRMSEP

            ParmStr = ParmStr & "/PSCRN"

            Call CallApplicWait("ROI", ParmStr)

    Thanks,

    Ajit Kannan  SR

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans