Melick's Blog

As you already know Report Server can be run either in Native mode or SharePoint integrated mode. Report server has feature of scheduling subscriptions for your reports. Report Subscription allows you to schedule your reports to deliver to recipients. There are few Delivery mechanisms available in SharePoint. Windows File Share Email SharePoint Document Library Null Delivery Provider There might be a situation that you cannot find the Email option in the list. What you need to do is configure Email in Report Server Application. How to Configure Email server for reporting server Go to Central admin and then go to Manage Service Applications Then find the related Reporting Server Service Application and click on SQL Server Reporting Services Service Application Then go to Email Setting Section And Enter you SMTP server details. And save the settings. Now you can find the Email delivery option in the subscription settings.

In my previous post I have explained how to pass the custom URL parameter to the Report when it is SharePoint Integrated Mode. As explained earlier post report server parameter has three parts. <prefix>:<Parameter Name>= <Value>   Parameter Type Prefix Note Report Viewer Control rc: Report Server HTML controller Report Server rs: Report Server to process Report Viewer Web Part rv: Web part parameters Report Parameters rp: Report parameters (Explained in Part One) When you are running the Report Server under SharePoint, You can Access the report Server using /_vti_bin/reportserver. You can find similar page if report server is running.   rc: This is for passing parameters to Report Server HTML viewer. Here are the list of parameters. rc:Parameters rc:Zoom rc:Section rc:FindString rc:StartFind rc:EndFind rc:FallbackPage rc:GetImage rc:Icon rc:Stylesheet EX: - http://mysharePoint/_vti_bin/ reportserver?<Do...

  This error occured to me when im trying to access the Manage Processing Oprions in SharePoint SSRS. “ An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. —> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. —> System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object ‘xp_sqlagent_notify’, database ‘mssqlsystemresource’, schema ‘sys’ .” Cause is configurations isses and provisioning issues of Reporting Server User on Related Databases (Master , SSRS) You can resolve the issue by re run the script on your database server. For that you can downlod the report from the Central Admin by Application Management  ->  Manage service applications Then go to Repo...

  I have a problem with showing a entire report (without page brakes) in the SharePoint with the ssrs integrated mode. I have tried many options and nothing work but changing the Height of the InteractiveSize to 0 worked for me

There is a slightly different between earlier SSRS report parameters and NEW SSRS running in SharePoint server 2013. URL parameters are slightly different from native mode and SharePoint Mode. This article is only about SharePoint mode parameters. SSRS running on SharePoint has few parameter types and types are passing to SSRS engine using prefix.   Parameter Type Prefix Note Report Viewer Control rc: Report Server HTML controller Report Server rs: Report Server to process Report Viewer Web Part rv: Web part parameters Report Parameters rp: Report parameters Most of the time passing parameters to report is more frequently used than any other Passing the Reports as a URL Parameter Assume that we have created a Report with parameter interval and need to pass the values from the URL. Let’s see the attributes of the @interval parameter. I have mentioned the visibility as visible but you can also have it as Internal as well. Internal will not be ...

Report Server has encountered a SharePoint error. ---> Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error. ---> Microsoft.SharePoint.SPException: The user does not exist or is not unique. ---> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors in SharePOint 2013 This is error accouring because of Anonimous access to the Microsoft Reporting Services. According to the Microsoft ; Microsoft Reporting Service not supporting annonimous access for integrated mode. Ref: https://msdn.microsoft.com/en-us/library/bb283324.aspx#Anchor_4 So you might be wondered how you can archive this. Option One Simply you can dissable the Anonimous access from IIS. But this wont work if you really want anonimous access in your farm. For an Example If are hosting internet site with integration mode public reports you can not dissable the anon...

You may encountered with following error in SharePoint applications. You need to enable service debug to see real exception in the application. Sorry, something went wrong The server was unable to process the request due to an internal error.  For more information about the error, either turn on IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute or from the <serviceDebug> configuration behavior) on the server in order to send the exception information back to the client, or turn on tracing as per the Microsoft .NET Framework SDK documentation and inspect the server trace logs.   If you are in a multi farm environment first you need to find out where your service applications are running. For an example assume that you need to know where reporting service is running. Go to central administration and then go to Services on this server .  Here you can change the Farm machine and can see whether reporting server instance is running. so note down ...

This error occurred to me when i was trying to add .bism model file in SharePoint Power view configuration in WFE server . The reason would be power view configuration process not installed the Microsoft.AnalysisServices.Xmla.dll in the WFE server, You can check the dll by navigating C:\Windows\assembly in the particular server. If this dll is not available you need navigate ( PCUSOURCE\1033_ENU_LP\x64\Setup ) in your SQL installation and execute spPowerPivot with out PowerPivot options.

Data mining models designed using Microsoft Analysis Services can be view in a web browser like your SSRS report. You only need to do is to download the Web Control Library provided by the Microsoft and install the feature set. Download:Microsoft SQL Server 2008 Service Pack 2 Feature Pack

This is not a complete post. I came across a situation that I needed to show [Date] dimension values which is not empty as report parameter. But I need yeas that only have values in measure. there for I used following MDX to get that. with member yKey as [ Date ].[ Year ].currentmember.uniquename member yValue as [ Date ].[ Year ].currentmember.MEMBER_CAPTION select {yKey,yValue} on 0, { filter([ Date ].[ Year ].[ Year ],[Measures].[Total Amount]<> null ) } on 1 from [RetailigenceBI] this code result in getting

Normally  MDX queries are returning caption for reports when we are using data in SSRS. But  we need other information such as UniqueNumber and other when passing as parameters to other reports and datasets. Below shows example query used for get the member properties. (We can declare it using WITH MEMBER ). DayKey is the custom column we are creating with member DayKey as [Date].[Date]. currentmember . uniquename SELECT NON EMPTY { DayKey ,[Measures].[Sample], [Measures].[Sample2] } ON COLUMNS , NON EMPTY { [Date].[Year-Month-Date].[Date]. ALLMEMBERS } ON ROWS FROM [RetailigenceBI]

This error Occurred to me while I design the query in the Query Builder and generate the report in SSRS ( MDX). Months are showing alphabetical order (April , August,..) , but it should be January , February .. I did some background works and even follows the the thread http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/27765eda-371d-4428-ab13-2e96b2fbb6ca . But ultimately I  found there is a sorting adding by default to that column. I Deleted it .. Bingo .. It worked ..