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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Public Access to Reports

Posted By:      Posted Date: September 21, 2010    Points: 0   Category :Sql Server
 

I'm designing some reports to summarize recently compiled research findings.  These reports are going to be posted on an ASP.NET page (via the report control) on the web site.  I do not want to authenticate users, as the findings are meant to be public and requiring users to register and authenticate would add a barrier and is likely to decrease traffic.

I've seen similar posts where reports are meant to be viewed by everyone on an intranet and permissions could be set using a designated workgroup.  I need alternative solutions to the problem of making a report viewable by everyone who visits a site.  I'm also currently unfamiliar with Kerberos (and I know that will probably pop up as a potential solution), so if there's a convenient way outside of that it would be great.




View Complete Post


More Related Resource Links

Public Access to SSRS Reports

  

I'm designing some reports to summarize recently compiled research findings.  These reports are going to be posted on an ASP.NET page (via the report control) on the web site.  I do not want to authenticate users, as the findings are meant to be public and requiring users to register and authenticate would add a barrier and is likely to decrease traffic.

I've seen similar posts where reports are meant to be viewed by everyone on an intranet and permissions could be set using a designated workgroup.  I need alternative solutions to the problem of making a report viewable by everyone who visits a site.  I'm also currently unfamiliar with Kerberos (and I know that will probably pop up as a potential solution), so if there's a convenient way outside of that it would be great.


Share Point integrated SSRS reports rendering when access from external site

  

Our client has a SharePoint (moss2007) site on Windows 2008, SQL2008 R2 Enterprise, and Reporting service is integrated with SharePoint

The authentication on the share point integration is set to windows, else the authentication for the SSAS datasource gives and error

The extranet zone ( forms) and intranet (Customer Forms) and default (Windows) zones are all access from inside the firewall and the reports render in each with no issues, as the datasources are configured to pass a sql username and password.

However, report rendering is a problem from the internet (external site), the following error is displayed:

 
An unexpected error occurred while connecting to the report server. Verify that the report server is avai

Access Public Function in MasterPage

  
Hi,I need help in accessing the function in my masterpage.I have a.master and b.aspx with the content page.Now in the page load of my content page, I want to execute the an sql query which is in a function in my master page.How can I access the function in my master page??code in my master page:public function info () as string'SQL Queryend function

Cannot access public methods on MasterPage

  
Hi All, maybe someone can help me with this one. I have a a public method in my code behind on the site.master pagenamespace PROJECT { public partial class Site : System.Web.UI.MasterPage { protected void Page_Load(object sender, EventArgs e) { } public void applyUserRole(string userID) { } } } I  wish to call applyUserRole() from Default.aspx On Default.aspx I have .. <%@ Page Language="C#" MasterPageFile="Site.Master" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" Title="Project- Home" %> <%@ MasterType virtualPath="~/Site.master" %> But when I go to Default.aspx.cs and type Master. the method is not appearing. I've seen other post where people are having this issue but I can't find an answer. If anyone has any good pointer and you please let me know, thanks 

save reports in Private and Public folder using Report Builder 2.0

  

Hi,

 

I have a report builder built on RB2.0. Users are able to create their reports and browse them.

Now, Users wants these reports to be saved in their Private folder and public folder.

 

Also, I have a UI developed in .Net 3.5 from where I am calling this report builder.  In the UI, I need to show the users those reports that they have created in a drop down list. And when the user clicks on any report (that they created should) open.

 

I have searched a lot but not getting any clue how to allow the business user to save a report

Cannot Access Reports from Computers Within Network

  

Hi,

 

I am able to access reports from my computer that has the SQL Server (2008) installed, but can't seem to access from other computers in the network. All I get is

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

Can someone please help?

I tried creating user "MyComputerName\Guest" and assign permission to view reports, but still cannot get it to work. Am I doing something wrong?

Here are some details from my Report Services Configuration Manager

Service Account is set up to Use built-in account : Network Service

Current Report Server Database

SQL Server Name : MyComputerName\ServerName

Database Name : ReportServer$ServerName

Report Server Mode : Native

Current Report Server Database Credential

Credential : SQL Account

Login : sa

Password : **********

 

Thanks


user access reports

  

We've got a Sharepoint 2010 infrastructure that we're going to need to audit in a "who has access to what" type of report. Complicating things a bit is that we're using AD groups, so SharePoint often doesn't seem to know who's in whatever AD group, they just know the group has access. 

But our auditors want to know what no-kidding-human-being has access to what. I was wondering if there is a native way to do this, and if not, any recommendations on third party software approaches? Thanks so much!


