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