Report not getting deployed in Report manager

Hi,

I have created 2 reports in SSRS. In my 1st report there is a tablix, which contains many rows. The text in these rows act like hyperlink and upon click navigate to my 2nd report. This functionality is working fine in Visual Studio and also in report manager. But as soon as I deploy my reports in SharePoint site (using a page viewer web part), this functionality breaks. I can see when I take my mouse near the text in the Tablix it shows a URL like http://IP Address/Reportserver/

It's evident that the URL here is not forming correctly. Can anyone help me out in this issue. In my report for navigation purpose I had used Action -> Goto Report (report 2) and passing the parameters there.

Thanks in advance,

Suman

Hi I would like to have a URL link in Report Server that directs to one of our directory folder that has a history of pdf reports. I want to know if its possible to do this by just having to upload the URL link into Report Server, like we upload the .rdl files using Report manager. Is there any way to do this? Please let me know. Thanks

Hi, I deployed some reports unto report manager.  When opening them, I noticed that all of them by default had scroll bars around them. Is there anyway I can set the scroll bar adjustable or disable the scroll bars? thanks !  

Hi, I am using SSRS 2008 with Custom security extension for authentication. The extension is developed in c#. I have placed the dll under report server bin and report manager bin directory and the logon,login pages under appropriate directory. My reports manager url is http://localhost:port/Reports and my reports server url is http://localhost:port/ReportServer. When I try to login through reports manager url, I am getting 'login failed' error message from the dll. But when I try to login using reports server url, it works. I have also set 'FullTrust' named permission set in RSMgrPolicy.config . <CodeGroup class="FirstMatchCodeGroup" version="1" PermissionSetName="FullTrust" Description="This code group grants MyComputer code Execution permission. "> < IMembershipCondition class = " ZoneMembershipCondition " version = " 1 " Zone = " MyComputer " /> Any suggestions please!   Thanks!

Hello, I want multiple users to access same report or different reports through report manager for a report server. Will the scenario of opening multiple windows of report manager on same machine and execute reports from all windows simultaneously mean same as multiple users accessing the reports at the same time? If not, then how should I generate the scenario of multiple users? Regards.

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

