Questions tagged [ssrs]

Microsoft's SQL Server Reporting Services (SSRS), which provide "tools and services to help you create, deploy, and manage reports", usually querying MS SQL Server.

Microsoft's SQL Server Reporting Services (SSRS), which provide "tools and services to help you create, deploy, and manage reports", usually querying MS SQL Server.

244 questions
1
vote
2 answers

Asterisk Call Center Report - Inbound and Outbound Calls

We currently use Asterisk to run our call center which handles incoming calls (both direct dial to extension and queues) as well as a bunch of outbound calls. Up until now, we've used a custom report to pull data from the CDR table and report on a…
1
vote
3 answers

How to use Powershell 2 Get-WmiObject to find an instance of SQL Server Reporting Services (SQL2008) on Windows Server 2008 R2

I'm trying to use the powershell 2 "Get-WmiObject" command to find the reporting service instance using this command get-wmiobject -class "MSReportServer_Instance" -namespace "root\Microsoft\SqlServer\ReportServer" THE ERROR I GET…
user2666
  • 285
  • 2
  • 6
  • 8
1
vote
0 answers

reporting services 2008 R2 shows UAC for printing ActiveX after .NET 4.0 installation

Installed the latest updates on the server. Now every time I try to print from a reporting service website the UAC opens.. I already tried to reduce security within IE9 to the minimum, but with no success so far. Any ideas? Update: I disabled UAC…
SwissCoder
  • 111
  • 5
1
vote
2 answers

How do I give access to SQL Server 2005 Reports for users outside domain without using FBA

How do I give access to SQL Server 2005 Reports for users outside domain without using FBA. I've built report using SSRS 2005 and published it on the report server. The account is able to access the ASP.NET page which has the report control on…
Santosh Chandavaram
  • 245
  • 1
  • 2
  • 10
1
vote
1 answer

Report Server w/ SQL 2008 R2 Express - Can't login to Manager URL

I just installed Report Servicing addon (Advanced Services) to a local SQL Express 2008 R2 server. I have the configuration tool and setup the proper URLs but when I connect to them I get permissions denied: The permissions granted to user…
1
vote
1 answer

Connection to Oracle in Reporting Services won’t work after sp3 and cu1

Last night I installed sp3 and cu1 on a 64 bit SQL 2005 failover cluster. Everything went well. Reporting services is installed on the primary node. It now cannot connect to Oracle. The initial errors seemed to be related to this:…
Sam
  • 2,020
  • 1
  • 16
  • 22
1
vote
1 answer

Reporting Services 2008 R2 export to PDF embedded fonts not shown

I'm trying to export a report to PDF with a custom font. I have installed a font on the server that hosts Reporting Services 2008 R2, restarted the SSRS service, and sucessfully seen it using the web frontend, exported it to Excel, however on PDF…
1
vote
1 answer

When integrating SQL Server Reporting Services with SharePoint, does SharePoint have to be installed on the database server that hosts SSRS?

I am configuring SSRS (2008 R2) in SharePoint integrated mode to work with a SharePoint (2010) site that is on another server, do I also have to install SharePoint on the database server that is hosting SSRS? I should note that the SharePoint…
Infotekka
  • 545
  • 1
  • 5
  • 6
1
vote
0 answers

Problems with Apache Mod_Proxy and Microsoft's ReportViewer's Reserved.ReportViewerWebControl.axd

I've configured an Apache httpd server (v2.2) as a reverse proxy (with SSL) to a Microsoft IIS website running an ASP.NET application with SQL Server Report Services. The proxy mostly works but Report Viewer reports aren't being proxied, all I get…
1
vote
1 answer

SQL Server 2008 Reporting Services on Windows 2003

Will SQL Server 2008 Reporting services work if it is install on Windows 2003? Anyone have any experience with this?
Shiraz Bhaiji
  • 2,229
  • 9
  • 34
  • 47
1
vote
1 answer

configure the reporting services and/or IIS to give access permission

how to configure the reporting services and/or IIS to give access permission: Reporting Services
Sreekumar P
  • 117
  • 1
  • 9
1
vote
1 answer

SQL Server reporting services administrative access

I have a server which has SQL server reporting services installed within it and I need to give permission to a user to administer reporting services/have the content manager role. I however I did not install SQL reporting services on this machine…
ccame
  • 1,059
  • 2
  • 11
  • 15
1
vote
1 answer

Finding what the report subscription error is in SSRS

I've created a simple report in SSRS, and then tried my hand out with a data driven subscription. I can verify that the subscription runs on the 'My Subscriptions' page, but under status it says there is one error. How do I find out what this…
senloe
  • 111
  • 1
  • 6
1
vote
1 answer

Windows 7 UAC approved / unapproved list

Problem: Not able to print reports in CRM because of UAC block. Notes: A user with local admin clicked no to the UAC prompt to install the Report Viewer in CRM while printing a report. The prompt was for a program named "SQL Server Reporting…
JamesB
  • 147
  • 10
1
vote
1 answer

Can't add reporting service component for MS SQL Server 2005

Can't add reporting service component for MS SQL Server 2005 I want to reinstall sql server 2005, all components are disabled when i uninstall sql server 2005. It was bad than before now.
Cooper.Wu