I have a rather simple report built in the reports module on our test server.. Just trying to insert a single patientVisitID into a table called cus_Ahlers_Exclusions, and here are the details:
There is a single control in design view under interface:
name: VISITID Type: Text
Under the runtime section, there are no parameters & formulas to worry about
The report query is:
Select PatientVisitID from Cus_Ahlers_Exclusions where PatientVisitID=?VISITID.TEXT?
The update query is the point of the whole thing, just trying to insert the value like so:
INSERT INTO
Cus_Ahlers_Exclusions (PatientVisitId) VALUES (?VISITID.TEXT?)
Unfortunately, When I preview I get this error:
"the RPT fle is corrupted or the report output is too large. First verify that you have criteria to limit the report then print or preview the report again. If the application is still unable to generate the report, contact your system administrator to obtain a backup of the RPT file"
Read only.