BLOGS
EASY SUBSCRIBE


Report Writing

Interoperability and EHR Optimization

Privacy and Security

SQL Tip: Returning Significant Digits

From time to time in your work in SQL from the DR, you’ll wind up CAST-ing or CONVERT-ing a number into a string. If that number starts as a DECIMAL or NUMERIC with a scale (the number of places of accuracy to the right of the decimal point) then you will wind up with something like this:

Read More

SSRS Tip: Adding A Tool to Clear the SSRS Data Cache

  • Ever change the logic in your query, confirm new data in SQL, run the report from SSRS… and get the old data?
  • Ever change the columns in your query, run the report from SSRS… and get a weird error – or just not get any data in the new column in the report, but you can see it in SQL?
  • Even if you click the Refresh button????
Read More

SSRS: The Report Issues Link to Report Issues with a Report

Despite all our best efforts, occasionally – rarely – perhaps inconceivably – there are problems with reports or extracts we create for our end users.

Read More

SQL: Finding the Smallest or Largest of a Fixed Set of Values

Recently while working a regulatory report I found myself faced with needing to identify the first (or earliest) of a set of dates. Each date came from a different possible order related to the patient visit, and I needed to chunk through 10 different JOIN-ed tables and get the one with the first / earliest date.

Read More

SQL Tip: To ISNULL() or not to ISNULL()

When we’re working on other people’s code – for troubleshooting or optimization purposes – we see a fair amount of usage of the ISNULL() function. Generally speaking we replace those ISNULL() references with COALESCE().

But why?

Read More

SQL Tip: Using a Date Dimension Table to Calculate Patient Days by Location

A very useful tool to have in your Data Repository toolbox is a Date Dimension table — which is a physical database table with one row per date from, say, 1900 through the end of 2499, and key elements pre-calculated about that date.

Read More

SQL Tip: Wrangling the SurCase_DocQuestions Table in MEDITECH 6.1

 

If you’ve been working with clinical documentation in the new SUR module in MEDITECH 6.1, you may have found that surgical interventions, assessments, query responses, and some standard fields are captured in this table:

Read More

Summer Webinars: Data Repository, NPR, 6.1 Reports Migration, and More

We’re pleased to offer several MEDITECH Report Writing webinars this summer, free to hospital employees. Register to attend any or all these presentations from the comfort of your own office on the dates noted below. Scroll down for registration links and a description of each webinar:

  • NPR and Report Designer Tips & Tricks
  • 6.1 Reports Migration
  • Make Data Repository Reports More Attractive & Functional
  • DR Resource CenterTM Demonstration
Read More

SSRS Tip: Control the Execution Order of SSRS Datasets

It may not be obvious when working in SQL Server Data Tools or Business Intelligence Development Studio, but when you add datasets to a SQL Server Reporting Services (SSRS) Report, they get an implied order of execution. Say you have a MEDITECH EDM dashboard, and it has some datasets that control parameter lists, and then two datasets that call stored procedures to get patient data and calculate median timings:

Read More

SQL Tip -- Multi-value Parameters for SSRS

Continuing on from last month, when you start building DR + SSRS reports to replace or supplement NPR or RD reporting, you lose some conveniences from direct MEDITECH integration.

Read More

Comments

0 COMMENTS