Multiple users access to reports.

[ecpmII]

Any help on this is appreciated.

 

We are having problems with two or more users being in the report module at the same time.

 

Example: User 1 goes in to print a report, user 2 cannot access the report module.

User 2 gets the error "John Downs is modifying this record. You cannot use it until John Downs is finished."

 

The report is set up as follows:

Each report has a layout that ask for date ranges (start to end) and department ranges (i.e. Biology to History).

The user then click a button that has script attached that Enter Find Mode, Insert Calculated the date ranges and department ranges, Performs the Find, etc.

 

The reports works fine, but only one user can run a report at a time. The reports are using the Master Student database (all using same database with some data coming from related files).

The date and department ranges on the layouts are global fields.

 

What do we need to do, to allow the users to run reports (different or same reports) at the same time?

 

Thanks.

[Robert Schaub]

Originally posted by ecpmII:

[qb]Any help on this is appreciated.

 

We are having problems with two or more users being in the report module at the same time.

 

The report is set up as follows:

Each report has a layout that ask for date ranges (start to end) and department ranges (i.e. Biology to History).

The user then click a button that has script attached that Enter Find Mode, Insert Calculated the date ranges and department ranges, Performs the Find, etc.

.[/qb]

Try adding after the find or print statement

 

Exit Record Request

 

This will boot the current user out of any fields and will make it look like they are not modiifing the record.