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

Cross-Page connections are only supported by a few old webparts as it became obsolete after SharePoint 2003. In order to support Cross-Page connection the web part need to: derive from the Microsoft.SharePoint.WebPartPages.WebPart instead of System.Web.UI.WebControls.WebParts.WebPart (the recommended approach since WSS2.0/MOSS2007) declare the interface in ...


5

SSRS, to be used in SharePoint Integrated Mode, must be installed on a server that has SharePoint installed and joined to the farm. Obviously this would not be a good idea to install SharePoint on a Database Engine server if you can avoid it. Install SSRS on your SharePoint server in Integrated mode. Yes, you must license SQL Server (SSRS) on your ...


5

The only solution that worked for me is Modifying the default view of the document library and set the Folders > Folders as Flat: Show all items without folders. By the way, I tried to edit the Query as a text and set <ViewAttributes Scope="RecursiveAll" /> despite there is no syntax error but the query behavior is not changed. it still shows ...


4

Going stand alone will only (negatively) impact the security accounts used and the use of SQL Server Express 2008 R2 instead of your own SQL Server 2012 (and of course will prevent any growth later on) Both installations will run the Farm Configuration wizard which will configure most of the service (and you should do it manually to have better control once ...


4

The RSViewerPage.aspx is a Out the boxed application page in the _Layouts folder. Application pages, which are also known as "_layouts" pages, are stored in a site's Microsoft Internet Information Services (IIS) virtual directory and support application implementations. Application pages are shared across all sites on the server, whereas a site page ...


4

Formula will be something like this: =IF(OR([Column3]="5", [Column3]="6"), [director approval date]-[finance approval date], "-") Here is the reference Example of common formulas


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

There are couple of things to check. Check the Usage and Health Data service is up and running. Proper Events are selected (Analytics Usage, Feature Use, and Page Requests) in the Usage and Health data services. Usage Health data service is connected with the web applciation. Make sure Microsoft SharePoint Foundation Usage Data Import and Microsoft ...


3

Ended up solving this myself using Powershell instead of C# (using mock-variables in this snippet). The Powershell script must be executed from the SharePoint server and under administrator privileges (both windows & SharePoint I believe). Edit: Also note that my SiteCollection is the root web for the web application #Powershell Clear-Host # Add ...


3

Open the report folder in Windows Explorer view....:-)


3

You're correct in that it needs access to the object model when running in Integrated Mode. In Native Mode the reports run in SSRS/SQL and not SharePoint directly. The report viewer for a native mode report is just an iframe, essentially. In integrated mode the reports are stored within SharePoint, so SSRS needs to be able to communicate with SharePoint to ...


3

You can define the parameters normally in report builder but when you pass the parameters from query string you need to append it with rp: http://sitename.com/_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/Reports/MyReport.rdl&rv:ParamMode=Hidden&rp:city=Perth where Relative report url is the url to your .rdl file (Report file) ...


3

You need to install Reporting Services Shared Addin in the SERVER 2 [your second WFE]. Kindly refer to the scale out architecture mentioned in technet. http://technet.microsoft.com/en-us/library/hh479775.aspx The presentation layer of SSRS reports on SharePoint Integrated mode depends on this component which adds specific capabilities on Web Servers to ...


3

Use the Globals!ReportServerUrl variable from within Report Builder: If you just want the base URL of the site, then remove the _vti_bin bit by using an expression: =Replace(Globals!ReportServerUrl,"/_vti_bin/ReportServer","")


3

I would assume that the session management service is actually disabled/not provisioned as the message suggest. If that is the case, you can enable/reate it by using the PowerShell command Enable-SPSessionStateService -Defaultprovision This will provision a new service with the default configuration. If you need to change some of the parameter, please ...


3

When using SharePoint integration, you can host Reports and other SSRS files in SharePoint document library, including but not limited to defining permissions for individual reports using SharePoint permission model (users, groups, permission levels). When using Report Viewer web part, you can configure lots of details regarding the displayed report using ...


3

#get web and ct $web = Get-SPWeb http://your/site/name $ct = $web.ContentTypes["CT name"] #get the column from the web $spFieldLink = New-Object Microsoft.SharePoint.SPFieldLink ($web.Fields["alias"]) #Remove the field from the ct and update $ct.FieldLinks.Delete($spFieldLink.Id) $ct.Update() #dispose the web-object $web.Dispose()


3

Go to SharePoint Central Administration >> System Settings >> Manage Services on server, and check if SQL reporting services is there or not


3

It's not possible. Please check following link with all available features in SharePoint online https://technet.microsoft.com/en-us/library/sharepoint-online-service-description.aspx I think that the best option to build reports is Excel Services or Power BI.


3

Yep, You can use ThorApps BI Service to host your ssrs reports in SharePoint Online. Its available from the Sharepoint App Store or from https://www.thorapps.com Adrian


3

First, as mentioned in the comment, check your data source. In SSRS, r-click on the data source, and select properties. In the properties dialog, check the "connection type". With a value of rsssharepointlist in the dataset, I'm guessing you're using a sharepoint list data source. If you're using the SharePoint list data source, one consideration is that ...


3

The SSRS add-in must be installed on all SharePoint servers in the farm. As for the SSRS instance, that can be installed on any server in the farm, although you'll get better performance from an end user perspective by installing it on one or both FEs, should your FEs be capable of handling the additional load. As for the addin, make sure to install the ...


2

Finally found the actual cause after I closely followed this link: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/daa59eec-b651-42dd-9f6c-42aaa3fa4523 Looks like the original account that was used to create the *.rdl files and the data connection library was removed from SharePoint. The resolution is download the rdl files and ...


2

The 504 Gateway Timeout error is usually a network error between servers on the network or an issue with an actual server. This may also mean that the report server is down or not working properly. If you have manually configured the proxy , verify that Bypass proxy servers for local addresses is set to true. <system.net> <defaultProxy> ...


2

I ended up solving this within the reports using the code: Public Function StrStrp(str As String) As String str = str.TrimStart(Chr(10)) Return str End Function


2

You may use powershell to set the new DataSource. As noted from this blog post, you can use Set-SSRSDataSourceInfo. Set-SSRSDataSourceInfo will set the Data Source URL for every report in a Document Library. Simply run the function with a Document Library URL, Data Source Name and Data Source URL parameters.


2

Check the permissions of the Report Library where the reports(.rdl) are uploaded. At times,report library will need contribute level access rights for all the users who wish to see the reports inside this library. Also it is advised that do not use inherited permissions on the report library. Stop inheriting permissions and give permissions directly on the ...


2

That's right, SSRS "Business Intelligence Development Studio" (or BIDS) project files won't work with the Visual Studio 2010 shell. But there is no reason you cannot simply use the Visual Studio 2008 shell, which is what the SQL Server client tools should be installing for you. Just be sure you install the SQL Server Client Tools into the DEV environment, ...


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