.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

Error showing subreport... due to user access?

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :Sql Server

I am experiencing a strang issue in SSRS 2005.

a) I have a MainReport that contains a SubReport and I deploy these up into Report Manager into a folder called MyFolder.

b) MyFolder has restricted access so only I can access it via ReportManager.

c) I ceate a linked report for each report: LinkedMainReport and LinkedSubReport and move these linked reports into a folder called YourFolder.

d) YourFolder is restricted to a Windows AD group... called ManagerGroup.

e) Report Manager folder structure now looks like this:

MyFolder (my access only)
- MainReport (original report)
- SubReport (original report.. and set to be hidden)

YourFolder (ManagerGroup and my access)
- LinkedMainReport
- LinkedSubReport (set to be hidden)

f) Security from the folders is applied to each report and link report by default.

g) ManagerGroup contains say 3 users: Homer, Lisa and Bart.

Homer and Bart can run the report "YourFolder -> LinkedMainReport" without any problems.  The main report and subreport embedded within it run fine.  The problem I have is when Lisa runs the same report "YourFolder -> LinkedMainReport" she sees the main report but gets the "Error showing subreport" message where the subreport is usually display

View Complete Post

More Related Resource Links

Showing Designer error for Silverlight App when trying to access resource which contains code e.Resu

Environment is: Silverlight 4, VS Studio 2010. Designer is showing error in a Silverlight App when trying to access a resource as below. And there are no build or runtime errors. Extensive research found that, in the "InvestorsProvider" class I am using wcf services, which has a callback method. In the call back method I am using this statement "this.MyProperty = e.Result" where e.Result is ObservableCollection. If I remove the e.Result it is not showing any designer problem. <UserControl.Resources> <local:InvestorsProvider x:Name="investorsProvider"></local:InvestorsProvider> </UserControl.Resources> Here is the error System.Reflection.TargetInvocationException [Async_ExceptionOccurred]Arguments: Debugging resource strings are unavailable. Often the key and arguments provide sufficient information to diagnose the problem. See http://go.microsoft.com/fwlink/?linkid=106663&Version=4.0.50401.0&File=System.dll&Key=Async_ExceptionOccurred at System.ComponentModel.AsyncCompletedEventArgs.RaiseExceptionIfNecessary() at SilverlightApplication9.ServiceReference1.GetInvestorsCompletedEventArgs.get_Result() in C:\Documents and Settings\mennis\my documents\visual studio 2010\Projects\SilverlightApplication9\SilverlightApplication9\Service References\ServiceReference1\Reference.cs:line 115 at SilverlightApplication9.Inves

Error while trying to access User Profile Service

Hi, I'm tryiong to setup UPA service but having some issues after running the UPA service.UPA service appears running, but clicking on the link in Central Administration does not take me to the Service Configuration page. Instead Central Admin flashes unknown error. Error log shows error message similar to the following o    User Profile Application Proxy failed to retrieve partitions from User Profile Application: Microsoft.Office.Server.UserProfiles.UserProfileApplicationNotAvailableException: No User Profile Application available to service the request. Contact your farm administrator.     at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.get_ApplicationProperties()     at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.get_PartitionIDs()     at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.IsAvailable(SPServiceContext serviceContext)                34e709d0-90b0-4419-afd0-44aff54ac385 We have a central admin server and two WFE servers. User Profile Application is created on the application pool in central admin server and the Instance (only instance) runs on the Central Admin Server. If anyone has faced the same issue kindly revert back to me. Regards, A

Login failed for user:Token-based server access validation failed with an infrastructure error


I would appreciate help with the following issue:


I have created a local group in our SQL 2008 server and added two Windows user accounts "DOMAIN\UserName"  I  then added the local group to the database and granted read only access.


The users are trying to link tables using MS Access using and ODBC connection and getting the following error.

Users are not system administrators.


Date                      6/30/2010 1:01:54 PM

Log                         SQ

Access Denied error when attaching VS2008 workflow debugger to 64-bit IIS if VS2008 user differs fro

I am trying to attach VS2008 to debug a workflow hosted in IIS (using the workflow debugger option so I can step through the visual workflow designer breakpoints, not the managed code debugger).  It is actually a WF 3.5 WCF workflow service hosted in IIS but I don't think that is the issue.  When I attach from VS2008 I always get the error "Unable to attach to process.  Access is denied."

