Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rcr69er
Constraint Violating Yak Guru
327 Posts |
Posted - 2007-11-14 : 05:57:40
|
| Hi I have just uploaded a report on to Report Manager. I can view it clearly on my pc, but when another person looks at it theor PC they get the following error:'An error has occurred during report processing. Query execution failed for data set 'UpcomingEvents'. For more information about this error navigate to the report server on the local server machine, or enable remote errors'Does anyone know what the problem could be?Thanks |
|
|
dirtydavey
Yak Posting Veteran
80 Posts |
Posted - 2007-11-14 : 06:20:59
|
| Have you both got the same you user rights, are you both admins? |
 |
|
|
rcr69er
Constraint Violating Yak Guru
327 Posts |
Posted - 2007-11-14 : 07:29:42
|
| I am the only one who is a admin |
 |
|
|
dirtydavey
Yak Posting Veteran
80 Posts |
Posted - 2007-11-14 : 08:32:08
|
| Ok, its sounds like a permissions thing, that the other user does not have the correct access to see the report. I would check what users have what rights on what reports. Make sure that the user or group she is in has at least read rights to the report. |
 |
|
|
rcr69er
Constraint Violating Yak Guru
327 Posts |
Posted - 2007-11-14 : 10:07:03
|
| I am using a stored procedure, would it work if I applied a Grant to Public Statement on the stored procedure? |
 |
|
|
dirtydavey
Yak Posting Veteran
80 Posts |
Posted - 2007-11-14 : 10:11:42
|
| most likly, but you need to find out what users need what rights. |
 |
|
|
|
|
|