I am trying to run a report that will pull info from the exam Record. ie Patient Name Date of Exam FieldID X FieldID Y FieldID Z
I found that if I run a schedule report and select "Send to Office" I get a prompt that asks "Are you including medical records in your document? (Including medical records will be slower.)" I ran the report and my field IDs were not listed. When I pulled the full records list from "Admin->MS Word->Generate Records Template File" and exported to that file the fields do not line up with their number. I believe that the problem stems from the use of commas to separate values in the export. Because the records fields include things like the case history the data contains commas which then offsets the field numbers.
ie if «MC_100» contains the text "Right eye, blurred vision" and «MC_101» contained "today" the output comes out as: «MC_100»: Right eye «MC_101»: blurred vision «MC_102»: today
The farther down the list you get, the more the data is offset by more commas.
Is there a fix to this or a way around it in order to run a report? Am I using the wrong report?
**Edit: The same problem exists using the "Correspondence Report" and trying to specify a field from Records.**
Last Edit: Oct 28, 2015 11:35:25 GMT -6 by Cluny: **Edit 2: The problem isn't comma delineation, as Kraig pointed out in another thread, fields are offset by a set number, 202.**