Process Report - Data going blank when sorted descending

Question

Hello , 
 
 I have a process report which have 5 fields , out of which one of the field is populated using an E.R and others from p.v . Initially the report is sorted by id field ascending in that scenario i get all the data as expected . But when i sort the same id field in descending order , the field which is populated using an E.R is turning blank (Also not all values but only a few for this field). 
 When i try to search by that id then also the same case . 
 Any suggestion ? What might be the issue ? 
 
 Thanks, 
 Rohit Ovhal

Carlos Santander · Answer

The report is likely timing out . Try converting those report variables into process variables . I suggest you read the entire article, as it provides a lot of details about process reports.