app.start

[roelofwielinga]

Hi it's me again with my layout questions

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

Thanks again!
R.

[Support]

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.

[roelofwielinga]

I need to show the date of the treatment on the invoice.

[William]

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.

[roelofwielinga]

Great! Works like a charm!

[viodelin]

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!

[Mat Larkin]

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