Hello everyone: I have tried to install and configure Reporting Service. I found lots of  errors along the way. The first one was an error (500.23) from IIS7. I applied the suggested solution on the IIS screen which was migrating configuration using AppCmd ( %SystemRoot%\system32\inetsrv\appcmd migrate config "Default Web Site/"). Next problem was  : Request is not available in this context Stack Trace: [HttpException (0x80004005): Request is not available in this context] System.Web.HttpContext.get_Request() +3465893 Microsoft.ReportingServices.UI.Global.get_ConfigurationManager() +47 Microsoft.ReportingServices.UI.GlobalApp.Application_Start(Object sender, EventArgs e) +32  This error was caused by the fact that Report Server and Report Manager were configured to DefaultAppPool in the Reporting Service Configuration Manager. I have switched to Classic .Net AppPool  for both Report Server and Report Manager and it has fixed the problem. Now my problem is that the Report Manager Application ( http://localhost/reports/folders.aspx ) shows no tab, toolbar or folder. What I now have on the Report Manage Application page is the header with the title and [home] and [Help] button links on the top right corner. I have made a report to test the problem but no folder shows o

Hi I have a report with a drillthrough functionality on two cells in a tablix, the intention is for each cell to pass different parameters to the target report. The report fuctions exactly as expected when previewing in BIDS, each drillthough passing the appropriate parameters to the target report. However once the report is deployed (to a SharePoint environment), only one of the drillthroughs will function. In the other, the pointer recognises some kind of link (it changed to a 'clickable' icon) but it won't function (and there is no target displayed at the bottom of the browser as there is with the working link). I've cheked the html source for the page and it appears not to have an onclick command for the first cell (contianing the text 'BSC C701 - BIOCHEMISTRY (4 YR)(I)'): <TD ID="11iT0r9c0" class="a144c"><br/> <DIV class="a144"><br/> <DIV style="overflow-x:hidden;WIDTH:73.14mm;" class="r13"><br/> <DIV class="a143"><br/> <span style="font-style:normal;" class="a140">BSC C701 </span><br/> <span style="font-style:normal;" class="a141"> - </span><br/> <span style="font-style:normal;" class="a142">BIOCHEMISTRY (4 YR)(I) </span><br/> </DIV><

Hi, not sure this is an expected behavior.  My drill through reports have parameters that are passed from the first report.  once drill through, somehow the parameters are not showing in report manager.  also the Back arrow is also missing from the second report.  is this expected?thanks

Hello, I have problems with the external access for report server. My report server is running in a local server on port 80, which can be accessed through http://servername/reports I have set up external access to the report server through http://servername.domain.com:8081/reports , so I set up a redirection from public port 8081 to port 80 on the local server. When I write the address http://servername.domain.com:8081/reports in a browser, I get asked for user authentication(Windows domain user), which is accepted, but after that I get an error because the URL automatically changes to http://servername.domain.com/Reports/Pages/Folder.aspx (without the port 8081) If I write http://servername.domain.com:8081/Reports/Pages/Folder.aspx , it works. I can see the report manager home page and browse through my reports. But there are some links in the page that are built improperly, since they still point to the wrong URL (without port 8081). These are e.g. the Help link, the Report Builder link, the Details view link.  So I think there is something wrong with the response the report server sends, when I write ".../Reports" and returns ".../Reports/Pages/Folders.aspx" I haven't found any configuration file or property where this response is specified, neither where the report

I have an instance of Reporting Services 2008 running on Windows 2003 server.  So, the webservice URL is running on port 801, and runs fine (I can browse reports from that directory, and upload / deploy new reports and overwrite existing reports. Report manager is set to use port 800 (IIS is also on that machine running port 80).  When I attempt to connect to report manager, I get the following error, with a link to "Home" in report manager (which brings me back to the existing error page):    Unable to connect to the remote server  In the logfiles for reporting services, the following error is there: " System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it.   Any ideas? Windows Firewall is NOT running on this machine.   Thanks, Chrisrjp

Report Manager Security: If a user login to Report Service than he should be able to see only a folder for which he has role assing and rest of the folder should be hidden for him. How this security i can achive with c#

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?

Hi.I am running VS2008 enterprise evalution version on XP SP3 with reporting and analysis services running fine.The problem I am facing is when I click the Report Builder Option from Report Manage . I get the error message stating "To use the report builder you must install .NET framework 3.5"I have .NET framework 3.5 installed on my system and running as implied from the below test This machine has the correct version of the .NET Framework 3.5.This machine's userAgent string is: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; SIMBAR={9A33F5AB-FB0B-4036-9CED-E5E16D795253}; Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.2; OfficeLiveConnector.1.4; OfficeLivePatch.1.3; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022).Please let me know what I am missing.Also, I am running IE 8.0.6001thanksvineet

Installed SQL Server 2008 with Reporting Services to a Windows Server 2008 box.  Tried to open the Report Manager and had no tabs and no Site Settings link - just a blank home page. I am logged onto the server with local administrator rights, so it shouldn't be a permissions issue.

Thinking the installation was bad (IIS was not installed before installing SSRS), I uninstalled and re-installed SSRS after setting up IIS 7 on the server.  Still the same issue - just a blank home page in report manager with no ability to add users or assign roles or see anything except the links for "Home", "My Subscriptions", and "Help".

Any suggestions would be appreciated.

I have created my own menu system and would like to prevent casual users from ever going to the home screen as it just confuses them.  Is there a way to turn off this option?

Hi,

I have recently installed SQL Server 2008 R2 Developer on my Windows 7 Pro PC. I installed a named instance called ARGENTOSQL. I want to connect to my Report Manager and have been following the instructions in the following article (which worked for me previously when doing the same thing on my laptop running Windows 7 Home and SQL Server 2008 Developer):

http://msdn.microsoft.com/en-us/library/bb630430.aspx

Unfortunately, despite running Internet Explorer as Administrator, adding http://MyPC to trusted sites, navigating to the Report Manager URL http://MyPC:80/Reports_ARGENTOSQL, then (when prompted) entering my Windows user authentication (user account Ian - an administrator account on my local machine), I cannot shake the following error message displayed in the browser:

User 'Ian-HP\Ian' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

If there are any experts out there reading this who know what's causing this or can provide me with a list of things to check/do, I will be very grateful.  :-)

Ian.