Tuesday, July 23, 2013

Fix It: 3 steps to show your SSRS report header in all pages while scrolling

Hi Folks,

I'm writing this blog about a tip i spent some time to fix in one of my SSRS reports. The issue is that i have my header is visible while i'm scrolling but only in the first page. I want the header to show in all report pages and not just the first page.

I didn't find a resource or MSDN article to resolve this issue but i tried the old technique "try and error" until i found a resolution for it and then i have my header is showing while i'm scrolling in all my report pages.

The case:
You have a tablix in your report with header, you want to keep the header visible while scrolling in all pages.

The solution is in 3 steps:

1) Set "FixedData" property for each header column to True.  Here is how to do it:
     http://msdn.microsoft.com/en-us/library/dd220509.aspx

2) Now, If you previewed the report, you would see the header is visible while scrolling!!, here comes the trick, Select the (Static) item from the Row Groups right pane and open the properties window.



3) Set the following properties to True:
   Set FixedData, RepeatOnNewPage properties to True
   Set KeepWithGroup property to After

Now, Preview your report from VS 2012 SSDT or BIDS and you will see that you have visible column in all report pages!

Enjoy!
 

Wednesday, July 17, 2013

What’s new in Records Management and Compliance in SharePoint 2013


Hi Folks,
I’m writing this article about what’s new in Records Management and Compliance in SharePoint 2013. SharePoint 2013 has extended the retention policies to be applied on the site level!.

Having the site retention policies on the site level is a cool feature, especially for most of the small/medium organizations that creates sites for their departments and not site collections.

Another cool feature which is the site policy also applies on SharePoint 2013 Foundation, so you can apply your site retention polices if you have SP 2012 Foundation instance.

Site Level Retention:

You can manage retention policies to SP sites and exchange 2013 team mailboxes that are associated with the sites.

Compliance officers create policies, which define the following:

n  The retention policy for the site and the associated exchange team mailbox, if any is associated.

n  What causes the project to be closed?

n  When a project should expire.

Here are the steps to apply compliance and retention policies:

1)      The site owner creates a SharePoint site.

2)      The site owner creates an exchange server 2013 team mailbox.

3)      The site owner assigns/selects the appropriate retention policy template.

4)      The site owner invites team members to join the site.

5)      All emails and documents among the site team members, the selected policy will be applied.

6)      When the project is completed, the site owner closes the project.

7)      Once the project is closed by the site owner, all project folders in outlook 2013 User Interface will be removed.

8)      When the project expires as per the selected policy, all associated artifacts to this project will be deleted.

 Hope this helps.

Useful Urls:

** Overview of site permissions in SharePoint 2013