Thursday, March 31, 2011

How to enable Form Library,Picture Library in Sharepoint2010 BI center template


In Business Intelligence solutions sometimes you may need to publish InfoPath forms to a Form Library or to create a slideshow based on a picture library. But by default you can’t create a Form library/Picture Library when your site is created based on Business Intelligence Center.

If you click Site actions-> More options->Library, you see only following Library templates.

How can I enable Form Library?

Go to Site actions->Site settings

Under Site Actions heading select Manage site features. Then activate Team Collaboration List. Again go to the create window, here you’ll see additional libraries such as form Library, Picture Library and Wiki Page Library are enabled.

Wednesday, March 30, 2011

Hot to add percentage values in Map Legend Text in SSRS2008

When you configure the map with your data set in SSRS 2008 by default the legend text of the map shows only integer value distribution. If you double click on the map, the map layer dialog box will appear in right hand side, right click on the polygon layer of the map and select polygon color rule.. Map color rule property window will appear, select legend tab in the right side. You will see the current legend item of your map.

Under Legend text you’ll see

#FROMVALUE{N0} - #TOVALUE{N0}

This means you can display integer values only.

If you want the legend text to be displayed in two decimal places change the Legend text as

#FROMVALUE{N2} - #TOVALUE{N2}

By changing the number you can increase/decrease decimal places.

What about percentages?

Similar to previously changed legend text, now change it as

#FROMVALUE{P2} - #TOVALUE{P2}


The number determines the decimal places.

Now you’ll see percentage format in your legend text……..