Could not load file or assembly 'Microsoft.Dynamics.AX.Fim.PaymentService, Version=5.0.0.0,

While deploying SSRS , I got the below error :

Could not load file or assembly 'Microsoft.Dynamics.AX.Fim.PaymentService, Version=5.0.0.0,………….

To overcome this issue, we need to add the above mentioned dll from client\bin  folder to GAC as below :

Go to Start -> All programs -> Microsoft visual studio 2008 -> visual studio  tools -> visual studio  command prompt , right click and run as administrator :

Run the below  command :

Gacutil /i “location of dll”

Upon successfully added , you will get the message , “Assembly added to the cache”.

Hope it helps you as well.

How to add date range in SSRS

·         Create two parameters FromDate and Todate with Datatype System.DateTime

·         Add one filter under design with name FromDate with below values :

i)        Value = =1

ii)       Expression = =iif(isnothing(Parameters!FromDate.Value) = false,

iif(Parameters!FromDate.Value <= Fields!yourfield.Value, 1, 0), 1)

                Add another filter with name todate
                with above values except the expression values will be now

                        Expression = =iif(isnothing(Parameters!FromDate.Value) = false,

iif(Parameters!FromDate.Value >= Fields!yourfield.Value, 1, 0), 1)

Now you are good to go

An error message occurs when you create a dataset that has a "Dimension" type field

While working on one SSRS project , I got the error "

Could not refresh the dataset since query 'SELECT CustTable.1.AccountNum,CustTable.1.City,CustTable.1.Dimension[1],CustTable.1.Dimension[2],CustTable.1.Dimension[3] FROM CustTable' could not be resolved in Dynamics AX"

The problem here was that we have selected Dimension fields in query  , and AX was not able to resolve it because , these fields in database are stored as  Dimension,Dimension1_  and so on ........ not like Dimension[1], Dimension[2],... .

Microsoft has provided the fix for this issue ,Please find the below link :

http://support.microsoft.com/kb/970874

Make sure to install it on client and sever both machine, as well where you are developing SSRS.

will be back very soon

Thanks,