Monday, November 9, 2015
Running SQL SSRS reports without passing a parameter value on a record
Running a report on a record without passing a parameter is possible with fetch xml. (you can use pre filter attribute for this)
Is it possible to do with a SQL report? The answer is yes, it is.
How to do this?
You can write the SQL query and for this you need to add an alias which is given below.
SELECT accountnumber, accounted FROM FilteredAccount AS CRMAF_FilteredAccount
When you do this you are automatically will be able to run the report from the record without passing a parameter.
The below article describes this nicely.
There are occasions where we need to retrieve working days and working times of a resource in Dynamics grammatically. This is quite possible...
There is a bit of change in CRM 2011 than CRM 4. The code is below. Microsoft.Xrm.Sdk. EntityReference Moniker1 = new Microsoft.Xrm.S...
When you create a new security role from scratch and then assign only that role to a system user and when you log to the CRM site you might ...
Error message “User does not have send-as privilege.” when sending emails programmatically in CRM 2011We were working on sending emails programmatically using CRM and all were working fine. Suddenly we got this error when we tried to send an ...