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

Firefox Error in parsing value for 'height'. Declaration dropped

I have developed Java Script to find the height of columns height and make it match for all columns in the web page but I was getting an  error “Error in parsing value for 'height'.  Declaration dropped” in the Firefox but in IE it is working fine without issue, then we I cross checked the script I found the issue I forget to define the unit of measure, so I just added the unit of measure and this issue resolved, following the old code and new code.

Old Code

   function msetcontainer() {

        if (document.getElementById) {

            var windowHeight = getWindowHeight();

            if (windowHeight > 0) {

                var contentHeight =

        document.getElementById('rightcol').offsetHeight;

                var contentID = document.getElementById('rightcol');

                var LeftcontentHeight =

        document.getElementById('leftcol').offsetHeight;

                var LeftcontentID = document.getElementById('leftcol');

                if (LeftcontentHeight != contentHeight) {

                    contentID.style.height = LeftcontentHeight;

                }

            }

        }

    }

New Code

   function msetcontainer() {

        if (document.getElementById) {

            var windowHeight = getWindowHeight();

            if (windowHeight > 0) {

                var contentHeight =

        document.getElementById('rightcol').offsetHeight;

                var contentID = document.getElementById('rightcol');

                var LeftcontentHeight =

        document.getElementById('leftcol').offsetHeight;

                var LeftcontentID = document.getElementById('leftcol');

                if (LeftcontentHeight != contentHeight) {

             //there was issue with firefox becasue i forget to add + 'px'

                    contentID.style.height = LeftcontentHeight + 'px' ;

                }

            }

        }

    }

eConnect error 475 - taRMTransaction

Terms Discount Taken Amount (DISTKNAM is not valid for Credit Memos and Returns (RMDTYPAL = 7 or RMDTYPAL =8).

Sometimes you will get this error when you are calling the eConnect method taRMTransaction to create returns (RMDTYPAL =8) or credit memos (RMDTYPAL =7)receivable transaction but you’re passing terms discount taken amount (DISTKNAM) in the  method taRMTransaction, the reason both credit memos and returns are credit documents and in the MS Dynamics GP terms discount not applicable for the credit documents, as solution if when you are creating returns / credit memos transaction don't pass value in PYMTRMID.

eConnect error 474 - taRMTransaction

Payment Terms (PYMTRMID) are not allowed on Returns (RMDTYPAL = 8) .

Sometimes you will get this error when you are calling the eConnect method taRMTransaction to create returns receivable transaction but you’re passing payment terms , actually the returns are credit document and the payment terms applicable only for the debit document. in receivable transaction entry window of MS Dynamics GP when user select document type as Returns system by default will disable the payment terms field, lockup and expansion button to stop the user from adding the payment terms, same validation has been build in the eConnect and because of that system throwing this error "Payment Terms (PYMTRMID) are not allowed on Returns (RMDTYPAL = 8) " so as solution if when you are creating returns transaction don't pass value in PYMTRMID.