Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #31162
    roelofwielinga
    Participant

      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.

      #32595
      Support
      Keymaster

        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.

        #32596
        roelofwielinga
        Participant

          I need to show the date of the treatment on the invoice. :-({|=

          #32597
          William
          Keymaster

            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:

            ,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:

            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.

            #32598
            roelofwielinga
            Participant

              Great! Works like a charm!

              #32599

              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!

              #32600

              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

            Viewing 7 posts - 1 through 7 (of 7 total)
            • You must be logged in to reply to this topic.