Question
Coforge DPA private limited
AU
Last activity: 16 Mar 2017 12:30 EDT
how to incorporate multiple quries in a single report definition when output of all quries is in aggregate function
Hi, I have a requirement in which I need to get count of work items based on different condition by joining another table. so in short I will be having 3 different queries with 3 different filters and results is 3 Count(pyID) . I have created 3 different RD and things are working fine. But LSA is asking me to incorporate these things into one RD. I tried using Sub reports but that's not working as I am using aggregate function Count. Can anyone please suggest me how do I achieve that using RD.
***Moderator Edit: Vidyaranjan | Updated Categories***
Pegasystems Inc.
IN
Hi
Not sure if i understood your query correctly.
I believe the subreports should be used, when the query needs to be run on the table associated with the class, where the RD is present. If you want to retrieve the results from the other table, then you must go with joins.
Can you please post the screenshots of the configuration ? So that i can try by creating a sample use case from my end.
Updated: 14 Mar 2017 3:35 EDT
Coforge DPA private limited
AU
I actually wanted to task about trend reporting. if it is possible in RD like we do in RD.
Ernst & Young
US
Hey Madhusudan,
Don't know if you figured out the solution yet or not, if you can post your requirement or screen shots here may be we can help you out.