Lock Table based on primary key- Problem in executing report

Hi Experts

In my report we have Personnel no. [pernr-field1] and start work date [field2] on selection screen and both are mandatory.

When one user executes the report with pernr for example as 7 on sel. screen we look the table to update entries.

But if other user at the same time wants to run the report for 1-8 pernr in range he gets a error message that table is locked

this happens because pernr 7 is already locked.

Can anyone suggest how can we avoid this situation ? So that user1 can execute the report for pernr 7

and user2 can execute the report for pernr 1-8

Please share your inputs.