Pass Record Id Dynamically As Parameter to SSRS Report Using Fetch Xml

-

As we know we can pass id dynamically in fetch Xml query by using parameter in SSRS report. In SSRS report our purpose to make report dynamic based on any condition. In condition whatever value is present we can make as parameter in report data. We will show you step to make parameter dynamic.

You can follow the below link for basic of SSRS report like How to create and what all component is require.

https://juniorcrmblog.blogspot.com/2022/02/ssrs-reports-for-dynamics-365-using.html

Step1: Create a Data Source to make sure which type of data source type we use to perform the query expression. Just right click on the data source and provide the name, Embedded connection type and Connection String(In connection string provide the Dynamic CRM URL like "https://juniorcrm.crm9.dynamics.com"). 

If you don't know what is the means of crm9,crm8,crm7 etc. please see the below link.

https://juniorcrmblog.blogspot.com/2022/02/what-does-crm1crm2-crm3crm4-mean-in.html

Step2: Add the dataset just right click on the dataset and give the name of dataset choose the Data Source and then provide the fetch xml query under the query type text.


Then click on the expression and remove the value part in fetch xml like below.

Before:

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">

  <entity name="doc_doner">

    <attribute name="doc_name" />    

    <attribute name="doc_issueddate" />    

    <attribute name="doc_donertype" />    

    <attribute name="doc_donerid" />

    <attribute name="doc_date" />

    <attribute name="doc_donernumber" />    

    <filter type="and">

        <condition attribute="doc_donerid" operator="eq" uiname="Rakesh" uitype="doc_doner" value="{25435D78-E624-EB11-9FB4-0009AA0C9BF9}" />

    </filter>

  </entity>

</fetch>

After :

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">

  <entity name="doc_doner">

    <attribute name="doc_name" />    

    <attribute name="doc_issueddate" />    

    <attribute name="doc_donertype" />    

    <attribute name="doc_donerid" />

    <attribute name="doc_date" />

    <attribute name="doc_donernumber" />    

    <filter type="and">

      <condition attribute="doc_donerid" operator="eq" value= "@CRM_doc_donerid"/>

    </filter>

  </entity>

</fetch>

Step 3: Go the parameter and right click and create it and used it in fetch Xml.



Comments

Post a Comment

Popular posts from this blog

latest dynamics 365 interview questions

-
Image
Q. How to pass extra value in custom page in power apps? Ans: Generally in pageInput we can define four parameter like  pageType, name, entityName, recordId. But in real senarion if we want to share extra value then we can use in pageInput parameter itself. Example : var pageInput =  { pageType: "custom", name: customPageName, entityName: executionContext.data.entity.getEntityName(), recordId: currentRecordId + "$" + recordName ; }; Above value you can retrieve in custom page onStart function like below : Set(splitParam,Split(Param("recordId"),"$")); Set(recordName,Last(FirstN(splitParam,2)).Value); Set(RecordID, Substitute(Substitute(Last(FirstN(splitParam,1)).Value, "{", ""), "}","")); Q. If I create one record that created record date is older than 3 days then I want to perform some operation with the help of business rule. example: Let's assume I have case entity form and have
Read more

difference between enable rule vs display rule in ribbon workbench

-
 Enable Rule: It is the client side process.  Let's start with example:  I have an account entity under that I have more than two form. I just want to show the specific button based on the particular form you can use enable rule here. Display Rule: It is server side process. Let's start with example: I want to show and hide the button based on the security role then we will go for display rule. Note: For latest dynamic CRM interview question please click  Here .
Read more

If i create one record that created record date is older than 3 days, then I want to perform some operation with the help of business rule.

-
Image
Note: For latest dynamic CRM interview question please click  Here . Scenario: Let's assume I have case entity form and have created one custom field XYZ if the case is older than 3 days then I need to make XYZ field as mandatory otherwise it would be optional? Step 1: Create a new filed called "todaydate" with data type "Date and Time" and field type "Calculate". Now click on the edit and make the field as a current date and time by selecting the Now () function under Action that is it no need to give anything under condition. For better understanding i took one more field on form "createdon".  Note: "createdon" field is Out of the Box entity. Step2: Now I am going to write Business Rule to make field mandatory if case is older than 3 days otherwise it will be optional.  Step3: Once you activate the business process flow just open any old record which is older than 3 days. I have updated some of the field and try to save but it is
Read more