Tags » SSRS

SSRS MDX - Month/period parameter dataset (until current month + order descending)

Here’s how to accomplish this:

The results:

The code:

WITH MEMBER . AS ..CURRENTMEMBER.MEMBER_CAPTION
MEMBER . AS ..CURRENTMEMBER.UNIQUENAME
MEMBER . AS ..CURRENTMEMBER.LEVEL.ORDINAL

SELECT
{
., ., . 56 more words

SSRS

Manually Deploy SSRS RDL reports to Report Server using SSRS Report Manager Site URL

Recently I had to deploy some of my SSRS reports in a remote VM, where no Visual studio was present, so I followed the manual process… 282 more words

SQL Server

Get Extensive Web Analytics Reports from SharePoint, using SSRS

Well SharePoint offers OOB some basic Site Web Analytics reports.

If you go to the Site Settings ….

All of the data is stored in the WSS_Logging database. 189 more words

SharePoint

Error while accessing Localhost SQL Reporting Services Url - user 'DomainUserName' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed

In my machine I have 3 SQL server instances installed.

1> SQL Server 2012

2> SQL Server 2012 Express

3> SQL Server 2008 Express

so the corresponding default local host report server names are as below… 258 more words

SQL 2012

Enable SharePoint 2013 Integrated SSRS To Send Email Alerts

SQL Server Reporting Services (SSRS), when integrated into SharePoint 2013 enables reports to be sent to users via email.  From the report click Manage Subscriptions. 134 more words

SharePoint

SSRS: Easily calculate the difference between two fields/textboxes with an expression

This might seem to be a simple approach, but for some it takes to a while to figure out that such tricks are even possible in SSRS. 145 more words

SSRS

Aberdeen reds

One of our most popular posts on the SNH facebook page recently was a story highlighting how Aberdeen residents were thrilled to see red squirrels make a comeback to the city. 621 more words

Projects