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.

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

Comments

0 COMMENTS