SSRS - How to Parameterizing the SQL Query

1. We need to create separated dataset to handle the pre defined list in that dataset we will use simple select statement to define the list : 

SELECT    Number  FROM         Table 1 WHERE    ORDER BY Number

1. In the main dataset when we create the Query in the we will filter the column with parameter e.g.  we put in the Filter column for Number  “= @SerialNumber”  this allows the user to specify a serial number at the time the report is run
2. please click on below  link  to access the original artical

http://www.dynamicssol.com/ShowArticle.aspx?ID=60 

Delegation

Delegation is type which can be used to save reference to method (procedure /function). Since delegation is a type so we should think it is something like data types then we can define variable of that delegate (type) and then we can use this variable as reference to method.

The declaration of the delegation same of the declaration of the method with one exception delegation will not have body (no code), and the declaration represent signature of method so it will contain return value and parameters.

Delegate  <return Type> <MethodName> (type  Prameter1,type  Pramter2)

Delegate double processMath(double  param1 , double param2)

 

1. First declare delegate processMath which have signature same of method1 & method2
2. Declare variable process of the delegate (this variable will have type as delegate)
3. Initiate the variable process by using the contractor, process= new processMath (Divide)  , as we see when we Initiate the variable we pass the method name as parameter which not match with the declaration of the delegation, but that method has signature same as of the delegation .
4. Finally we will call the variable which represent the method and we will pass the parameters.

Object Oriented Programming - OOP

Class & Object:

• Class it is like an data type and Object like variables.
• As we can define variable MyString and Type will String
• Also we can define Object MyObject and class will be Class A
• Any Object will represent an instance of Class
• We can define more than one objects belong to same class, as we can define more than one variables with string type.

 

 

Properties & Fields

• Properties and fields will give accessibility to the Object  Data
• Object data which the things that differ each object from other objects which belong to same class. For example if we want to represent the coffee in OOP we can assume we have Class call it  CupOfCoffee we can have different objects belong to that class , if we assume the CupOfCoffee class will have filed call it coffee name so we can have the following objects:
  • Object1:Turksh Coffee
  • Ojbect2: Nescafe Coffee 

• As we can see we can differentiae the two objects based on the value of Name Field

To access the full version of this article please refer to the following link

http://www.dynamicssol.com/ShowArticle.aspx?ID=51

  :

How to create more than one organization in CRM 4- Part1

There are two common method to create more than one organization in CRM 4 configuration , in both ways we have to use Deployment Manager utility which will help us to create the new organization. To open the Organization Deployment Wizard  we need to use the Deployment Manager utility.


 

To access the full version of this article please refer to the following link

http://www.dynamicssol.com/ShowArticle.aspx?ID=57