BLOGS
EASY SUBSCRIBE


Report Writing

Interoperability and EHR Optimization

Privacy and Security

Thomas Harlan, Reporting Services Team - iatricSystems

Thomas is the Technical Team Lead, Data Repository at iatricSystems. Thomas has been a report writing consultant with iatricSystems™ since 2012. Before joining iatricSystems, his IT positions ranged from programmer to manager to Chief Technology Officer. He has more than 20 years of SQL experience, as well as more than 15 years of clinical and business reporting experience, extracting data from a variety of HIS systems.

T-SQL- Constructing NPR Database Source ID’s per Facility

Essentially every table that you access in the Meditech DR has a SourceID field embedded as part of the primary key. If you are a single facility system, you generally wind up having only a single value for your SourceID across all tables and modules.

Read More

T-SQL- Constructing a GL Account string from a BAR payment or adjustment (MT 6.15+)

As you work with Meditech BAR 6.15, you may find yourself needing to identify the GL Account that a payment or adjustment posts to. And then… you find that the appropriate field in the non-charge procedure dictionary has a dynamic string definition stored in it, instead of a specific GL Account number.

Read More

T-SQL: Managing Significant Digits

As you work with calculations in SQL, eventually you’re going to get caught up (particularly when trying to output the data to a file, for a vendor) by the T-SQL rules around maintaining a proper number of significant digits in the results of a calculation. Generally speaking, SQL does not want to lose any validity in the data, so it is going to expand the number of significant figures to “keep” everything.

Read More

SQL Server Reporting Services: Dealing with Hidden Columns in Export

One of the upsides / downsides of deploying SQL Server Reporting Services to your customers is that it allows them to Export data from a published report (or a subscription to a report) to a file. You can also send the data by email, though that functionality is disabled by default.

Read More

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

Comments

0 COMMENTS