Skip to Content

Absence Quota calculation


I had made a report with smartform showing absence quota of selected employees from the selection criteria but there is one problem while calculating earned leave.

In this company every year two times balance is increased by 15 days for Earned leaved i.e. in January and in June.

So there will be two enteries of EL in the database table


And i want to show in my report that till date the EL balance is x and the employee has used y in the <b>current year(date entered)</b> and remaining balance is x-y=z in one single row in smartform.

My smartform looks like this


Employee Name


Date of join

Entitled Availed Remaining

CL 12 2 10

EL 130 23 107

SL 95 0 95

From To Leave Nature No. of Days Balance

18/02/05 22/02/05 EL 5 125

04/03/05 04/03/05 CL 1 11

Please help me out How this is possible,

Thanks in advance,

Bharat Mistry.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 11, 2005 at 05:11 AM


    use the table control in the smartforms

    you can do it in two ways

    in the internal table you can manipulate all these things and pass it to the smartform.

    or in the smartform itself insert program lines and do the manipulations and display the output

    if you're not clear explain your probs bit clear



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.