Questions tagged [reports]

A report or account is any informational work (usually of writing, speech, television, or film) made with the specific intention of relaying information or recounting certain events in a widely presentable form.

0
votes
0answers
17 views

Converting rows to columns in SharePoint Online List PowerBi Report

I have 2 SharePoint List. Project(Project_ID, Project_Title) and Project_Tasks(Project_ID, Tasks_Title) [here Project_ID is lookup column from Project list.] I have data as: I am able to ...
1
vote
0answers
26 views

How to know what object is used for sharing in SharePoint online via powershell

I have retrieved a report to extract all the site groups across site collections in SharePoint Online tenant. During this process, I have got an item "sharing links with GUID". how to find what item(...
0
votes
1answer
24 views

Creating Weekly Reports

I want to create a weekly report that looks at the frequency of the distinct items in the "Created By" column on an incoming email library. Is there a way I could automate this, such as a workflow? ...
0
votes
1answer
19 views

Does a site has to be crawled to generate Usage Reports?

I'm trying to get usage reports from my Enterprise Search Center (SharePoint 2019). Usage report is empty on ESC, but working on other sites. The ESC isn't crawled, other sites are. Is it the reason ...
0
votes
0answers
8 views

Result Source not showing up in Search Usage Reports

I have set up a result source created at site collection level, among other few, and this particular one is connected to an external website we are crawling daily. In the query editor, the results ...
1
vote
0answers
10 views

Count number of workflows

We are considering going with a subscription-based workflow. As a result, we need to know about how many workflows are being run on a monthly basis. Is there a way to see how many workflows start ...
0
votes
0answers
24 views

Can we get Search related reports for a particular Subsite in SharePoint online?

We have a sub-site in SharePoint online under a site collection. Can we get these reports for that sub-site alone either out of the box or through powershell? • Top queries by day/month • No ...
0
votes
1answer
16 views

Is it possible to create report from several surveys?

I have several surveys with its results and I would like to do one report and sum up all the results. Is it possible to do that in SharePoint?
0
votes
1answer
23 views

SP 2013 Usage Reports

Is there any way to change the date ranges found in the Usage Reports? I can't seem to locate anything that will change the range in the "daily" section.
0
votes
1answer
52 views

How to find the storage metrics based on file type in SharePoint Online

We would like to know if it's possible to get the storage metrics based on document type for a SharePoint Online site collection meaning how much space is occupied by each type of document. Let me ...
3
votes
1answer
651 views

Embed Power BI report on SharePoint on-prem page, with SP List as data source and repeatable deployment?

I have asked a similar question about PowerView/PowerPivot, but I have not gotten an answer, and through further research, I'm starting to think I can't get done what I want to get done using ...
0
votes
1answer
29 views

What reports are available out of SharePoint 2013?

I've been researching Out of the Box and third party reporting tools to no avail. I would like to track how users are using sites in the company. SharePoint adoption is the measure of success of a ...
0
votes
2answers
557 views

Power BI Report Not Visible

I have a small problem hat i am facing currently, this involves Power Bi. I am trying to view my report on Sharepoint Online Site Page and the report is also visible but the problem is it is only ...
1
vote
1answer
33 views

whats difference between xml query with sql query?

I need to know advantages and disadvantages XML query and SQL query for SharePoint report.when we have large data which one has best performance? which one is faster?
0
votes
1answer
24 views

Microsoft Access style reports

Is there a way to build MS Access style reports with SharePoint list data without using Access? I'm currently able to query a list by making a REST call and dynamicly building an HTML table with the ...
1
vote
2answers
53 views

Sharepoint Reporting Options

My manager requested some reporting based off of a SharePoint site that was created to be used as a support portal for our team. I originally created an Excel spreadsheet with a data connection to ...
0
votes
1answer
373 views

Display SP Online list data as report in Excel Web Access Webpart

I have a SP Online list and I want to present this data as a report using Excel Web Access. First is it possible to sync a SP Online list data to an excel file uploaded to SP document library as a ...
1
vote
0answers
80 views

how to bind kendo pivot grid to the sharepoint list by rest

i have many lists in sharepoint that gather information from another lists by lookup fields. we want to make a report by kendo pivot grid. we have more that 30 reports that connected to lists and ...
0
votes
0answers
1k views

Embedding a PowerBI report inside a SharePoint page using “Publish to Web” Vs using “Embed in SP online”

I have a free account for PowerBI, and i did the following, to test how i can embed a PowerBI report inside sharepoint pages (sharepoint on-premises + sharepoint On-line):- I create a new PowerBI ...
0
votes
2answers
147 views

Pulling Multiple Items from SharePoint List to place in an Email

Is there a way to pull multiple items with a SPD workflow or Flow, and send them via email to a recipient. Currently, we are sending them for every new item that is created, but they would rather ...
0
votes
1answer
25 views

Error when trying to generate workflow report

I want to generate workflow report. So I choose my list, then Workflow settings -> view workflow reports -> Activity Duration Report -> I choose location to save file with report and when I click OK ...
4
votes
1answer
221 views

Creating a form to collect submissions and collate them into a report

The task An executive report is compiled on a monthly basis with submissions from various departments. Currently a Word document is received from each department and they have to be manually merged ...
0
votes
1answer
39 views

Can I dump BOBJ reports into SharePoint Online?

I wanted to see if it is possible to dump BOBJ reports straight into a SharePoint Online library? Currently we have a number of BOBJ reports that we email out daily to a number of people but thought ...
1
vote
0answers
81 views

How to render RDLC report in Sharepoint 2013 Report Viewer WebPart?

How can I render a rdlc report into webpart in sharepoint 2013. I have created a report, also added a data-source and a dataset. I have the following code: ReportViewer1.ProcessingMode = ...
1
vote
1answer
34 views

How to develop a Usage Utilization application for Office 365

We have a knowledge based site where data is stored in a SharePoint list. We want to keep track of each logged in user and the resource they access while navigating Knowledge based site. I know ...
0
votes
0answers
611 views

Publish Report From SAP BO to SharePoint Online

How can scheduled reports from SAP BO on-premises be published to a document library in SharePoint Online?
3
votes
1answer
398 views

How to display a RDLC report to SharePoint 2013?

I have created an RDLC report with visual studio and it looks like this: But the problem is that I don't know how to publish it in SharePoint page. So how can I display this report to SharePoint Home....
0
votes
1answer
27 views

Report on file names over 200 char long

Will be going through a migration shortly and I need to identify any file/pages that have a title/page name over 200 charcters long. I don't have access to power shell so looking for any alternatives ...
0
votes
1answer
33 views

what is the better way of develoment report in SharePoint 2013

I having a problem with a development the a report. Currently this report are development with Open XML but it is very complicated and demand much time. I need know if exists a way diferent for ...
2
votes
1answer
183 views

Display SharePoint report in Windows Forms Report Viewer

I have a report uploaded in SharePoint and it works fine. However i need to insert this report in Report Viewer inside Windows Forms. I get this error while using below code "The permissions ...
0
votes
1answer
210 views

sharepoint 2013 and reporting add in 2016 no render correctly

I have a server with Sharepoint 2013 installed and I have installed reporting services - Sharepoint 2016 and the reporting services complement for SharePoint products, and successfully configured the ...
0
votes
1answer
86 views

How to create a report in SharePoint that would sort/group several entries in a list together

I am trying to create a printable report that takes several entries in a list and groups them together. My company is moving equipment that we have inventoried and we want to have a print out for each ...
0
votes
1answer
86 views

Document views reporting

Is there a way to get data or reporting around how often a document is accessed on SharePoint? How can I create a report that would allow me to determine how often a document was viewed or opened?
0
votes
1answer
807 views

SP 2013 - Audit Report - Custom Report - Filters not working

We have setup up SP 2013 and enabled auditing. The issue is when I try to run a custom report on a sub site I get the error...It does not allow me to select using browse buttons in either the "Save ...
1
vote
2answers
404 views

Power View reports no longer open in SharePoint - “Server cannot be found”

I have SharePoint 2013 + SQL Server 2012 SSAS Tabular Mode + SSRS running in SharePoint integrated mode for business intelligence reports. This is in 2 environments, QA and PROD, which are identical ...
1
vote
1answer
563 views

using SSRS to generate a report based on a Calendar in Sharepoint 2013

We use the calendar in SP2013 to collect information when a user is away on holiday and when there will be any visitors. It works fine as a calendar but now struggling to generate a report in SSRS to ...
0
votes
1answer
542 views

SharePoint 2013 Audit Log - Unrecognized Guid format Error

I am trying to run an audit report on a particular site within my site collection. I go to run a custom report, select the SAVE LOCATION, Start Date and restrict it to my site. When I click OK to ...
0
votes
1answer
36 views

o365 security and compliance reports

I am using the security and compliance reports to investigate the deletion of some files I have set to search in a particular site collection for the files deleted and set a timeframe of 3 months (3 ...
1
vote
0answers
194 views

How to change ReportServerUrl in Report Builder 3.0? [closed]

We have 2 reporting server. One for test and one for production. Our business analyst will build the reports (rdl files) using Report Builder 3.0. After they complete the development and test on test ...
0
votes
1answer
36 views

Show MS Excel sheet in SharePoint list

I have an Excel document where we track team projects' travel periods. Preview Info: Users are ordered in 1st column. Bellow is Projects coloring legend. Team members are on site like User1, 20.11....
0
votes
2answers
68 views

What is the license terms for Power BI reports for streaming data

Is the Power BI license calculated by report render , I read https://powerbi.microsoft.com/en-us/pricing/?b=1 but i am confused ? Could you tell me what's mean 10K rows per hour streaming data ...
1
vote
1answer
33 views

Install Sharepoint Desginer 2007 on Windows Server 2008 R2

According to the official Microsoft SharePoint Designer 2007 the system requirements don't support Windows Server 2008 R2 I need this software to generate a report on the site is being used (metadata)...
1
vote
4answers
3k views

create some dashboards/reports in sharepoint 2013 without having access to dashboard designer or central admin

report/dashboard that shows the team members availability dashboard/report to show status of incidents/tickets ( we generate the report from remedy in excel file and upload the file in SharePoint ...
1
vote
1answer
157 views

What is best option for BI capabilities with SharePoint

In SP2010 there are silver light dashboards used to be there in our project. Now we planned to convert them into BI reports in SP2013. All these report data is coming from list and libraries. Some ...
1
vote
0answers
22 views

Get workflow reports from object model

I would like to call a standard workflow report (Activity Duration Report or Cancellation & Error Report) from server-side code. This is typically done by passing in the ReportId and the workflow ...
0
votes
1answer
173 views

2013/online auditing reports (content viewing never works)

In several places where I had to deal with SP on premise (2013) or online I always found out that the 'content viewing' report in the auditing reports is always null (giving me an error message, sorry ...
1
vote
1answer
49 views

Tracking Views on Webparts (by user)

I'm nearing completion on my organization's SharePoint site and was asked to find a way to show a report that indicates usage. Not just the simple view count report that is built-in, but rather a ...
1
vote
1answer
3k views

The report server cannot process the report or shared dataset

I have set up SSRS in integrated mode but am having trouble with getting it up and running. When I try to run report builder model, report builder report or report data source in the report library ...
1
vote
1answer
316 views

Surveys answers reports

Our company want to certificate emploees knowledge and for this reason created several surveys (about 10). The task is to collect data from this surveys and determine how much correct answers each ...
1
vote
1answer
315 views

Report Server Integrated 401 unauthorised error

I have set up Report Server in Integrated mode, using the Service Account as Network Service. On the report server I can log onto the web service using my credentials just fine. However when I try and ...