We have two unique EMRs, both of which use SQL for data storage--we are looking at providing dashboard reporting for other end users. Right now, we do a combination of Crystal Reports that farm out via automated emails--which works but is a bit cumbersome if new users would like the report, reports change, etc.
Ideally, we would like a dashboard where SQL Queries/Reports can be uploaded/built--then an end user can be assigned rights/services to access those reports. It would be more granular and easier to update.
Our EHR systems offer unique dashboards for each--but both are $$ and then we ended up with two different platforms.
Does anyone use SQL Dashboard Software they would recommend? I'd prefer to stay away from the Periscope/Cloud platform if possible.