Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Thomas Lorriette (ThomasL8) Senior System Architect
Iriz Consulting
FR
ThomasL8 Member since 2016 17 posts
Posted: Jun 12, 2017
Last activity: Jun 15, 2017
Posted: 12 Jun 2017 12:03 EDT
Last activity: 15 Jun 2017 3:58 EDT
Closed

Include Aggregation with 0 count in report definition?

Hello,

I'm using a basic report definition which, for each ID of a class A, gives me the number of a instances in a class B using this ID in a row. I'm using a class join.

Using an aggregation and a COUNT, the report works, but it only shows the IDs of my class A and the number of class B instances using it when there is at least one element returned by the count function.

My question is: is it possible to include the instances of class A whose ID is not used by any instance of class B? Basically, the instances of class A with "0" as count?

Thanks in advance.

To see attachments, please log in.
Reporting

Posted: 7 years ago
Posted: 15 Jun 2017 2:41 EDT
Pradeep Kumar Rathod Nenavath (nenap)
PEGA
Technical Solutions Engineer
Pegasystems Inc.
IN

Hi Thomas,

Create a sub-report for class B. 

 In the main report's data access tab configure the sub-report using "Do not match rows" join condition .

In main report you can just display the required rows.

 

Thanks ,

Pradeep.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice