Showing posts with label published. Show all posts
Showing posts with label published. Show all posts

Friday, March 30, 2012

report does not show a table

Hi,

We have a report published to two report servers ( same configuration). this report displays data in two side by side tables. on server 1, the left side table does not get displayed where as both the tables show fine on server 2.

What could be the reason for this

Any help greatly appreciated.

Thanks,

Phani

I assume that the reports are pointing to different databases, so is there any data being returned for the table that doesn't show?|||

Hi,

It is the same report deployed on two webservers so they pull from the same database. One report shows both the tables with data and the second one shows only the right side table with data and does not show left hand side table.

Thanks,

Phani

|||

are the two tables using the same datasource?

could it be a time out issue from sql?

Have you looked into the reportserver log files and compared the results from each report server?

sql

Friday, March 9, 2012

Report Builder (rsaccessdenied) error message

Hi,

I have created a Report Model and published it on our QA environment Report Server(Where I dont have admin access). When I try to launch the Report Builder tool and create a sample report and Run the report it gives me this error. "The permissions granted to user 'Domainname/user group' are insufficient for performing this operation. (rsAccessDenied)" I checked with the Admins on this server the usergroup has a "Browser" Role. I had read on some online fourm that if user group has browser role it should work. But I cant get it work any help is appreciated.

I have published the same Report Model in Deveploment environment report server(where I have admin access) and when I do the same thing I am able to run the reports.

Some one please help me its causing delay in our testing.

Thanks

Ashwini

I think you need the report builder role. Not just browser, that is not enough permission.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=573815&SiteID=1

|||

Thank you!! I will let the Admin know about this and ask them include the Report Builder Role and will try again and see if it works.

|||

Ok we tried giving the role Report Builder to the user and Report Builder Role has these tasks assosicated - Consume Reports,Manage Individual Subscriptions,View Folders,View Models,View reports,View resources. Even after giving this role it did not work. So we even selected all the tasks under Report Builder Role just for testing this did not work either.

Here is the exact scenario: when I get the error message it says this user's "IHS-T-CRRSWQ-01\IUSR_WFS-4376A9A5D75" permission granted is insufficient this user is the one which is running on IIS. But this is one of the user under user group "NT AUTHORITY\Authenticated Users" which has Report Builder Role. I am really getting into circels here any help appreciated.

Thanks!!

|||

Please post the exact error message.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Error Message:

"The permissions granted to user ' Username' are insufficient for performing this operation. (rsAccessDenied)"

Thanks

Ashwini

|||Please, if someone has a solution, i've the same problem.

Report Builder (rsaccessdenied) error message

Hi,

I have created a Report Model and published it on our QA environment Report Server(Where I dont have admin access). When I try to launch the Report Builder tool and create a sample report and Run the report it gives me this error. "The permissions granted to user 'Domainname/user group' are insufficient for performing this operation. (rsAccessDenied)" I checked with the Admins on this server the usergroup has a "Browser" Role. I had read on some online fourm that if user group has browser role it should work. But I cant get it work any help is appreciated.

I have published the same Report Model in Deveploment environment report server(where I have admin access) and when I do the same thing I am able to run the reports.

Some one please help me its causing delay in our testing.

Thanks

Ashwini

I think you need the report builder role. Not just browser, that is not enough permission.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=573815&SiteID=1

|||

Thank you!! I will let the Admin know about this and ask them include the Report Builder Role and will try again and see if it works.

|||

Ok we tried giving the role Report Builder to the user and Report Builder Role has these tasks assosicated - Consume Reports,Manage Individual Subscriptions,View Folders,View Models,View reports,View resources. Even after giving this role it did not work. So we even selected all the tasks under Report Builder Role just for testing this did not work either.

Here is the exact scenario: when I get the error message it says this user's "IHS-T-CRRSWQ-01\IUSR_WFS-4376A9A5D75" permission granted is insufficient this user is the one which is running on IIS. But this is one of the user under user group "NT AUTHORITY\Authenticated Users" which has Report Builder Role. I am really getting into circels here any help appreciated.

Thanks!!

|||

Please post the exact error message.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Error Message:

"The permissions granted to user ' Username' are insufficient for performing this operation. (rsAccessDenied)"

Thanks

Ashwini

|||Please, if someone has a solution, i've the same problem.

Report Builder - unable to open report sample

I have deployed the AdventureWorks report model to the report server and published the sample reports (RDLs - Customer Purchases, Product Sales by Year, and Sales by Territory). When I attempt to open the RDL in Report Builder, I unable to open the report and the following error is reported "This report cannot be opened in Report Builder." Any ideas?

Clay BOnly reports that were authored in Report Builder can be opened in Report Builder. All of the sample reports were authored in Report Designer, not Report Builder.

Report Builder - unable to open report sample

I have deployed the AdventureWorks report model to the report server and published the sample reports (RDLs - Customer Purchases, Product Sales by Year, and Sales by Territory). When I attempt to open the RDL in Report Builder, I unable to open the report and the following error is reported "This report cannot be opened in Report Builder." Any ideas?

Clay BOnly reports that were authored in Report Builder can be opened in Report Builder. All of the sample reports were authored in Report Designer, not Report Builder.