Logo 
Search:

MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Passing parameters to report using URL in SSRS 2005 (MOSS 2007)

  Asked By: Judson    Date: Feb 10    Category: MOSS    Views: 2439

I have a question regarding SSRS 2005 and MOSS 2007. I want to pass parameter for report using URL. I have come across lot of information related to it

This post suggest a solution:

www.beyeblogs.com/.../passing_paramet.php

It says instead of using following link:

https://www.myMOSSServer.com/.../07

Using this: https://www.myRSServer.com/ReportServer?https://www.myMOSSServer.com/.../07

Solves the problem.

When I tried it, I got an error :


The type Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c does not implement IReportViewerMessages or could not be found
I used this link to take care of error:

insomniacgeek.com/.../

This nasty error message appeared when I published my Reporting Services local report to a custom Web Part.

"I solved this be comment out the ReportViewerMessages line in appSettings section in the web.config

<appSettings>
<!-- <add key="ReportViewerMessages" value="Microsoft.SharePoint.Portal.Analytics...... /> -->

So far, I haven't seen any issues by commenting out this entry. "

Now, I can see the report but only when using Admin login. When I use a less-privileged account, I get an error :

The permissions granted to user 'ServerName\UserName' are insufficient for performing this operation. (rsAccessDenied)

As I understand It is to say to access report, person needs to have access to report server. Has any body encountered same problem?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Dhanraj Saxsena     Answered On: Feb 10

How did you grant access to report  server items and operations?

From your post, you can access the reports properties with administrator privileges. If you assign permission to a folder level and add content manager to a domain account and you get the error when you using that account to go to reports property.

Try to assign some permission from the root level and then check the effect.

For more information about managing Permissions and Security for Reporting Services, please refer to the following article:
Managing Permissions and Security for Reporting Services
http://msdn.microsoft.com/en-us/library/ms156014(SQL.90).aspx

 

Related Topics:



Tagged:                

 

Related Post