Google
 

Monday, July 28, 2008

Peter Eb. : HOWTO: Make 1 filter control more than 1 matrix

 

A common request by form authors is to create a "start here" worksheet page where contributors can change some global filters. Then they advance to other worksheets in the workbook to do their actual data entry. Other times authors just want to link multiple matrices so that changing the filter on matrix A also changes matrix B at the same time. The way RDL is structured makes it natural for PPS to also define all filters as global filters: the add-in stores them naturally as ReportParameters in RDL which are global. Then each matrix is subscribed to the filter.

Peter Eb. : HOWTO: Make 1 filter control more than 1 matrix

No comments: