Disclaimer:

These are my personal views and are meant for Informational purpose only. Please verify the Information via Professional help or via Official references before acting upon the information provided in this Blog.

SQL Server 2012

You have a SQL Server reporting services (SSRS) report that has a table which displays some records — but sometimes it can have NO rows; In that case, how to display “There are No rows” message so that it doesn’t confuse the consumer.

Solution:

Open the report in SQL Server Data Tools and go to the “design” tab of your SSRS report

Select your table (do NOT select a cell inside a table. Make sure that the table is selected)

While the “table” is selected, Go the Properties section OR you can use F4

Inside the Properties section, find “No Rows” section and you should see a NoRowsMessage property:

Go to the preview tab to make sure it’s working and you should be ready to deploy the change!

For SSRS reports hosted on SharePoint, the Data Alerts & Subscribe are grayed out or disabled.

What do you have to do?

You need to upload a SSRS and for the data sources, you’ll have to store the credentials or no credentials.

It’s not ideal for user-level security (e.g. via Windows Authentication) setup on the data source side but the requirement of data alerts and email subscription dictate that you need to stored the credentials or not have credential requirements.

Real-world story:
what we ended up doing at a client’s was to create a SharePoint library for “report subscriptions” which is hidden from end-users. We added a service account to the data source & we store the credentials of the service in the report used for report subscription. And IT “controls” who receives the email. So after a user submits a request to get emails, IT goes in the security database & see’s if a user is fit to receive the email or not. So not all users may get approval to receive the email. That was a solution that we had to take to stay compliant.

While I was working with DQS, I got an error that didn’t allow me to export the cleansing results to an excel file. I searched to find that it was a known issue for the 64 bit version of Excel. So based on what I found, this is how I was able to solve the error:

As I mentioned, these are post-sql-server-installation tasks and so I assume you have your BI environment using SQL Server 2012 already up. The official note can be found here: Install Master Data Services

For the purpose of this blog-post, we’ll break the steps into three main sections: