cannot create work file

[Dan_Montanari_(Guest)]

I am getting an error box from R&R SQL Report Viewer that says____Cannot create work file____I have been unsuccessful in troubleshooting the problem.____Thank you

[kfleming]

Does the error specifically say work file?____Kathleen__R&R Support

[Dan_Montanari_(Guest)]

yes, the error is exactly "cannot create work file"____Thank you

[kfleming]

Are you using a SQL control table or are you just double click executing RSWRUN.EXE?________Kathleen__R&R Support

[Dan_Montanari_(Guest)]

We are using the SQL Control table.

[kfleming]

When you use a SQL control table, R&R reads the data from the table and then pops it into a set of temp files that get written to the TEMP folder than is defined in the Windows environment.____So it sounds like something is preventing these temp files from being created. Try checking on where the TEMP is set to make sure that it is a valid location with permission and space available.____Kathleen__R&R Support

[Dan_Montanari_(Guest)]

Is it possible to redirect the temporary files with an entry in the RRW.ini file??____We are using the runtime environment on a multiuser (terminal services) server. I do not wish to modify the TEMP location for the system but do have a permissions problem with the default windows settings. It would be best for us if the .RRJ files could be written to a different directory than the TEMP environment variable.____Thank you