Classic Report Table Design By HTML Expression

 


Step-1:

Create Classic Report.
SQL Query :

Select   EMPLOYEE_ID  ,  DEPARTMENT_ID  ,  FULLNAME  ,  EMAIL  ,  PHONE1  ,  PHONE2 ,  NID  ,  PERMANENT_ADDRESS  ,  PRESENT_ADDRESS  ,  BASIC_SALARY  ,  null X
From   EMPLOYEES 
WHERE EMPLOYEE_ID= 1003

Step-2:

Hide All Column Without Column.

Select Column.

HTML Expression :

<table 

border="0" width="100%" height = "50%" style="text-shadow: 2px 2px 5px #d0d0d0;border-left: 6px solid #32afa3;border-top: none;border-right: none;border-bottom: none;border-radius: 5px;border-collapse: collapse;padding: 0px 0px;margin-right: 0px;" cellpadding="4" cellspacing="4">

        <br>

<tr class="noBorder" style = "border: 1px solid gray;">

<td style="font-size:14px; text-align: right;">Emp ID :</td>

<td style="font-size:14px; font-weight: bold; text-align: left;border: 1px solid gray;">#EMPLOYEE_ID#</td>

<td style="font-size:14px; text-align: right;">DEPT ID : </td>

<td style="font-size:14px; font-weight: bold; text-align: left;border: 1px solid gray;">#DEPARTMENT_ID#</td>

<td style="font-size:14px; text-align: right;">NAME : </td>

<td style="font-size:14px; font-weight: bold; text-align: left;border: 1px solid gray;">#FULLNAME#</td>


<tr class="noBorder"  style = "border: 1px solid gray;">

<td style="font-size:14px; text-align: right;">Requisition Date  : </td>

<td style="font-size:14px; font-weight: bold; text-align: left;border: 1px solid gray;">#INV_REQ_DATE#</td>

<td style="font-size:14px; text-align: right;">Required Date : </td>

<td style="font-size:14px; font-weight: bold; text-align: left;border: 1px solid gray;">#INV_REQ_REQDATE#</td>

<td style="font-size:14px; text-align: right;">Item Code: </td>

<td style="font-size:14px; font-weight: bold; text-align: left;border: 1px solid gray;">#SLS_BATCH_SUBGRP#</td>


<tr class="noBorder"  style = "border: 1px solid gray;">

<td style="font-size:14px; text-align: right;">Request To  : </td>

<td style="font-size:14px; font-weight: bold; text-align: left;border: 1px solid gray;">#INV_REQ_USER#</td>

<td style="font-size:14px; text-align: right;">Submit To : </td>

<td style="font-size:14px; font-weight: bold; text-align: left;border: 1px solid gray;">#SLS_DEPOT_NM#</td>

<td style="font-size:14px; text-align: right;">Item Name: </td>

<td style="font-size:14px; font-weight: bold; text-align: left;border: 1px solid gray;">#ITEM_NM#</td>

        

</tr>

</table>


Post a Comment

Previous Post Next Post