I can attach for managed code debugging no problem.  Also, if I configure the IIS worker process app pool to use the same account as the account I am running VS2008 under I can attach not problem and debug using the workflow debugger.

So my remaining problem is that I would like to be able to attach while running VS2008 as my normal user account and leave the w3wp.exe app pool running as the usual networkservice account so that my debugging represents how the w3wp.exe will act in production.  I'm on Vista SP1 64-bit with .Net 3.5 SP1 and VS2008 SP1. 

Q: Is there a special privilege I can grant the worker process account so that I can debug while using a different user account?

I saw a very old post here http://blogs.msdn.com/sonalic/archive/2006/05/10/594703.aspx that hinted there is something special for 64-bit.  Does anyone know if there is something special about 64-bi

User control showing error


I'm using an user control named as QuickQuote.ascx . Inside it, I have defined some property like BusinessName, StateName etc. For reference I'm showing one property.

         int _BusinessName;
        public int BusinessName
                return _BusinessName;
                _BusinessName = value;


I've registered this user control as follows (so that no need to register again & again in all aspx pages where that user control is used).


create user wizard login error message dont show in a message box?




i am using create user wizard and capturing other information within content template when a new user

registers. Some of the textboxes are binded to required field validators.


there is a validation control on the page and ShowMessage box is True.

If they dont complete some of the text boxes then the message box pops Up with the error message.

It does not however include information errors like "User already exists" or Email address already exists

from the create user wizard membership  UserName and Password Textboxes


is it possilbe to hook all of these up so I get one message box with all errors including membership ones?




"Type ASP.x is not defined" error for dynamic user control when publishing updateable


