BLOGS
EASY SUBSCRIBE


Report Writing

Interoperability and EHR Optimization

Privacy and Security

T-SQL: XML from SQL, Managing Escaped Characters

T-SQL contains within it a module which lets you generate XML data directly from SQL. No concatenating strings or building the XML layout by hand required!

Read More

T-SQL: Formatting Numbers and Dates with FORMAT vs. CONVERT

Over the (relatively) long history of T-SQL and SQL Server, when we (as programmers) needed to format a date or a number inside our SQL we primarily had access to two commands:

Read More

T-SQL : Using AGENT_DATETIME with SYSJOBHISTORY

In the course of working with the DR, you’re going to wind up setting up scheduled jobs through SQL Agent, and – inevitably – you’re going to want to calculate job durations to see what is running long, perhaps unexpectedly so.

Read More

SSRS: Using Parameters to Add Documentation to a Report

In certain situations, it may be desirable to make additional documentation available to the user at runtime. SSRS parameters can be leveraged for this purpose.

Read More

SSRS: Conditionally Set Visibility of Group Based on Group Count

On occasion there is a need for rows on a report to be conditionally hidden or visible based upon an expression that is determined when the report is run.  One example of this type of functionality can be shown within a report displaying the assessments for a patient. Each of the assessments can have a set of questions attached. 

Read More

T-SQL: Using Dense _RANK vs ROW_NUMBER with NUR Queries

This tip is a shout-out to all the reporting folks still working with MEDITECH C/S or Magic from the DR! However, the concepts we’re going to explore apply to 6.x and Expanse as well as any other system where you need to group sets of values and then select one group.

Read More

SSRS Tip: Referencing Values from Calculated Fields on a Report

Every so often we need to build a report with a number of complicated calculations that we need to perform at the detail, group or summary level in the report. Maybe we need to calculate some aggregates, then do calculations on the aggregates. Like creating percentage markers for sums of numbers, from multiple groups.

Read More

SSRS Tip: Using wildcards in Report parameters

Searching and filtering free text data can be a problem due to human error. Typos, transposed characters and even data entry into the wrong field present a challenge when trying to report on the data. In a SQL query we can use LIKE and wildcards to try to work around these issues.

Read More

SQL Tip: Improving the Speed of ALL

We recently undertook a project for a customer where we reviewed the top X reports (in terms of usage as logged in SSRS) for performance optimization. Some of their heavy hitters were tying up a lot of DR resources, and slowing things down for everyone.

Read More

SQL Tip: Using SourceID in #Temp tables

Because SourceID is part of the primary key in virtually all MEDITECH Data Repository tables, it is good practice to include SourceID as the first column all indexes, include it in all joins and to identify SourceID in the WHERE clause of the query. In most cases this will cause SQL Server to use an index seek instead of an index scan and greatly improve performance.

Read More

Comments

0 COMMENTS