In our project, we need to display a report on UI. There is one column whose value needs to be fetched from a pagelist conditionally. No 2 conditions are repeating. Also the report will be accessed by the end user once in a while.

One solution to implement such requirement is to use a node-level Data page to fetch the records using a report definition and then loop over individual records, open each record, match the condition that match with the pagelist and then display the appropriate record on screen. As of now there will be 4 pagelists for each record. this data page is then used in the UI to display the record and it's value.

There won't be too many records created. But gradually this can have a performance impact.    I just wanted to know if there is any other way this design can be improved. 

I have tried to mock up my requirement in an excel file. Attached is the screenshot.