Question3Replies77Views JohnPaulRaja,C Member since 2011 247 posts Cognizant Posted: May 5, 2017Last activity: May 18, 2017 Closed Looking optimized design for dashboard reportingIt is the scenarioWe are pulling data from 4 different tables A,B,C , and DWe are having four different roles (W, X,Y, and Z) for the dashboardIf you see below design, four Report definition and repeating grid are used.How to optimize below design to have only one Report definition and repeating grid?Role W <- Repeating Grid <– Report Definition <- Class ARole X <- Repeating Grid< – Report Definition <- Class BRole Y <- Repeating Grid <– Report Definition < - Class CRole Z <- Repeating Grid <– Report Definition <- Class D***Updated by moderator: Lochan to update Categories*** Low-Code App Development Reporting ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post 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. Posted: 3 years agoRonLee_GCS PEGA replied to JohnPaulRaja,CHi John, Can you please provide more detail about the relationship between the 4 classes/tables A, B, C and D? Are they all descendants of the same class? Are any of them descendants of the other classes? Posted: 3 years agoJohnPaulRaja,C Cognizant replied to RonLee_GCSHi Ron, All are independent classes, connecting with external database tables Posted: 3 years agoRonLee_GCS PEGA replied to JohnPaulRaja,CIf these are all independent classes loading from separate tables, the only way I can think of to use a single report definition is to define 4 separate sub-reports, and filter accordingly in the main report.