Hot answers tagged

11

One of the great things about SharePoint is the ease with which you can create a list, and immediately have an online form people can use to enter data. Of course, once you have data in your SharePoint list, you’re inevitably going to want to implement some type of reporting against it. What’s the point of collecting all of this data if we can’t gain insight ...


5

Create a Power BI report that uses a SharePoint list as a data source Yes, you can get SharePoint List / Library data using OData Feed. SharePoint List as a direct data source connection For more details, check POWER BI: READ DATA FROM SHAREPOINT LIST Show that the report embedded somehow in a SharePoint site. There is no a Power BI web part in ...


4

Regarding If I install SSRS for SharePoint is it possible to achieve the same? Everywhere showing examples of external database like Adventure Works with SharePoint. But I have to build a report using list and libraries Yes , you can use SSRS to show data from SharePoint Lists using Report Builder , to do that check the detail steps at Create SSRS Report ...


4

You can easily render your RDLC report in Report viewer control within a visual web part using visual studio then publish it to your SharePoint. Note: You may face issue related to the compatibility between the Report viewer version in your web part and your Sharepoint config, so make sure that both versions are identical as mentioned at (...


3

as Nadeem Yousuf said, I also generate report in SharePoint with SSRS approach check this link : http://msdn.microsoft.com/en-us/library/6a3b7fc3-3d91-4d12-8371-42ea12e74517 basically, you develop button at webpart with specified url, when the url is hit, it will automatically generate format based on your choice, example : PDF for pdf, WORD for doc, ...


3

I think this is possible without any REST API or JavaScript. I recently did something similar for the project highlight reports. I am sure it will work on 2010 but I did this on SharePoint online: Here are the steps: Create the list with the appropriate fields (or create content type) and configure permission for the list and also the item level ...


2

This feature is not available with SharePoint Online. You might want to look into external tools.


2

This was a result of the Report Server Addin somehow being removed from the server. A re-install of this add-in resolved the issues.


2

You can use the REST/JSOM API to log your own usage to show up in SharePoint usage analytics. For example the REST endpoint looks like this: "/_api/Microsoft.SharePoint.Administration.SPAnalyticsUsageService/logevent" You can look at the full code example on doing this from JavaScript here: http://sharepointfieldnotes.blogspot.com/2013/11/more-sharepoint-...


2

You can use the SPContext object to get the current site/list . Using CSOM You are able to get list items from the object. -->Once you get all the fields items in the object , after that you can make HTML Format to display the list items as you want. -->At the end of the , You can Add new html control to fulfill Your requirement "Have a final page with a ...


2

It is most likely their ID that points to the User Information List where all site users are stored. Each user has an underlying numerical ID per site collection as each site collection stores its own copy of user data in the User Information List. It can be found at http://yoursp/managedpath/sitecollection/_catalogs/users/detail.aspx


2

I recommend using SQL Server Reporting Services (SSRS) as it supports displaying data in charts, and integrates with SharePoint. Install SSRS in SharePoint integrated mode, details Create SSRS reports that connect to your DB, details NOTE! You don't need to use Visual Studio to create the reports, the Report Builder works just fine and is easier as you can ...


2

I have done searching on to generate report from share point online. You can generate report from share point online list item using CSOM. Using console application you can access all the list item and manipulate as you want. You have to add "using Microsoft.SharePoint.Client;". You can get web using below function . var Test = new Program(); Test....


2

There are a lot of reporting options that enable you to show Data from SharePoint List like Excel Service. Performance Point. SQL ServerReporting Service Create SSRS Report from SharePoint 2013 List using Report Builder 3.0. Power BI. Also, check the comparison among the above options at comparing-performancepoint-powerview-excel-services-and-reporting-...


2

Yes, as usage reports are created by the Search Service you must crawl those sites.


2

I developed something for a similar purpose. This is not exactly what you are looking for but It can be modified for your need. The code is tested and run without any error. What the code does: You need to give the starting point(Site Url) The code Starts from a given SiteUrl goes to each subsite and each one fetches all the people have access to that ...


1

Power BI service For Individuals Cost: Free Connect to cloud sources Simple dashboard sharing 1GB per user data capacity Daily scheduled data refresh 10K rows per hour streaming data Power BI Pro service FOR BUSINESSES Cost: $9.99/ user / month Connect to cloud sources Simple dashboard sharing 10GB per user data capacity Hourly scheduled data refresh ...


1

It is client products not the server. Why you want to install it on the windows Server 2008 R2. Simply install it on your client machine and connect to the site & generate the reports.


1

report/dashboard that shows the team members availability In our farm we use list that have team members. Add a web part to page that shows this list and you are able to view the list of members on the page that will allow lync/skype status shown. You can modify the view of the web part to show exactly as you prefer. dashboard to show the incidents ...


1

Depending on your reports, there might not be any need to really do some frontend coding. If the reports are good as they are and you just need to display them on SP, it's fairly simple with Excel Web Access web part. I assume you want to automate processes as much as possible? Consider the following: In your Excel report you have a named area which shows ...


1

In order to do content viewing reports in SharePoint Online, you must use the Compliance Center. The viewing option is not available in the SharePoint audit reports like on prem. Another alternative is to use Google Analytics and track it separately. You'd need to create an app or use PowerShell to staple a custom action to your site. A nice option with ...


1

I am looking for both, entire page views and individual webpart views. Is there anyway to do this with the Out-of-the-Box platform? I'm not looking to spend additional money. You can do it for free, only some JavaScript coding required, no need for SharePoint Designer or Powershell or back-end code JSLink Since SP2013 you can add JSLinks to WebParts ...


1

Combining the lists may be best achieved using SSIS. Once you have a single data source you can access the list from Excel and design a dashboard in Excel and deploy it to SharePoint. Alternatively you could use PowerView to create a dashboard. You should also consider using PowerBI which would suit any 'power' users. Figure out how to combine the data ...


1

Try the following: $webapp = Get-SPWebApplication https://SharePoint.domain.com $sites = $webapp | Get-SPSite -Limit All $webs = $sites | Get-SPWeb -Limit All foreach ($web in $webs) { $users = $web.siteusers write-host "Processing " $web.url -foregroundcolor cyan write-host "Site Admins:" -foregroundcolor yellow foreach ($user in $users) { ...


1

Ok I cannot see which version of SharePoint you are using. But you can use rest api for fetching data or SOAP method. You can refer to the below Link where you will get all information http://blog.davidjwise.com/2007/11/28/connecting-sql-reporting-services-to-a-sharepoint-list-redux/


1

For on premises you could user SQL Server Reporting Services. Here's an example on how to create this: https://www.mssqltips.com/sqlservertip/2068/using-a-sharepoint-list-as-a-data-source-in-sql-server-reporting-services-2008-r2/. You might need to redo the grouping, as I'm not sure SSRS will respect this part of the view. SSRS will generate the report for ...


1

system.data does not work on sharepoint-online(Sandboxsolutions) external dll not allowed like itextsharp(not trusted)... S1-You can Create a webpart(like your page examples) & hide toolbars then fill your data and then Ctrl-P your page save as PDF. S2-You can use Document Content types and fill your data but I don't know how...(You can't use word ...


1

No code needed. You could create a data connection to the file in the form library using Excel's Get External Data method and map the XML contents that comprise the file to Excel. In Excel, on the Data tab, in the Get External Data group, click From Other Sources. Choose From XML Data Import. In the Select Data Import dialog box, navigate to the form ...


1

The easiest solution is to run your IIS logs through a web analytics software product. This provides the reports and overcomes the limitations of SharePoint's built-in reporting, which is weak anyway.


1

I can suggest you two ways to do that Using SharePoint Timer Job which runs monthly You can create a custom timer job which will iterate through all the the sites and then tasks list within a webapp. Then for each tasklist you can find the newly created and unfinished tasks format them in a presentable way and then use SpUtility.SendMail() to send the mail....


Only top voted, non community-wiki answers of a minimum length are eligible