Using Templates in SQL reports

Using Templates in SQL reports

by Ashwini Borole -
Number of replies: 0

Hi,


I am trying to customize look-n-feel of the default report layout. I want to increase the width of table. With template, i could customize it.. but formatting is not up-to the mark. Attached layout with post


Below is the html code i have used.

Header

<table style="width=650 border=1">
<colgroup><col width="50">
<col width="100">
<col width="100">
<col width="100">
<col width="100">
<col width="100">
<col width="50">
<col width="50">
</colgroup><caption style="caption-side: top">Detailed Competency Report</caption>
<thead>
<tr>
<th scope="col">Department</th>
<th scope="col">Learning plan</th>
<th scope="col">Job role</th>
<th scope="col">Course name</th>
<th scope="col">Username</th>
<th scope="col">Activityname</th>
<th scope="col">Score</th><th scope="col">Completion date</th>
<th scope="col">Result</th>
</tr>
</thead>
<tbody><tr><td></td></tr></tbody></table>


Record:

<table width="650" border="1">
<colgroup><col width="50">
<col width="100">
<col width="100">
<col width="100">
<col width="100">
<col width="100">
<col width="50">
<col width="50">
</colgroup><tbody><tr>
    <td> department </td>
    <td> learningplan </td>
    <td> jobrole </td>
    <td> coursename </td>
    <td> username </td>
    <td> activityname </td>
    <td> score </td>
    <td> completiondate </td>
    <td> result </td>
</tr>
</tbody>
</table>


I wonder.. why table tag is required here... if i skip it.. i dont get error.. bt i even do not get table like view.. It would be great if anyone can correct me...


I would like to know more about the template usage. Can anyone redirect me to appropriate direction?


Thanks & Regards,

Ashwini.


Attachment layout.png
Average of ratings: Useful (1)