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.
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.