Thank you each one of you for suggestions. after brainstorming reg the requirement, it is understood that complete separation of reports download vs viewing, rpd data source(all three layers) and using the row limits in the one of the data source where is download is enabled and no row limit on the view only data source…