Question
1
Replies
404
Views
VirtusaPolaris
Posted: April 1, 2017
Last activity: April 4, 2017
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');
Moderation Team has archived post,
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.
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"