Appointments By Clinician with Ex GST Sales

Submitted by Matt C on Sun, 08/06/2008 - 16:32

Report

Category:

Sales

Version: 1.2 & 1.3

This report template lists all the scheduled visits or appointments for a vet/clinician along with a summary total of their sales for that period. Each clinician is shown on a seperate page. The report can be filtered by Start and End date.

Comments

Copying reports

Submitted by ahn (not verified) on Tue, 30/12/2008 - 20:59.

Hi all,

After just posting the pateint sterilisation report error, I have tried to install this one also and have come up with the error: "Column `activity_start_time' in where caluse is ambiguous"

I suspect that there is something wrong with how I am copying the code?

I have been clicking on the link to the attachment, then "saving the page as " using the mozilla task bar menu and saving in a folder on the server. Then adding a new template in Administration, selecting a report and setting it as financial and setting the admin level, clicking on the upload to browse the folder on the server.

Does anyone have any other ideas?

Amanda Hulands-Nave Bellarine Veterinary Practice

Appointments By Clinician

Submitted by ahn (not verified) on Tue, 30/12/2008 - 21:01.

Sorry typo :

Should read "....where clause is ambiguous"

Amanda Hulands-Nave Bellarine Veterinary Practice

Appointments By Clinician

Submitted by tony on Wed, 31/12/2008 - 08:08.

Hi Amanda,

You need to be careful here as many of these reports have been written for version 1.2 databases and you are running a 1.3 version which requires changes to the reports.

We need to highlight on the pages which ones are compatible with each version and where possible provide both versions as well .

Cheers

Tony