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


Top 5 Contributors of the Month
SP
satyapriyanayak
Subhransu Sekhar Jena
abhays
DotnetUser
Post New Web Links

Public Access to SSRS Reports

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :ASP.Net
 

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

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

Public Access to 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.


SSRS - Where are the Sharepoint Report Usage Reports provided by Microsoft

  

HI,

Microsoft provided 3 example reports for Sharepoint report usage. Does anyone know where they are located? I used them about 2 years ago.

Thanks.

John.

 


[SSRS 2008 R2]Report Builder Access error-The remote server returned an error: (401) Unauthorized.

  
Hello,        I am able to login Web Service URL and report manager using computer name and report builder is also working fine.  http://RPTSRV/reportserver   (RPTSRV is report server name. web service url working fine. all accessible) http://RPTSRV/reports  (report manager working fine and all accessible ,report builder too) It means I am able to access everything locally right? http://rs.test.abc.com/reportserver  (web service url working fine. all accessible)  http://rs.test.abc.com/reports    (Report manager working fine and all accessible accept report builder)(I carefully checked the link and its taking rs.test.abc.com/reportserver.....)     when I click on reportbuilder button in report manager it shows me error dialog box with following error log!! I tried from local and remote computer too but gives the same error both side. I am not sure but I am just thinking is this double hop kerberos security issue? Please help me to solve this problem. I am finding solution from last 4 days. Reporting Service configuratin tool settings Web Serivice URL -  all set to default Report Manager URL - all set to default Environment - Distributed deployment Server1(report_srv) --Windows server 2003, Installed sql server 2008R2 reporting service,

Printing Issue in SSRS reports

  
Hi,   We developed around 70 ssrs reports for our new application.Its like,all the report names are mentioned in the left hand side and if we click it,.Net calls the SSRS reports and shows in the Right hand side.   The issue now is with the Printing.My client complains that they are not able to print the Reports properly.Some of the columns are moved to the next page,it seems.Reports are having different number of columns and we dont know how to resolve this issue.Should I use Landscape or Portrait?..If I give the table's width in the place of Report's width,will it work?    Your help would be greatly appreciated.

Schedule reports with integrated authentication SSRS 2008

  
Hi All,  Having an issue with SSRS 2008 at the moment, trying to setup subscriptions. Our system is configured so that any one of 10 users can login to the SSRS website using their windows domain account, and then launch report builder to design and save reports.  This all works very well, however, they have a problem when trying to setup subscriptions - the famous "Subscriptions cannot be created because the credentials used to run the report are not stored....." What the message says is true - the credentials are not stored as they are supplied by the user when they login to report builder. Is the /any/ workaround at all that doesn't involve storing the credentials?  It seems totally crazy that they cannot be prompted for them when setting up the subscription.  For this application its 100% essential to make the user provide their credentials when running reports, because they each see a filtered subset of the data in the report model (this is controlled DB side depeding on the login account), so their domain account needs to be passed to SQL server to enable this filtering to work.  If we saved their credentials then they would see all the data..and thats nasty. The only workaround I can come up with would be to create  a separate datasource for each user and upload a separate model, but thats really nasty to be hones

Converting crystal reports to ssrs reports

  
Hi, I need a documentation which helps me to convert crystel reports to ssrs. if any one having the procedural documentation you can email to my below mentioned email address that will be helpful to me in my new starting project. naveenjustlikethat@hotmail.com

SSRS Client Access

  
Hi, I have evaluating SSRS, and somehow I am quite confused. Please tell me if I am wrong in the basic understanding. To create a new report by the user, the client has to be installed with the Report Builder software, and must have access to the database server directly? Is there no thin client, say a web page available to allow the users to create a report (choosing of fields) like that of the Report Builder Software? Please help to answer this fundamental questions. Thank you.

How to programmatically hide SSRS reports

  
I've built a process to deploy several reports to SSRS in either native mode or SharePoint integrated mode.  I'd like to programmatically hide several SSRS reports when deploying them to a sharepoint site.  I believe I need to do something like this -  http://www.mssqltips.com/tip.asp?tip=1357.  Any pointers?  I'm new to SharePoint development. Thx.

SSRS 2008 SP1 - Enabling "My Reports" allows users delete reports in folders they should not be able

  
Issue: Users that have “My Reports” SSRS Role assigned to them can delete reports in other “shared” folders. My understanding was that they will be able to do the tasks specified only  in the “My Reports” workspace not everywhere. I have “My Reports” enabled via SSMS. Users have “My Reports” role assigned to them at the root level. My SSRS Role “My Reports” has only the following tasks assigned: 1.       View Reports 2.       Manage reports 3.       View Folders 4.       Manage Folders To test, I'm using Development version of SQL Server 2008 SP1. Thanks in advance, Martina

Where are the 2008 SSRS sample reports?

  
All the CodePlex 2008 links now go to the 2008R2 examples. Are the 2008 report samples still around somewhere?

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

Building SSRS reports based on SharePoint 2007 lists

  
Hi,   I'm building a SSRS report, and I want to get data out of a SharePoint 2007 list. The difficulty I'm facing is the following: The SharePoint server is behind an ISA Server, and is configured for Form-Based Authentication. Is there a way to keep the FBA and retreve information out of a SharePoint list with reporting services?   Kind Regards,  AVermaas    

Migrating from Crystal Reports to SSRS

  
Hi, we are currently evaluating SSRS and its features for making a decision on migrating from Crystal. I have read up on SSRS a bit and just need some confirmation on some of my findings. My company develops Windows applications, distributable via MSI files. The backend is SQL Server 2008. We are currently using Crystal Reports to display reports to the end user using the Crystal .NET viewer control. Crystal Reports are saved as .rpt files and contained in the msi file, therefore deployed to the clients. As we are considering migrating away from Crystal, I had a look at SSRS. It is my understanding that there are two ways of using reports: First, in local mode, which is similar to the way Crystal works: Client-side deployed report files. However, unlike Crystal, the application has to retrieve the data for the report from the database and pass a dataset to the viewer control whereas in Crystal, you just point the report viewer to the database you want to use and it pulls the data itself. The other mode, remote or server mode, has the reports stored in the report server (i.e. SQL Server). The viewer control will be set to the URL of the report, and the report then pulls the data from the SQL database. I am unsure to how you could deploy reports onto the Report Server using a MSI package; it sounds like quite a bit of work as the only way I have found by now is to consume webs
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