Layout based forms reporting

dkdipak1 wrote on Friday, December 16, 2016:

Hi,
I have created a LBF to track the requsttion# from sales man and their requistion# for each visit. but when I see in DB, there is no pt ID or visit ID associated with it? Is there any way I can get Pt ID there any other sugesstion to get report from there?
Thanks
D

bradymiller wrote on Saturday, December 17, 2016:

Hi,

This information will be mapped in the forms table(form_id in lbf_data and form_id in forms).

-brady
OpenEMR

dkdipak1 wrote on Sunday, December 18, 2016:

Thanks for the information. But How shall i join form ID to pid to run a report

bradymiller wrote on Monday, December 19, 2016:

Hi,
The patient Report will show forms/encounters (Report link at top of patient summary page). If need to produce report for multiple patients then would likely require minimal coding/development.
-brady
OpenEMR