Cannot access /reportserver and /reports - http 404: webpage cannot be found

  

hi

i just made a new install of sql server 2008 r2 with reporting services. unfortunately i'm not able to access the two urls. i get an 404. does anybody know that problem?

i switched off uac, started ie as admin, added the sites to the trusted sites, opened port 80, changed the port in rss to 8080.... no positive solution.

thanks for your help


How do I access Usage Reports Top Queries programmatically

  
Hi, I need to retrieve the top queries from the Usage Reports? Do I need to fetch it directly from SQL or are there classes that does this for me? Regards, Martin

Cannot access reports?

  

Hello,

 

I am getting an error when trying to run a report:

An error has occurred during report processing. (rsProcessingAborted)

Cannot impersonate user for data source 'MITSAssets'. (rsErrorImpersonatingUser)

Log on failed. Ensure the user name and password are correct. (rsLogonFailed)

Logon failure: unknown user name or bad password 

I am able to got to http://vossql1/Reports/Pages/Folder.aspx  but when clicking on any report http://vossql1/Reports/Pages/Report.aspx?ItemPath=%2fAssets+Detailed+per+Data+Center I am getting the error above.

Apparently the dbo of the database is gone... how could I retrieve the access to it... I tried an sp_changedbowner and I am getting an error:

Msg 15110, Level 16, State 1, Line 1

The proposed new database owner is already a user or aliased in the database.

I restarted the SQL Server and the SQL Reporting services... still no luck

I deleted my account from the Database and readded it with the sp_changedbowner, restarted services ==> no luck 

What should I run or pass as command to get access?

Thanks,

Dom


System Center Operations Man

Access web database Reports - "file not found" error

  

The reports section of my Access web databases aren't working - I keep getting a "file not found" error for every database I upload.  I even tested it with the Northwind Web Database sample from MS.  I could see the reports in Access 2010, so I successfully uploaded the template to my SharePoint 2010 Server, and when I clicked on the links to view the Reports - I got the same "file not found" error for this sample database.

Anyone seen this before?

Thanks.

Steve


Restrict public access to webservice

  

I have this Internet web service page(webservice.asmx) being consumed jquery ajax call.

And I am hoping to restrict public request to this webservice other than request from local pages (aspx or jquery ajax call).

The web service checks for form-authentication before it gets executed but I just don't feel comfortable the .asmx page and list of services are viewable.

So users can't just type www.mysite.com/webservice.asmx to access my webservice. 

I'd appreciate any advice about securing web service.



ASP.NET MVC: Using NonActionAttribute to restrict access to public methods of controller

  
 

Public non-action methods in ASP.NET MVC controllers are source of problems because they can be called by user when not handled carefully. Same time you may need public methods on controllers for some other reasons (some UI framework, testability problems, things you cannot change etc). In this posting I will show you how to handle controller methods properly.

Calling controller methods

Public methods of controller are called controller actions and these actions are mapped to URL-s using routes. Take a look at the following code.


public Acti

MVC architecture in ASP.Net using C# and Microsoft Data Access Application block

  
The Model-View-Controller (MVC) pattern separates the modeling of the domain, the presentation, and the actions based on user input into three separate classes [Burbeck92]:

Model. The model manages the behavior and data of the application domain, responds to requests for information about its state (usually from the view), and responds to instructions to change state (usually from the controller).

View. The view manages the display of information.

Controller. The controller interprets the mouse and keyboard inputs from the user, informing the model and/or the view to change as appropriate.

Viewing Reports with SharePoint 2.0 Web Parts

  
Reporting Services provides several Web Parts that work with specific versions of a report server and in particular deployment modes. If you want to access report server content on a SharePoint site from a native mode report server, use the SharePoint 2.0 Web Parts that are included with Reporting Services. Instructions for installing and using the 2.0 Web Parts are provided in this topic.

Store and Display Images from MS Access Database Using C#

  
There is only the difference of coding syntax to stream the binary data of image content type to upload it into MS Access Database using C#/VB in ASP.Net 2.0

Namespaces required:-
using System.Data.OleDb;

OleDb is used to connect the web site forms with MS Access Database using Microsoft.Jet.OLEDB.4.0

ASP.Net Upload Image to MS Access Database

  
As you learnt from the previous articles to upload image to the SQL Database in ASP.Net 2.0 and stream that image into the memory to retrieve it from the database and display it on the web page. In this article you will learn how to upload images to the MS Access database in ASP.Net 2.0

First of all create an Access Database and place it in the App_Data folder of ASP.Net web site project. Then create a table "tblImg" with the following fields:
Categories: 
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