.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

setup permission to view report

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :

Add new user to access the database.He tried to run standard report but doesn't have permission.He Right-click on the database CCTRACKS, click on Reports, click on Standard Reports, click on User Statistics.And he get the error:

Unable to retrieve data for this report. Following error occured.

Msg 297, level 16, State 1

The user does not have permission to perform this action.


How to fix it?

View Complete Post

More Related Resource Links

Looking for best setup to accomplish this task, need to generate report view for printing(edited)


We have some pages that are in gridviews and datalists.. one requirement for 2 of them is the ability to generate the results in a report view of sorts.. in other words, if you do a search and the results come back in one of the 2 gridviews or datalist, on screen its presented as it currently does.. just a gridview or datalist.. but i need to add a button that gives you the option to convert / generate the data in a report view so you can print it out and not be just a print out of the gridview..

I already offer the ability to export to excel format, but what they are wanting is to create it so if it needs to be presented to someone, they can print it out with the click of a button and it looks like a nice report.

Hope that makes sense... any suggestions would be great..

Just thinking to myself, could it be possible or would this be an option and if it can, how can it be incorporated to work correctly..

Build a template page that has a formal report layout.. then if you chose to print, then each record in the gridview loops thru the template and each record would print out on its own page..

Does that sound like it can be done? or am i just wishing it could be that simple??


// Added to above //

What i guess would be comparable to what im looking for is

Crystal Report Asking for Database Authentication each time when I view Page.


Whenever I open my Crystal Report page, I am taken to the Database Authentication page where I am asked for

User name
Data Name

each time.

Is there a way to avoid this and I save these authentication in my page once.

I am using VS2005, C#.

Any Help will be appriciated.


SharePoint permission to view draft pages



I would like to create a new permission in sharepoint 2007 where all the people having this permission should be able to view the draft pages but they should not have right to edit that page or publish that page

can any one please let me know how to create a new permission which has a right to view draft pages but not edit\publish the page.

THANKS in advance u can reach me on rajesh.batchu@hotmail.com

Need to install Report View Redistributables on the report server?

Hi there:   I've developed a webapps utilizing MS reporting service reports and it works fine on my local machine. When I promoted to production server, it failed . People say I need to install MS reportViewer redistributables on the report server.   1. What is this MS ReportView redistributables anyway??? I've already included ReportView control in my apps and can someone explain to me why I need to install on the report server?   2. If I can not install the redistributables on the report server as the client may refuse to install due to whatsoever reasons, it there anyway to get around?   3. For any winForms apps, do I need to install the redistributables on the report server?   thanks    Hui--Currently using Reporting Service 2000; Visual Studio .NET 2003; Visual Source Safe SSIS 2008 SSAS 2008, SVN --

How to get "Current Date" on SharePoint Designer for Invoice Ageing Data View Report??

Hi Experts, I would like to know how can i get/show "Current Date" in SharePoint Designer ?? Any good tutorial ? FYI, I need this "Current Date" for my Ageing Data View Report, Purpose To offset with "Invoice Receive Date" to get total days of payment payable for the invoice. Please assists, Thanks

Change "View Report" button style

Hi,    How can i change the style of button "View Report" ? I want to change the image.     Tks!    

How to set the permission of the View in list

I want to set the permission for the View of my list in SharePoint 2010. I want to restrict the user for view only not in the list. if the user is from some group say "Manager" the record should be displayed else not.

While trying to view a report in integrated mode i see an unsupported RPL stream error

Trying to deploy a report in integrated mode on MOSS 2007. SQL server version is 2008 R2. I see the following:   ??? ?????????? ? ????м???? ?? ??????? ????????? ??????. ?????????? ?????????????м?? ?????? ?????? RPL: 34.62.1836345404. ??????м?? ??????: 10.3.     Yes i know its in russian. Another fail of Microsoft not being able to see the error codes and strings in english language, makes finding solutions even harder, because first you must find HOW is this called in english, then look for solution. Okay so, i found out that it is actually transalted into: unsupported RPL stream version detected 34.62.1836345404 expected version 10.3 Now, everywhere around the webs they say that this is because my Add-in is out of date and i need new RS addin for MOSS 2007.  But the link is dead!    For example, here http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/61357765-52aa-4085-9ee0-4cb494a6c3ad   @For SQL 2008 R2 together with WSS 3.0 / MOSS 2007, you need the SQL server 2008 november CTP add in:  http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=44bda62c-0cda-4a99-8d0a-d7fe06b39422 But the link is dead and there is no hint as to what happened.   The only valid link i found is this: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=65606fdd-093f-4c

Permission Errors for Users on Home Page only of SQL Server Reporting Services Report Manager

