SQL Server Reporting Services (SSRS) is server-based report generator from Microsoft. It provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization, as well as programming features that enable you to extend and customize your ...

learn more… | top users | synonyms (1)

2
votes
0answers
54 views

Report alerts still sending after alert and report was deleted

I have an SSRS report in SharePoint 2010, there was an alert set to send every minute regardless of whether the data changed. This alert was deleted, then the report was deleted, but its still sending ...
2
votes
0answers
270 views

Error on creating Report Model :Data extension does not support model generation

I'm trying to create a Report builder Model using a SP Custom List as Datasource. But it returns me the following error: Data extension does not support model generation. ---> ...
2
votes
0answers
205 views

What is the ConsumerConnectionPointID to use when adding an SSRS Report Viewer Web part declaratively?

I'm having trouble connecting my custom web part to my report viewer web part when using XML markup. My custom web part implements ITransformableFilterValues, so in order to pass values to the SSRS ...
2
votes
0answers
162 views

Package and Deploy SSRS Reports / Datasets etc

I have a VS report solution that contains around 40 reports as well as the child reports, sub reports, shared data sets, and data sources. How do I package these for SharePoint to deploy as a managed ...
1
vote
0answers
20 views

Error when setting up Reporting Services

I'm trying to set up Reporting Services on my SharePoint farm however I am getting this error when I try to access the URL: The configuration parameter SharePointIntegrated is set to True but Share ...
1
vote
0answers
33 views

Can't find the cause of user credential prompts in SharePoint site

I have a SharePoint 2013 instance that runs our company intranet site. This past weekend we moved our site to a new set of servers and we also set the site up use SSL (https). Since this move, some, ...
1
vote
0answers
187 views

Mail won't send - specified string is not in the form required for an e-mail address - SSRS Subscriptions

I am running SharePoint 2013. We use Exchange Online for e-mail. Because we have this set to require SSL, and SharePoint won't send mail with SSL, I have a local SMTP relay set up on the SharePoint ...
1
vote
0answers
14 views

Report Server has encountered a SharePoint error

I'm trying to deploy a report created with SQL Business Intelligence 2008 on a Sharepoint 2007. I've done this process a lot of time, but since yesterday I receive this error when deploying: ...
1
vote
0answers
41 views

Connecting MS Access Web Database Tables and Queries

I have created MS Web Access Database (2010) and hosted in SharePoint 2010. I would like to create reports in SharePoint using MS Web Access Database Tables; possibly using SSRS. I'm able to develop ...
1
vote
0answers
279 views

Data Refresh Account - Login Failure: the user has not been granted the requested logon type at this computer

I am trying to configure my Unattended Data Refresh Account and continue to get the following error with the account I am using: The data refresh for 'sqltestrefresh.xlsx' on Report Center - QA ...
1
vote
0answers
198 views

Sharepoint and SSRS query issue

I am using SSRS 2008 R2 with Sharepoint 2010 list and I have two reports from same SharePoint list. They return the same thing, only diffrence is the filtering part. How can we check in a CAML query ...
1
vote
0answers
192 views

SharePoint 2013 Reporting Service Integration mode

I face a difficult problem that I don't understand. What I have: SharePoint 2013 Enterprise SQL Server 2012 with all installed SP features, but configured in NATIVE mode. Both on the same server ...
1
vote
0answers
98 views

Reporting Services Webparts not Available in SharePoint Designer 2010

Firstly, I work as a DBA and have very limited understanding about how everything hangs together in SharePoint, so apologies if this is something pretty basic. We have just recently upgraded our WSS ...
1
vote
0answers
362 views

SSRS report on sharepoint becomes blank when clicking back

We're displaying SSRS reports using report viewer webpart. On Internet Explorer, we face a quite strange problem. Normally, reports display just fine. However, sometimes (yes, sometimes, not always), ...
1
vote
0answers
250 views

SSRS 2012 .rdl exposed in aspx page hosted as a web part in SharePoint Online 2013

From what I've read, there's no standard option for adding SSRS 2012 reports to SharePoint Online 2013. Instead, would it be possible to expose a report rdl in an aspx page hosted in SharePoint Online ...
1
vote
0answers
722 views

Problem connecting Sharepoint 2010 to SSAS through a RSDS

As the title says, I'm trying to create a Report Data Source on Sharepoint 2010 where I have an SQL2012 instance with the PowerPivot, SSRS and the sharepoint add-in configured. I choose "Microsoft ...
1
vote
0answers
215 views

