has anyone had any success generating custom reports merging multiple tables within the SQL database? I have used the export/search function in v5.0 but need a more expansive method to pull the custom report data. I hoped to use the SDK help file but that documentation was sparse.
I need to merge demographics, encounter billing information (EMLineitem, superbill, superbillaccount), with the CPT and ICD9 tables to generate the report to send to my billing company. An especially important field is the SavedDate field within EMLineitem as this allows me to filter just those encounters that need to be billed for a certain period of time.
