BLOGS
EASY SUBSCRIBE


Report Writing

Interoperability and EHR Optimization

Privacy and Security

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

SQL/SSRS/Data Repository tips, MEDITECH NPR Report Writer tips

Welcome to our Report Writing Blog!

Welcome to the Iatric Systems Report Writing Blog. This blog will be the new home to our monthly SQL/SSRS/Data Repository Tips, MEDITECH NPR Report Writer Tips, and Report Writing Tips for other platforms (Cerner, CPSI, Epic, McKesson), as well as a venue for sharing other report writing news and views.

Read More

Comments

0 COMMENTS