Tagged Questions

0
votes
0answers
18 views

SSRS Dataset valid, but data does not show up in generated reports

I have created a Sql Reporting Services Report from a SharePoint list. I am creating this report in Microsoft SQL Server Report Builder. When I hit "run query" on my dataset in the query designer, I ...
0
votes
0answers
17 views

PerformancePoint data source from Oracle

I have a requirement to create KPI and dashboard for which all data comes from Oracle. I am looking for getting this data into PerformancePoint to create KPIs.. Can anybody point me to the right ...
0
votes
0answers
26 views

How to automatically generate the URL for the “URL Access” of SSRS Reports in a Report Library?

This is my setup: I've a few reports developed using Business Intelligence Development Studio & deployed on Reporting Services in SharePoint Integrated mode. The RDL files are deployed to a ...
0
votes
0answers
72 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 ...
0
votes
0answers
36 views

Sharepoint Snapshot/Subscription Issue

On a production environment we are deploying to, we are getting the following error when trying to execute a Subscription on a ssrs report by taking a Snapshot: Failed to validate the delivery ...
2
votes
1answer
44 views

Moving reports from sharepoint 2007 to 2010

I currently have both a sharepoint 2007 farm and a sharepoint 2010 farm, both have an SSRS server. I need to move the reports from SP 2007 to SP 2010 and I'm not sure how to do this easily.
0
votes
0answers
37 views

Problem on configure SSRS with SharePoint 2007

I came across of setting up SQL 2005 Reporting Services into SharePoint 2007,I had install the reporting service and SharePoint add in and now stuck in Reporting Service Configuration Manager. The ...
0
votes
2answers
59 views

What do I have to do prior to site creation of a “Report center” template?

I have a SSRS service installed, I have Sharepoint 2010 Enterprise Edition. As I read on the internet, I should activate the Report Server Central Administration Feature in site settings > Manage ...
1
vote
0answers
47 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 ...
0
votes
2answers
1k views

Sharepoint output list of users

I would like to output the users of a group, for 40 groups, or for every group within the SharePoint Portal. I would like to do this programatically through powershell or a command line tool for the ...
1
vote
2answers
821 views

SQL Reporting Services in SharePoint Mode Prompts for Login

Scenario: We currently have SQL Reporting Services 2008 R2 in a scale-out deployment on two servers. SSRS is configured in SharePoint integrated mode with our SharePoint 2010 servers (configured with ...
1
vote
2answers
100 views

Publishing Report PDFs Monthly - multiple permissions to view them

We have about 30 reports a month to publish. Each report will have a different set of security rights. (For example, office manager x should only be able to see his/her report. But there are a few ...
1
vote
1answer
3k views

The permissions granted to user 'MYDOMAIN\ryanhayes' are insufficient for performing this operation. (rsAccessDenied)

I'm getting several users getting access denied for some SSRS reports that are in a reports directory in SharePoint 2010. I have a single sharepoint group with all users in it so all users have the ...
0
votes
1answer
823 views

Can SQL Reporting Services generate reports automatically?

I need to set up a report generation system for a SharePoint list. The report will display all items within the date range that is specified by the user with a start and end date. The requirement ...
2
votes
1answer
431 views

Why does Reporting Services in SharePoint integration mode require a minimal install of SharePoint?

I have a two machine set-up, with MOSS 2007 installed on one server (Machine A), and SQL Server 2008 installed on the other (Machine B). In order to run SS Reporting Services in SharePoint ...