Question 1 Replies 404 Views × Close popover Janani Melnattamai Athmarao (Janani.M.A) VirtusaPolaris Associate Consultant VirtusaPolaris IN View Profile Send Message Janani.M.A Member since 2012 1 post VirtusaPolaris Posted: April 1, 2017 Last activity: April 4, 2017 Posted: 1 Apr 2017 4:39 EDT Last activity: 4 Apr 2017 5:22 EDT Closed How to include sub query in reports I want to know how to configure sub reports to implement the following query. select * from pr4_rule_vw where PZINSKEY in (select pxhistoryforreference from pr4_history_rule where pxtargetrulesetversion='03-01-01'); Reporting × Close popover Facebook Twitter Linkedin Email Copy Link Copied! Moderation Team has archived post, learn more × Close popover 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. Posted: 4 years ago Posted: 3 Apr 2017 17:07 EDT × Close popover Ron Lee (RonLee_GCS) PEGA Principal Software Solutions Engineer Pegasystems Inc. US View Profile Send Message RonLee_GCS PEGA replied to Janani.M.A Are you sure you need a SubReport? It doesn't look like you are displaying any columns from pr4_history_rule. You might be able to do this with a report in Data-Rule-Summary that does a class join with History-Rule, using the appropriate join conditions: .pzInsKey = HistoryRule.pxHistoryForReference AND HistoryRule.pxTargetRuleSetVersion = "03-01-01"