Permission are insufficient after Migrating SSRS from Native mode to SharePoint 2013 Integration Mode

I have some SSRS reports which are in native mode on reporting server. The reports have 2 kinds of data sources: database connection and report model. I can run/view the report using my account ...
1
vote
0answers
259 views

Microsoft.ReportingServices.Library.InvalidReportServerDatabaseException

I'm getting following error in the General Application Settings-->Reporting Services-->Set Server Defaults section and also viewing reports on SharePoint. The version of the report server database is ...
1
vote
0answers
42 views

sharepoint ssrs report get query strings

I have a reporting service in sharepoint integrated mode. How could I get report parameters via query strings? please explain it with some examples! Thanks a lot in advanced!
1
vote
0answers
188 views

SSRS Report Designer and SharePoint 2010 Mixed-mode Authentication

We have a SharePoint 2010 installation that connects to a SQL Server 2008 R2 reporting server which is running in SharePoint Integrated Mode. Initially, our web application was using Classic Mode ...
1
vote
0answers
92 views

No email attachments to Document library when using data driven subscriptions

We have recently migrated to SharePoint 2013 and setup document libraries to publish reports to. When we send an email with an attachment to the document library from a users mailbox, the document ...
1
vote
0answers
122 views

Anonymous proxy authentication

So I was just reading How to set Anonymous User as a Specific User and I am not sure exactly how to implement and if it will fully cover my situation. I am trying to tunnel users from Salesforce into ...
1
vote
0answers
253 views

Using InfoPath inBrowser forms, create reports from captured data, and present those reports back in SharePoint

I'm using SharePoint 2010 and I have access to InfoPath and BCS services. I’m looking to use InfoPath forms that are accessed IN-BROWSER through SharePoint to capture data, and use that data to ...
1
vote
0answers
411 views

“Actions” menu hidden in Report Viewer web part?

The Actions menu which allows for export to excel, pdf and other functions is hidden in all of my report viewer web parts. I did try to browse to the web part galleries to see if I can set it up ...
1
vote
0answers
257 views

Use an Access Web Database as a data source for Excel?

I have an Access 2010 Web Database published to SharePoint as described here: http://office.microsoft.com/en-us/access-help/build-an-access-database-to-share-on-the-web-HA010356866.aspx If my Access ...
1
vote
0answers
81 views

Hide report builder link on Report Services Report Explorer web part

Is it possible to hide the "Report Builder" link that is displayed in the upper right hand corner of the Report Explorer web part? This is on SharePoint Services 3.0
1
vote
0answers
883 views

How to get current Login User Name from sharepoint in SSRS report instead of the SSRS report user name show the serviceAccount name

Currently when run SSRS in development, the user name is show correctly. But, once deploy it to sharepoint, the user name become static which means it keep display service Account name and not the ...
1
vote
0answers
80 views

Query Fields in Sharepoint db via Report Builder

Which is the best way to build a report to display the count of all upload files of a specific group of content types, foreach site collection? Should I use the table AllDocs to create de DataSet or ...
1
vote
0answers
217 views

Removing leading spaces/newlines left from unchecked Multi-Select box

I have a multi-select box with 15-20 values in it corresponding to SharePoint users. The problem I'm having is that for every entry in the Multi-Select box that is not chosen, a new line or blank line ...
0
votes
0answers
5 views

Can SharePoint 2013 SSRS Integrated Mode be referenced from another program?

We have a 3rd party system with a reporting module. It can generate it's own custom reports (non-SSRS) and also has the ability to generate RDL files to be ported into SSRS. There's not much ...
0
votes
0answers
16 views

SSRS Report Parameter Issue: Report Viewer Webpart Sharepoint Server 2013

I have added multiple ssrs reports on multiple pages using report viewer webpart. On small reports, I can change parameters and report are working fine as per changed parameters. But big reports are ...
0
votes
0answers
13 views

Sharepoint Server 2013: SSRS Reports always keep refreshing on iphone

Scenario: I have added report viewer web part on page and displaying RDL report. Report working fine on desktop and on android devices as well as on ipad tablets also. Problem: Whenever i open ...
0
votes
0answers
23 views

How to integrate sql server reporting services in sharepoint?

how to integrate SQL SERVER REPORTING Services in sharepoint 2013, I have a sharepoint test farm with one app server , one wfe server and one sql server. I prepared a new windows server 2012 R2 ...
0
votes
0answers
34 views

SSRS Multi Parameter selecting is not working

