Blog

Entries for 'sql server bi'

Custom Data Logging from a Siemens PLC to Microsoft SQL Using VBScript

DMC worked on a project where we wanted to log data to a local Microsoft SQL server to be able to save and display it using Microsoft Report Designer. However, the standard format of Siemens’ data log did not match up with the schema ...


DMC Achieves Microsoft’s Gold Cloud Productivity Competency

DMC recently upgraded our Silver Cloud Productivity competency to Microsoft Gold for Cloud Productivity! This certification recognizes DMC for its expertise and experience helping clients deploy Microsoft cloud and hybrid solutions. Hy...


DMC Achieves Microsoft’s Silver Business Intelligence Competency

DMC is proud to announce that it has achieved Microsoft’s Silver Partner Status for Business Intelligence (BI) solutions. This achievement recognizes DMC’s proven ability to help customers monitor, analyze and plan business performance ba...


VB Script to Save an SSRS Report as a PDF

Reporting is almost a universal requirement for new projects coming into DMC these days. As part of an HMI we developed for a customer we also installed SQL Server Reporting Services (SSRS) on a Siemens PLC. This is used to generate reports for produ...


Microsoft SQL Server Integration Services

Recently I worked on a project where I needed to import test data from a chemical process contained in text files into a MS SQL Server database. I was about to start a C# .NET project to do this task, but I thought there has to be a quicker and easie...


Editing Underlying Data in MS SQL Reporting Service (SSRS)

In the past, DMC has used MS SQL Server Reporting Service (SSRS) on multiple projects as a web-based reporting engine. I personally liked using SSRS a lot because it allowed us to design quite complicated reports in very little time. At the same time...