Wednesday, June 26, 2013

Make SharePoint workflows using Visio 2010

Lately i was developing a company work-flow for the bank and it happened that what if i can make the work-flow using a visual move and fall device, and there it was already responded to by Microsoft company, the ability to make SharePoint work-flow using a mixture of Visio 2010 and SharePoint developer 2010.


SharePoint Developer is not able to link and mistake information is blank

When trying to link using SharePoint Designer 2010 to a SharePoint 2010 hosting server that is low on available physical RAM, you may receive the mistake “The hosting server could not complete your request”, despite the fact that the site is still running via the web browser.

Friday, August 26, 2011

How to Know the Number of Days in a Month in T-SQL

Sometimes we may need to know the number of days in a given month. For example, in calculating the number of days in a month or last day of the month or any other scenario.

Here is a small script that will give you the number of days for a month. For example, I'll pick month from the current date.

declare @numberOfDaysInMonth int;

set @numberOfDaysInMonth = DAY(DATEADD (m, 1, DATEADD (d, 1 - DAY(getdate()), getdate())) - 1);


How Do You Know the Name of the Month in the Monthly Index of T-SQL?

When working with reports, is that every time I'm looking for. Everyone gives the report date as input, and wants to show the month name in the report instead of the monthly index [1-12]. So how?

please use the below script to get the name of the month by month index.

DateName(month, convert( datetime, '2007-' + cast(month(getdate()) as varchar(2)) + '-01', 120))

Here month(getdate()) returns the current month index from getdate() function. Hope this helps...


How to make columns collapsible, expandable in table Sql server reporting services.

I asked some people how to do this, many people have offered the use of the matrix. However, my data is the data simple and has 14 columns like name, surname, state, city, zip code, Q1, Q2, Q3, H1, H2, H3, etc...

I need to show the columns Q1, Q2, Q3, H1, H2, H3, expandable and collapsible. By default, when you see the report, I show only the name, state, city, postal code, Q1, H1. But q1, H1, with the columns to expand, collapse icons.

When any one clicked to expand i need to show q2,q3, and same for h2, h3.

Here are the steps i followed to make it work.

No Matrix, no other,. i am done with tables only.

Just a small trick

1. Select all the columns that you want to make expandable, collapsible.

2. Hit F4 [Properties window] –> Select Visibility, and in that, set these values, Hidden = true and ToggleItem = ID of the textbox [Where you want to show the Expand[+], Collpse[-] symbols that text box id. in other words parent text box id.]

3. Done, Here we go.


Sunday, July 31, 2011

SharePoint 2010 initialization software and hardware requirements

Hardware requirements

64-bit processor

For front-end servers, RAM – 4GB for development, 8GB for production.

For Database servers, RAM – 8GB for small deployment, 16GB for medium deployments.

80GB of hard disk

Software requirements:


64-bit Windows Server 2008 R2 or 64-bit Windows Server 2008 SP2.

For development environments, we can use either Windows 7 or Windows Vista. But, it is highly recommended that we should not use these OS for production environments.


64-bit SQL Server 2008 R2 or 64-bit SQL Server 2008 with SP1 and CU2 only or 64-bit SQL Server 2005 SP3.

Remember, to install SharePoint 2010, it checks for all prerequisites required and if it didn’t find any then it starts downloading them from Microsoft site and install them in your server. Below are the listed modules which installs by the preparation tool.

Web Server (IIS) role

Application Server role

Microsoft .NET Framework version 3.5 SP1

SQL Server 2008 Express with SP1

Microsoft Sync Framework Runtime v1.0 (x64)

Microsoft Filter Pack 2.0

Microsoft Chart Controls for the Microsoft .NET Framework 3.5

Windows PowerShell 2.0

SQL Server 2008 Native Client

Microsoft SQL Server 2008 Analysis Services ADOMD.NET

ADO.NET Data Services Update for .NET Framework 3.5 SP1

A hotfix for the .NET Framework 3.5 SP1 that provides a method to support token authentication without transport security or message encryption in WCF.

Windows Identity Foundation (WIF)

more information


What You Should Know Before Learning of SharePoint 2010

That's the question I received from many people. Although they do not work in Microsoft related technologies, they like to work with SharePoint 2010 [only because the demand and the functions it has]. So, to learn what SharePoint 2010 technologies you need to know or what are the key concepts you need to be strong, that's what we'll discuss in this post.

The technologies/concepts you have to know as a Developer:

ASP.NET/C#: SharePoint 2010 is completely built on ASP.NET 3.5 whereas SharePoint 2007 is built upon ASP.NET 2.0. So, if you know basic ASP.NET 3.5 features then you get better ideas in implementing SharePoint 2010 coding and better understand concepts.

SQL Server: This is very important to know as SharePoint A-Z stores in database only.

Windows Workflow Foundation: There are workflows in SharePoint which is useful to solve business process problems. To create the workflows either in SharePoint designer or custom workflows you should have idea of WWF.

XML/XSLT: I can say everything in SharePoint is XML. So, if you are strong in XML then you rock. XSLT is applying styles for XML.

AJAX/Java script: AJAX is a generic concept and in ASP.NET the implementation is a bit different and you may need to know the general concept on how it works. Along with that you have to know java script.

Windows Communication Foundation: WCF is very popular these days as it has very good features. SharePoint 2010 is using WCF Services instead of Web Services. So, to work with them you have to know it. [For SharePoint 2007 it is not needed]

Silverlight: There are modules in SharePoint 2010 developed in Silverlight. And the integration of Silverlight code to SharePoint is also very easy now. [For SharePoint 2007 it may not be needed, but you can create custom Silverlight module and deploy to SharePoint 2007]

Internet Information Services: You have to know what is IIS and how it works.

The technologies/concepts you have to know as an Administrator:

SQL Server


Windows Server

SharePoint Designer

So these are things that everyone should preliminary set before learning about SharePoint 2010. No need to know all too deep, but you have complete idea of ​​what it is and how they work. Therefore, it can take a month to learn about these concepts and begin to learn SharePoint 2010. If you try to learn directly from SharePoint 2010 without knowing that these concepts can succeed in making content management, workflow, SharePoint Designer, customize appearance, etc, but do not know what is going on inside and how work. You cannot do coding, etc. So be sure to spend plenty of time to learn this information before you leap. Hope this helps.