Question

2
Replies
462
Views
Ashish Agrawal (Ashish Chase)
JPMC

JPMC
IN
Ashish Chase Member since 2016 16 posts
JPMC
Posted: March 2, 2017
Last activity: March 22, 2017
Posted: 2 Mar 2017 17:19 EST
Last activity: 22 Mar 2017 12:48 EDT
Closed
Solved

Issue with paramters passing to multile subreports from main report

Hi All,

Am facing a weird behavior in Pega 7.2.1

I have a main report, which has two subreports configured.

Both of these sub report accept parameter A, which is used in the where clause on that respective subreport.

So now say my Main report has Subreport1 and pass the param and also have subreport2 and pass param.

In the generated SQL, i see that the subreport1 inner join has the where clause set properly with the param, whereas the subreport2 , does not have the where clause itself.

note:In both subreports "Ignore filter conditions for the sub report in this report" is unchecked.

When i reverse the reports, says make my subreport2 as first subreport and subreport1 as second in main report, the similar behavior is observed. Now for subreport2 the where clause is fine but for subreport1 there is no where clause.

Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.