how to create report rdl file in mscrm

-
1. Install Bids Tool in Visual Studio
2. Open new project in VS
3. Templates -> Business Intelligence ->Report Service ->Report Server Project
4. Go to View ->Report Data
5. Click on Data Source -> Add Data Source
6. In Data Source Properties ->Connection String-> Enter Url “/” Oraganization Name and Enter
7. Credentials -> check Use this user name and Password of crm and click Enter
8. Select the Data Sets -> Data Set Properties -> Data Source ->DataSource1 ->Query type(Text)
Query(Enter Fetch Xml Code)
9. Enter Values dynamically using Parameters see the below screen shots.
Fetchxml code:
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
  <entity name="account">
    <attribute name="name" />
    <attribute name="primarycontactid" />
    <attribute name="telephone1" />
    <attribute name="accountid" />
    <order attribute="name" descending="false" />
    <!--<filter type="and">
      <condition attribute="createdon" operator="on-or-before" value="2017-12-12" />
      <condition attribute="createdon" operator="on-or-after" value="2017-12-18" />
    </filter>--> 
    <filter type="and">
      <condition attribute="createdon" operator="eq" value="@pramer1" />
      <condition attribute="createdon" operator="eq" value="@pramer2" />
    </filter> 
  </entity>
</fetch>


10. Page Number Should be Dispalyed header or footer of the report page
11. Display the 5 records per page
a. select table row -> add group -> parent group
b. group properties -> general tab ->Add -> fx
c. select ->constants -> Write the Expression
d. Ceiling(rownumber(nothing)/5) ->Enter

12. Break the page of every 5 records

13. Out Put of the Process


Comments

Post a Comment

Popular posts from this blog

Sample CRUD Operations Using C# in MSCRM

-
Sample CRUD Operations Using C# in MSCRM Steps to Achieve: Create a console Application in Visual Studio and add (Microsoft.Crm.Sdk.Proxy.dll, Microsoft.Xrm.Sdk.dll) in references section. Download this C# Class files to get crm service ,If you have this files just skip this step https://www.dropbox.com/s/pyj6zym6u9ea7wp/deviceidmanager.cs?dl=0 https://www.dropbox.com/s/q82xp39jn0nqi0j/OnlineService.cs?dl=0 Open OnlineService.cs file and enter your crm credentials as shown below            ClientCredentials credentials = new ClientCredentials();             credentials.UserName.UserName = "Username@Domain.onmicrosoft.com";//Username             credentials.UserName.Password = "yourpasswordhere";//Password             var _servproxy = new OrganizationServiceProxy(new     Uri("https://Domain.api.crm5.dynamics.com/XRMServices/2011/Organization.svc"), n...
Read more

Meta Data Using WebApiRequest

-
////////////////Query Entity Metadata along with all attributes///////////// var url = req.open("GET", Xrm.Page.context.getClientUrl() + "/api/data/v8.2/EntityDefinitions(LogicalName='contact')/Attributes", false); /////////////////Entity Object Type code///////////////////////  req.open("GET", Xrm.Page.context.getClientUrl() + "/api/data/v8.0/EntityDefinitions?$filter=LogicalName eq '" + entityLogicalName + "'&$select=ObjectTypeCode", false); ////////////////////////////////////Querying single Field Metadata///////////////////// var url = req.open("GET", Xrm.Page.context.getClientUrl() + "/api/data/v8.2/EntityDefinitions(LogicalName='contact')/Attributes(LogicalName='firstname')", false); /////////////////Querying Relationships/////////////////// var url = req.open("GET", Xrm.Page.context.getClientUrl() + "/api/data/v8.2/RelationshipDefinitions(SchemaName...
Read more

Basic Plugin Code in D365 using C#

-
 using System; using Microsoft.Xrm.Sdk; using Microsoft.Xrm.Sdk.Query; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using Microsoft.Xrm.Sdk.Messages; using Microsoft.Xrm.Sdk.Metadata; namespace  apy.CWA.Arcese.Security {     public class PostOperationCreateQuote : IPlugin     {         public void Execute(IServiceProvider serviceProvider)         {             ITracingService tracingService = (ITracingService)serviceProvider.GetService(typeof(ITracingService));             IPluginExecutionContext context = (IPluginExecutionContext)serviceProvider.GetService(typeof(IPluginExecutionContext));             IOrganizationServiceFactory serviceFactory = (IOrganizationServiceFactory)serviceProvider.GetService(typeof(IOrganizationServiceFactory));           ...
Read more