app.start

Help with reports & document templates
Post a reply

app.start

Postby roelofwielinga » November 19th, 2010, 10:55 pm

Hi it's me again with my layout questions :mrgreen:

with what line do I use 'app.start' to show the day of the treatment on the invoice?

Thanks again!
R.
http://www.osteopraktijk.nl
User avatar
roelofwielinga
 
Posts: 193
Joined: May 22nd, 2010, 3:04 pm
Location: Amsterdam
  • Website
Top

Re: app.start

Postby Support » November 22nd, 2010, 10:47 pm

Unfortunately, it's not as simple as just entering "app.start" somewhere on the report.

The SQL Source needs to be altered to link the appointment table to the invoice. Please explain in full detail which report you're working with and exactly what you're trying to achieve and we'll do our best to help.
ClinicOffice Support Team
User avatar
Support
Site Admin
 
Posts: 874
Joined: August 25th, 2005, 6:37 pm
Top

Re: app.start

Postby roelofwielinga » November 26th, 2010, 9:17 pm

I need to show the date of the treatment on the invoice. :-({|=
http://www.osteopraktijk.nl
User avatar
roelofwielinga
 
Posts: 193
Joined: May 22nd, 2010, 3:04 pm
Location: Amsterdam
  • Website
Top

Re: app.start

Postby William » December 2nd, 2010, 2:48 pm

Hi

Thanks for explaining which report you wish to insert the appointment start field into.

Enter into the Report Source. Above the from inv line and just after the last statement insert the following:

Code: Select all
,app.start as appt_date


Below the from inv line is a list of left joins. Left click at the end of the last left join and press the Enter key. Type in the following:

Code: Select all
left join app on (app.id=inv.app_id)


Click OK when you have done this.

You will now be able to insert the appt_date value into the invoice report. Please make sure that when you insert the appt_date you change it to a date format within the design editor if you only want the date to appear for the appointment.

Hope this helps.
ClinicOffice Support Team
User avatar
William
 
Posts: 159
Joined: November 1st, 2007, 8:52 am
Top

Re: app.start

Postby roelofwielinga » March 6th, 2011, 12:43 am

Great! Works like a charm!
http://www.osteopraktijk.nl
User avatar
roelofwielinga
 
Posts: 193
Joined: May 22nd, 2010, 3:04 pm
Location: Amsterdam
  • Website
Top

Re: app.start

Postby viodelin » July 24th, 2014, 1:55 pm

Hello,
Me again - I have follow these instructions but no joy
The place where the appointment date should go comes out blank :(
Can you help?
Thanks!
viodelin
 
Posts: 8
Joined: July 10th, 2014, 5:51 pm
Top

Re: app.start

Postby Mat Larkin » July 28th, 2014, 9:55 am

Hi there,

When you go into the Design Template mode, please make sure that the report data for the appointment date field is pointing at the app.start data.

I notice that you're on our ClinicOffice support Plan, so please feel free to call our helpdesk and we'll be happy to help further by logging onto your screen to show you how to do this.

Thanks
ClinicOffice Support Team
User avatar
Mat Larkin
 
Posts: 202
Joined: January 11th, 2010, 11:27 am
Top


Post a reply

Return to Reports & Templates

Who is online

Users browsing this forum: No registered users and 3 guests