Categories

Entries for the 'SQL Server BI' Category

DMC Achieves Microsoft’s Silver Business Intelligence Competency
Jessica Mlinaric

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 based on actionable business insight. DMC’s BI service offerings are geared towards helping clients identify and define high-level Key Performance Indicators (KPIs), design visually appealing dashboards, and complete technical data integration.&n...

Continue reading →


VB Script to Save an SSRS Report as a PDF
Jack Cosgrove

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 production batches run on that PLC. The customer desired these reports to be in PDF format, which after some investigation was easy to do with SSRS. A little background on SSRS... SSRS is a web application that generates nice graphical reports from SQL...

Continue reading →


Microsoft SQL Server Integration Services
Cesar Pena

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 easier way to do this. That is how I stumbled upon SQL Server Integration Services (SSIS). SSIS can do exactly what I needed. This tool is a component included in all versions of Microsoft SQL Server 2005 (except Express and Workgroup) that can handle dat...

Continue reading →


Editing Underlying Data in MS SQL Reporting Service (SSRS)
Boris Cherkasskiy

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, I wished it were possible to edit data viewed in the report, such as editing row comments. While it wasn’t possible to edit report data using the standard set of SSRS features, our team was able to find a way around this by creating a cust...

Continue reading →


Categories