Software + Imagination
Visual Studio SSRS reports can be used to connect to the Dynamics CRM on premise SQL database. We will go through an example of how to do this. First, create a new Visual Studio project. Add a new report using the report wizard. Set the type to Microsoft SQL Server and the connection string to the CRM organization database: Select query builder: Enter a query, e.g. SELECT * FROM filteredaccount We … Continue reading Dynamics CRM SQL Reports
In order to edit SSRS reports in Visual Studio, you will need SQL Server Data Tools installed. First, go to the Microsoft Download website and find the link to your Visual Studio version. For example, for Visual Studio 2012, go to: https://www.microsoft.com/en-us/download/details.aspx?id=36843&wa=wsignin1.0 Once downloaded, install the application: Now, when you open Visual Studio, you will see new Business Intelligence options: Create a new Report Server project. Right click Reports and add an … Continue reading Editing SSRS Reports in Visual Studio
Dynamics CRM comes with pre-packaged reports. You can also create your own reports using SSRS. Here we will go through examples of doing this. Open Visual Studio. Ensure SQL Server Data Tools are installed and the Report Authoring Extensions are installed. Create a new report project: This will create a blank project: Right click Reports and add a new report: This will open the Report Wizard. Click Next: Enter the CRM connection … Continue reading Creating Dynamics CRM Reports with SSRS and Fetch XML
To create reports in SSRS for Dynamics CRM, you need to install the report authoring extension. To do this, download from the link below (Visual Studio 2012, CRM 2015): https://www.microsoft.com/en-us/download/details.aspx?id=45013 Run the EXE to extract the files: The wizard will open: Press Install: Click Next: Now, when you start Visual Studio you will see the option appear:
console.log allows for developers to write log events to certain web browsers. Here we will do a Hello World example using Chrome. First, create a new html document, and add the code: [sourcecode language=”javascript”] console.log("Hello World"); [/sourcecode] Open the document in Chrome and select F12 to open the developer tools. Go to the Console tab. You will now see the output: This logging can be useful in troubleshooting code. You … Continue reading JavaScript console.log Hello World
Below is a summary of the areas you can extend of Dynamics 365 and Power Apps. Area Purpose Notes Processes General term for allowing an organization to create processes specific to their business. These are created through the Dynamics 365 user interface, and include: Actions, Business Process Flows, Dialogs and Workflows. More details on each type below. Access under Settings->Processes Workflows A type of process created through the Dynamics 365 … Continue reading A Guide to Extending Dynamics 365 and Power Apps
To download the tool, go to:Â https://www.microsoft.com/en-us/download/details.aspx?id=45535 Run the exe. Click Continue: You will see: Now import the tool: Open the solution: You will then see any issues:
C# applications are often required to implement multithreaded functionality. Thanks to the .NET Framework, implementing threading is not difficult. In C# there are different ways we can create threads. Here we will look at using Thread. The Thread class is part of System.Threading. It is useful in that you can control many aspects of threads, such as whether to run in the foreground or background, the thread pool etc. We … Continue reading C# Thread()
In Dynamics 365, workflows can be run based on waiting for a time period to elapse given certain conditions. Here we will create a workflow that will send a reminder email for tasks to their owners when the task is due. Go to Processes and create a new workflow on the Task entity: Set the scope to Organization and the start to Created: Next, insert a new Wait condition step: … Continue reading Run Workflow at Set Time Period in Dynamics 365
When executing a plugin you may receive the error: “The plug-in execution failed because no Sandbox Hosts are currently available. Please check that you have a Sandbox server configured and that it is running.” If you get this, ensure under Services the Microsoft Dynamics CRM Sandbox Processing Service is running: