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

Announcements

Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / ROI.EXE
Microsoft Dynamics SL (Archived)

ROI.EXE

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Ajit Kannan Profile Picture
    Ajit Kannan 1,246 on at

    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

  • Community Member Profile Picture
    Community Member on at

    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.

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June 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