SSRS

SSRS-2012 Reporting Services Configuration integrate in SharePoint 2010.

Hello all,

Once again , time for some blog post and today I just want to share some tips regarding the SSRS 2012 Reporting services configuration integrate in SharePoint 2010.

Recently, I tried to integrate the SSRS 2012 within SharePoint 2010 and configure the reporting services from native mode to SharePoint integrate mode in order to integrate reports from the SSRS server in the SharePoint site.

For this generally, we use the Reporting service configuration manager and within the configuration manager, I cannot set the  report server mode to SharePoint since it is default set to native mode and there is no any dropdown box to choose to SharePoint mode and create RS-database.

Finally , after some Research I found that :

It’s not possible anymore with SQL Server 2012 to configure Reporting Services for SharePoint in the Reporting Services Configuration Manager. We have to use the SharePoint Central Administration to Configure Report Server Integration in SharePoint mode.

Check out the link below for the solution for this thread

http://technet.microsoft.com/en-us/library/gg492276

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/358ac527-ac08-4f2c-8d6f-384c35dd9db8

http://technet.microsoft.com/en-us/library/bb326213.aspx

Thanks,

Anil Maharjan

SQL Server Reporting Services – Displaying some message within a Tablix if there is no data.

Hello all,

This is my first article that I am trying to write .I am encourage to write this article after joining a lot of BI related network and reading a lot of articles/blogs regarding different topic. so, this may be simply for one but for someone it will be helpful for those who don’t know how to do it ..

while working in .rdl design using BIDS , I need to display certain message within a tablix toolbox, if the table doesn’t contain’s any data to display or there is no row count. In normal it will display the data if there is certain to display but if there is not any data to display then we have to display the message as like i.e “Data doesnot match”

For this we need to add a new row within a same table and set the properties of ‘Hidden’ field as =IIF(Count(“DSName”)>0,true,false)

Then within a same row we need to add a ‘Placeholder’ by right clicking within a row and set its properties value expression as

=IIF(count(Fields!Row1.Value,”DSName”)>0,””,”No data qualifies for this section”)

Also in another terms,

Remove no rows property for the table,added another table header row with the expression

=IIF(count(Fields!Row1.Value,”DSName”)>0,””,”No data qualifies for this section”)

and set visibility hidden expression for the added table header row as

=IIF(Count(“DSName”)>0,true,false)

Replace”DSName” with your datasetName.

Hope this will help for someone .. 🙂 !!!..

You can see some snapshot as:

You can see output as if there is no data to display or no row count:

Thanks,

Anil Maharjan