ROI.EXE

(0) Share

Report

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

All responses (2)

Answers (0)

Community Member on at

Like (0)

Report

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 1,246 on at

Like (0)

Report

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