I have a report which has 2 date parameters and 1 drop down parameter. It works fine without drop down parameter, but with drop down it shows error Error occurred during local report processing. ...
0
votes
0answers
32 views

how to pass ID field in Source expression in SSRS report

I am preparing SSRS report for my SharePoint site. I have two lists interconnected with lookup using internal ID column. While preparing SSRS report, I referred the below syntax to get lookup field ...
0
votes
0answers
4 views

Added server to MOSS 2007 farm and it is redirecting to first one

I installed MOSS 2007 on a new 2008 R2 server and added it to the farm successfully. When I go to the server name in a browser it redirects me to the old server, if I use fiddler I see it do a 302 ...
0
votes
0answers
21 views

unable to load client print control error while printing

in our sharepoint 2007 farm . we are facing print issue in SSRS and users are getting errors "unable to load client print control" . with the help of our DBA's we found out that the issue is in the ...
0
votes
0answers
13 views

RSViewerPage breadcrumb, where to change link

Received a request today to modify the URL for this breadcrumb on a Report (RDL). We have are using the internal ReportServer setup for SharePoint. Visual: I have looked at the RSViewerPage to see ...
0
votes
0answers
33 views

SSRS report issue inside of SharePoint 2013 reports

Win7, IE11, SP2013, SQL12, and SSRS the Printer Icon never renders for users to print a report? Have updated the ReportViewer dll, SP1 for SP2013, SP1 for SqlServer with cumulative patch 8 applied. ...
0
votes
0answers
26 views

How can you get results from a SharePoint document library (with folder and child items) in a SSRS report?

I have a SSRS report that uses a SharePoint document library as a data source. The issue is that the list has folder and in those folders are child items. The dataset is only returning items from the ...
0
votes
0answers
33 views

Error when Uploading an RSDS File to SharePoint, collection and SSRS out of synch

I have a site collection with an RSDS file in it that gets modified by a powershell script. The script downloads the rsds file, modifies it, then uploads the new copy. It works great but the file is ...
0
votes
0answers
34 views

SSRS multi parameters problem in sharepoint 2013

I have a reports which has 5 Parameters are multi select. It works fine in SSRS Reporting Manager and Report Builder but when I host in SharePoint and try to select multiparameter it doesn't do ...
0
votes
0answers
36 views

How to enable MS Project Server Web App Reporting in MS Project server 2013?

I have MS Project server 2013, I want to enable reporting I have followed steps given in (https://technet.microsoft.com/en-us/library/ee662106.aspx ) but still when I click first it opens excel and ...
0
votes
0answers
8 views

Removing an SSRS Server

We have a server in our SharePoint 2010 farm that runs SSRS in "integrated mode". We would like to remove this server from our farm and run it in "Native mode". How can this be accomplished? Do I ...
0
votes
0answers
29 views

Can't access SSRS reports on SharePoint 2007 farm

We get this error in the Report Server logs when trying to access a report on the SSRS server: security!ReportServer_0-7!20c0!12/22/2015-10:41:11:: i INFO: Exception while running with ...
0
votes
0answers
33 views

BCS is to get external data into SP, what about the other way around?

I am going to migrate/update our SP 2010 to 2013 or 2016 (depending on when it actually gets released). Preferably cloud. What our fear is currently is... if we go cloud will we really have access to ...
0
votes
0answers
99 views

An unexpected error occurred while compiling expressions. Native compiler return value: `-1073741511'

I keep getting the error in the title when I try to access or modify any RDL file that uses an embedded data source from a SharePoint report library (I have approximately 14 reports). This error is ...
0
votes
0answers
23 views

SharePoint online - API data access quality

How much access to the data will I have if I use SharePoint online? Will I be able to do reporting from any list or rdl hosted in SP online via the available javascript api? What about pulling data ...
0
votes
0answers
38 views

How to change the path “_layouts/15/” of RSViewerPage.aspx in IIS 8, when configured Reporting Services to run in SharePoint Integration Mode

I want to add the folder LAYOUTSBWBI which is exactly the copy of the LAYOUTS folder. As I have been told to do some customization on "RSViewerPage.aspx". And as we know that the RSViewerPage.aspx ...
0
votes
0answers
14 views

Orphanded SSRS 2008 content types in SharePoint

We had upgraded from SP 2010 to 2013. Prior to the upgrade, it appears we had a broken install of SSRS 2008. It never worked. I was hoping the upgrade and the new version of SSRS (2012) would fix the ...