I have a user control (ContainerCtrl) which programmatically instantiates another user control (SimpleCtrl) in OnLoad. It builds and runs fine, but when I publish it I get the error "error BC30002: Type 'ASP.SimpleCtrl' is not defined." (If I publish without the "updateable" option there's no error, but I need the site to be updateable.)

I assume this has to do with the particulars of how the assembly(ies) are built for the different compiler options. My question is, how can I get it to work properly for "updateable" publishing?

VS 2008 / .NET 3.5 sp1

The code follows (web.config is the default from Visual Studio).

Many thanks, Dave


<%@ Control Language="VB" ClassName="SimpleCtrl" CodeFile="SimpleCtrl.ascx.vb" Inherits="_SimpleCtrl" %>

    Simple control


Partial Class _SimpleCtrl
    Inherits UserControl

    'Nothing to see here.

End Class


<%@ Control Language="VB" CodeFile="ContainerCtrl.ascx.vb" Inherits="_ContainerCtrl"

Error on Display user's fullname using Active Directory in asp.net using vb.net



wi As System.Security.Principal.WindowsIdentity =  _System.Security.Principal.WindowsIdentity.GetCurrent()



Dim a As String() = HttpContext.Current.User.

Showing filtered Records in Crystal Report as per User Requirement


ReportDocument reportDocument = new ReportDocument();
    ParameterField paramField = new ParameterField();
    ParameterFields paramFields = new ParameterFields();
    ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
    protected void Page_Load(object sender, EventArgs e)
        if (!IsPostBack)
            paramField.Name = "@Ext";
            //*Remember to reconstruct the paramDiscreteValue and paramField objects
            paramDiscreteValue.Value = 44854
            CrystalReportViewer1.ParameterFieldInfo = paramFields;

Visual Web Dev 2010 error or new user error?


In a new web app, using the fresh new build, I added some fields that I wanted processed during login, i.e. common Profile stuff... added them to web.config.... sadly it appears that Studio 2010 will not automatically create a ProfileCommon class from ProfileBase, as previous studio web IDE's would do - that was frustrating for a bit, then I just created my own class... but that led to this interesting problem.

When populating the new profile attributes, the code behind class could not resolve any of the textbox referenced, all showed as not defined... figuring it was something simple, I kept going... added a customValidation control I needed, but though I double clicked the event in studio, and it dutifully created the stub code for me... the event never fired.

Determined to locate the problem I poored through forum entries and every reference I could (found lots of folks complaining about the profileCommon class stuff which is what led me to create my own class finally) -- but nothing specific to the problem I had of not seeing defined controls that were clearly there and working nor my customValidator control.

But... all of the code samples I saw - none had the ContentTemplate section... curious I removed that section, other items started to fail that were logical (header tags, etc.) but, my code behind section snapped back into order, intelisense n

Error "user does not have permission to perform this operation" with User Instance = True.


I setup SQL Server 2005 / SQL Express. All works fine in SQL Server 2005.

I am connecting to a SQL Database from VS 2005,  Tools/Connect to Database. I set the Data Source to "Microsoft SQL Server Database File (SqlClient)" (meaning SQL Server Express) and User Instance = True, and Integrated Security = True.

The above is working successfully on all machines except my Laptop. On my Laptop, I am getting this error "user does not have permission to perform this operation". On my Laptop, if I change User Instance = False, it works fine. Also, If I connect to SQL Server 2005 it works fine only if User Instance = False.

I tried all kind of security changes, nothing worked. For example, I setup Everyone as Full Control for the Folder and the MDF File of SQL Server. I gave my user ID as sysadmin role in SQL Server Express. Also, I enabled creating User Instance form SQL Server Express, Nothing is working.

Appreciate your help.


IE closing when user try to access the document library

<!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> IE closing (crashing) when user try to access the document library in share point site.  here we are using WSS2.0.  this problem for not accursed all the users , this problem happening on some users. 

"Read Only" Access Error when checking in documents from outlook



We are accessing our sharepoint services 3.0 document library through outlook 2007.

We can open the files in word/excel etc, but when we go to check-in the document the application tells us that we only have read access to the document, and cant check the document back in to the server.

It works fine via the browser, the read only problem is only when checking out through outlook.

I have given all users full access and design access to the doc library.

Any help would be greatly appreciated.






SharePoint 2007 Access Error


Hi everybody!

I´d like to verify if somebody see this scenario:

* I create a site, using te meeting site template;

* I give Full Control access to an user;

* When this user try to upload an item in a library, in this site, it was showed the message "Acces Denied".

* If the user press "back" in the Internet Explorer tool bar and press "F5" to refresh, the file is there.

* The same problem is ocurring, when he try to create a meeting.

Somebody ever see this error!?

Thanks a lot


Access Denied error


I have read several posts where this access denied to path ex.('c:\test' ).  The only way I got this to work was adding <identity impersonate> using my credentials in the web.config file but I don't want to use my credentials all the time.  I have Windows as the authentication mode so why doesn't it work without supplying my credentials?  I tried giving Network Service account write permissions to the folder but that doesn't work either.

Create User Wizard and Loginview error


 When i place the create user wizard control inside the Loginview Anonymous Template, the Create User Wizard gives an error inside the C# file. Here is a snippet

Home.aspx Web Form

 <asp:LoginView ID="LoginView2" runat="server">
        <asp:CreateUserWizard ID="CreateUserWizard1" CreateUserButtonType="Image" 
        CreateUserButtonImageUrl="~/images/signup.png" cssclass="createuser" 
        runat="server" OnCreatedUser="CreateUserWizard1_CreatedUser" 
           <TextBoxStyle CssClass="Ctextbox" />
            <LabelStyle cssclass="lbl" />
                <asp:CreateUserWizardStep ID="CreateUserWizardStep1" runat="server" />
                <asp:CompleteWizardStep   ID="CompleteWizardStep1" runat="server" />
        news here

Here is the C# Code with the error 


Error "The process cannot access the file ....." occurs while using function "ExportToStream"


Dear all,

   I sometimes get the following error while printing crystal report to pdf:

   System.Runtime.InteropServices.COMException (0x80004005): The process cannot access the file because
it is being used by another process. at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export
(ExportOptions pExportOptions, RequestContext pRequestContext) at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream
(ExportRequestContext reqContext) at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)
 at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportOptions options) at
 CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportFormatType formatType) at
 CommonWA.CommonFunc.GetPDFMemoryStream(DCMSReportDoc _dcmsreportdoc, Boolean& _DataExist) in E:\wwwroot\ASPWA\CommonWA\CommonCom.vb:line 382

  The error not occurs frequently but sometimes it will happen, can someone tell me why the error occurs and how can I solve the problem?

Thank you very much.


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