Uncategorized Archives | Page 8 of 9 | Cloudfronts - Microsoft Dynamics 365 | Power BI | Azure - Page 8

Category Archives: Uncategorized

Creating Document Map in SSRS

Document Map makes navigation is easy to navigate through table in SSRS In our case we have dataset which contains Product and Product Subcategory. We created the 2 parent groups on Product key and Product Subcategory key. We have to go in the Parent group(ProductCategoryKey) >Advanced > Document Map and select the column used for … Continue reading Creating Document Map in SSRS

Share Story :

Entity Relationship Behavior in D365 CRM

Problem Statement: When a user changes the owner of Lead (either because the original owner has left the company or the lead is being assigned to a new salesperson), the system changes the owner on COMPLETED activities to the new owner of the record. This is a problem because it is important that we maintain … Continue reading Entity Relationship Behavior in D365 CRM

Share Story :

How to use Power BI with Web Data Source

Hello everyone, in this blog we will see how to connect Power BI with web as a data source.We will take moneycontrol.com ‘s data source for stock market analysis and we will generate a report based on it. Step 1: Go to get data source in Power BI desktop and select web as a data … Continue reading How to use Power BI with Web Data Source

Share Story :

How to avoid blank pages in SSRS report

How to avoid blank pages in SSRS reports Hi, guys in this article we will see the reasons that add blank pages in SSRS report and their solution, Body width: The body width of SSRS Report should be precise and should be maintained with following formula. Body width <= Report width – (Left margin + … Continue reading How to avoid blank pages in SSRS report

Share Story :

POS Receipts printing, Device connectivity issues in Microsoft D365 For Retail

Customers are looking for experiences when they go for shopping these days. They are not planning to use a particular store if they do not get the best experience. In contrast, if a store is providing the best service, customers are very much interested in visiting that store again. If you want to be a … Continue reading POS Receipts printing, Device connectivity issues in Microsoft D365 For Retail

Share Story :

Using For Each Loop in SSIS for Invoice Integration from SQL Server to Microsoft D365 Sales Using KingswaySoft Connector for CRM: Part 1

Part 1/4: Using FOR EACH Loop with KingswaySoft Connector for CRM Invoice Integration. Introduction: The SSIS ForEach Loop container will repeat the control flow task for N number of times, which is similar to Foreach loop in any programming language. This concept can be used for Integration of Header and Lines concept like Invoice. Our … Continue reading Using For Each Loop in SSIS for Invoice Integration from SQL Server to Microsoft D365 Sales Using KingswaySoft Connector for CRM: Part 1

Share Story :

ProTip: Running Multiple Registers on CPOS

Let’s say you need to create a new store with multiple registers on CPOS.   It is now possible to have a retail store with multiple registers each running CPOS and each having their own dedicated hardware.   For example: A store with two registers both running CPOS and both having their own receipt printer, … Continue reading ProTip: Running Multiple Registers on CPOS

Share Story :

How to Reset Page number in footer after Page break

In this blog, I shall explain how to reset page number in footer after page break. Steps: To reset page number on footer first add page break to the element in the SSRS report in the property window by right clicking on the element. Now click on the “add page break before” checkbox. Now Go … Continue reading How to Reset Page number in footer after Page break

Share Story :

Creating Custom Error Log Table in SSIS for OLEDB Block And Kingswaysoft Dynamics CRM Block

Introduction This log error will help us to understand and fix an issue as quickly. There are three main phases in an SSIS ETL execution life-cycle to catch errors: When data is being extracted from source systems When data is being transformed When data is loaded to the target systems Customized Error Handling also avoids … Continue reading Creating Custom Error Log Table in SSIS for OLEDB Block And Kingswaysoft Dynamics CRM Block

Share Story :

How to Create Balance Sheet and View Reports with Dimensions in D365 Business Central

In D365 Business Central there is no pre-defined Balance sheet/Income statement, because all these accounting statements can be viewed using Account Schedules. So, in this blog let’s see how we can create new Balance Sheet and how can we check the reports of Balance Sheet. 1.       Search for “Account Schedules” 2. Now, go to Balance … Continue reading How to Create Balance Sheet and View Reports with Dimensions in D365 Business Central

Share Story :