I have spent days now investigating this problem, so any help very much appreciated! I have a remote web server 2003 running SQL Server R2 Express Edition with Reporting Services installed. I use Report Builder 3.0 locally to build report. If I login via Internet to Report Manager Web Page as an administrator I can perform all the expected and required actions, creating new folders and assigning permissions for users etc. I have added a new user "ReportUser" as a Browser of a child folder. If ReportUser longs on to home page, he receives the all too familiar error: User 'XXXXXXXX\reportuser' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed. However, if the user starts at the child folder of home page, and then logs in, he sees the expected page, and can run the report!  This is not very satisfactory. How can I allow user to see home page, without an error message, but not be allowed to click on any folders to which he is not entitled? I am now aware that SQL Server R2 Express Edition has many limitations compared with full Editions (fixed roles, cannot manage Report Service from Management Studio etc) , and many of the "solutions" offered on the web just do not apply.   John Walton

Unable to view report preview properly

Hi all, I am using local reports(rdlc) to generate reports. When i try to preview the report from URL,i am unable to view the preview properly. It is working fine in Local. I am able to view Report viewer control with out data(Actually i have records) Images like "First page,Previous page,next Page, Last page images with their names directly with "X" marks. What might be the problem.I am getting problem only in URL. I am getting java script error,Like "Hoverimagectl00-Reportviewer1_ctl01-ctl01...'is null or not an object" Any body help me, It is very urgent. Regards, Narendra

Capturing 'View Report' Button Event

My report contains 2 dropdown lists. The 2nd dropdown list will be populated based on the selection of the first. I need to call an insertion method that will insert the selected values of the dropdown lists into the database when the 'View Report' button is being clicked. Is there a way to capture the 'View Report' button's event? Thanks in advance. (By the way, I am using SSRS 2005.)

User does not have required permissions to view Report Manager on SQL 2008 r2

Hi all, We are installing SQL Server 2008 r2 onto a server, and this installation includes Reporting Services. SSRS works, I can deploy reports, use Report Manager, Report Builder, etc., all using my admin privs. The problem is when NON-ADMIN users connect to \\server\reports.  They get the following error: User 'DOMAIN\user' does not have required permissions.  Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed. This error is resolved by giving the DOMAIN\user account local admin privs on the server. Granting admin privs is not a solution.  We have accountants and other non-technical people that will use Report Manager and Report Builder.  We can't just give every person admin privs on the production SQL server. I have done a lot of research on the web... I see a results involving earlier versions of SQL Server and Report Manager, but this is 2008 r2 - different webserver, etc. How can I resolve this issue?

Report Builder 3.0 issue - can view existing rdl files but cannot create new reports

I have Report Builder 3.0 deployed on my local machine pointing to a remote SQL Server 2008 R2 instance outside of my local domain.  Within this local Report Builder 3.0 instance I am able to open up previously created rdl files from the remote SQL Server 2008 R2 instance that I am connecting to.  However, if I try to create a new report on my local instance of Report Builder 3.0 and attempt to use the same data source as was used to create these existing rdl files, I receive the error: "Unable to connect to data source. The user credentials provided in the connection string do not have permission to connect to Reporting Services."  So why can I open existing rdl files from this remote SQL Server 2008 R2 instance, but not create new ones even though I'm using the same data source as the existing rdl files?  Thanks, Mark

Adding a table or view multiple times when building a query with BI Report Designer and Report Build

How can I add a table/view multiple times to a single query by using BI Report Designer or Report Builder 3.0? In Report Designer I managed (workaround) to add one table multiple times by creating multiple Named Queries and having the same SELECT. Still I don't know how to add one table multiple times in Report Builder 3.0.

Report Viewer column width too small when viewing in IE 8, works in IE 8 compatibility view and Fire


IE 8 Version 8.0.7600.16385 64-Bit Edition
Report Viewer

The web page is just the report viewer control (see code below).  

When the report is rendered in Report Viewer   (IE 8), the width of the first column is much smaller than it should be. 
When the report is rendered in Report Manager (IE 8), the width of the first column is normal size.  
When the report is rendered in Report Viewer (Firefox or IE 7 compatibility view), the width of the first column is normal size.


<%@ Page Language="C#" AutoEventWireup="true" CodeFile="test.aspx.cs" Inherits="test" %>
<%@ Regi

Sql server Report manager- Need Navigation view for folder as like Left to the Folder i need a + sym


Sql server Report manager- Need Navigation view for folder as like Left to the Folder i need a + symbol and if i click okn + it should show all the folders and fils in the folder

+ Columbila

If i click the + symbol it should like below

- Columbia

      - Reports





Save a Personal View of Performance Point Services Report


Hi I am changing the view of my Performance Point Services report and want to save the same like it was possible in proclarity. I have been told that all features of Proclarity are there in Sharepoint Performance Point Services.

I  was able to find the decomposition chart but not the option of saving the modified view. Has this been removed,If yes can i use Object Model and write code for it.



ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend