Jump to content
Fórum Script Brasil
  • 0

Numerar Uma Tabela De Relatorio...


PRISCILA STOCHINI
 Share

Question

5 answers to this question

Recommended Posts

  • 0

Bom a minha ideia é assim...

Quero criar um relátorio no qual a cada cadastro incluido crie uma nova linha numerada sequancialmente.

Como posso fazer isso...no meu atual código..???

<body>
<div id="Layer1" style="position:absolute; left:10px; top:11px; width:990px; height:580px; z-index:1; overflow: auto;">
<form>
    <table width="190" border="1" align="center">
      <tr>
        <td><div align="center"><span class="style6"><a href="relacao.asp">Rela&ccedil;&atilde;o de Cursos </a></span></div></td>
      </tr>
    </table>
<% 
sql = "Select * From mini WHERE treinamento LIKE '%CONCRETO SP%' ORDER BY data DESC" 
Set rs = bco.Execute(sql)
if rs.eof then 
Response.Write("<p align=""center"">NÃO HÁ CADASTROS.</p>") 
else
%><p><input name="id" type="hidden" id="id" value="<%=rs("id")%>"></p>
    <table width="605" border="1" align="center" cellspacing="1" bordercolor="#CCCCCC">
    <tr>
      <td colspan="7"><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 16px; font-weight: bold">Relat&oacute;rio de Inscritos no Minicurso: <span class="style10">Concreto Armado</span></span></div></td>
    </tr>
    <tr>
      <td width="49"><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold">Data</span></div></td>
      <td width="147"><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold">Empresa</span></div></td>
      <td width="48"><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold">Contato</span></div></td>
      <td width="129"><div align="left"><span class="style11">Email</span></div></td>
      <td width="25"><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold">DDD</span></div></td>
      <td width="94"><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold">Tel</span></div></td>
      <td width="75"><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold">Confirma&ccedil;&atilde;o</span></div></td>
      </tr>
       <%
    rs.MoveFirst 
    Do While Not rs.eof
    %>
    <tr>
      <td nowrap="nowrap"><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;"><%=rs("data")%></span></div></td>
      <td nowrap="nowrap"><div align="left"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;"><%=rs("empresa")%></span></div></td>
      <td nowrap="nowrap"><div align="left"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;"><%=rs("contato")%></span></div></td>
      <td nowrap="nowrap"><div align="left"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;"><%=rs("email")%></span></div></td>
      <td nowrap="nowrap"><div align="left"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;"><%=rs("ddd")%></span></div></td>
      <td nowrap="nowrap"><div align="left"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;"><%=rs("tel")%></span></div></td>
      <td nowrap="nowrap"><div align="center">
        <div align="center"><a href="email_confirmacao.asp?id=<%=rs("id")%>" class="link02 style9">[Confirma]</a></div>
      </div></td>
      </tr>
   <%rs.MoveNext : Loop

rs.close
Set rs=nothing
bco.close
Set rs=nothing

End if
%>
  </table>
</form>
</div>
</body>

Link to comment
Share on other sites

  • 0
<body>
<div id="Layer1" style="position:absolute; left:10px; top:11px; width:990px; height:580px; z-index:1; overflow: auto;">
<form>
    <table width="190" border="1" align="center">
      <tr>
        <td><div align="center"><span class="style6"><a href="relacao.asp">Rela&ccedil;&atilde;o de Cursos </a></span></div></td>
      </tr>
    </table>
<% 
sql = "Select * From mini WHERE treinamento LIKE '%CONCRETO SP%' ORDER BY data DESC" 
Set rs = bco.Execute(sql)

if rs.eof then 
Response.Write("<p align=""center"">NÃO HÁ CADASTROS.</p>") 
else
%>
<p><input name="id" type="hidden" id="id" value=""></p>
    <table width="605" border="1" align="center" cellspacing="1" bordercolor="#CCCCCC">
    <tr>
      <td colspan="7"><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 16px; font-weight: bold">Relat&oacute;rio de Inscritos no Minicurso: <span class="style10">Concreto Armado</span></span></div></td>
    </tr>
    <tr>
        <td width="49"><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold">Id</span></div></td>
      <td width="49"><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold">Data</span></div></td>
      <td width="147"><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold">Empresa</span></div></td>
      <td width="48"><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold">Contato</span></div></td>
      <td width="129"><div align="left"><span class="style11">Email</span></div></td>
      <td width="25"><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold">DDD</span></div></td>
      <td width="94"><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold">Tel</span></div></td>
      <td width="75"><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold">Confirma&ccedil;&atilde;o</span></div></td>
      </tr>
       <%
   contado=0
    Do While Not rs.eof
        contador=contador+1
    %>
    <tr>
        <td nowrap="nowrap"><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;"><%=contador%></span></div></td>
      <td nowrap="nowrap"><div align="center"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;"><%=rs("data")%></span></div></td>
      <td nowrap="nowrap"><div align="left"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;"><%=rs("empresa")%></span></div></td>
      <td nowrap="nowrap"><div align="left"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;"><%=rs("contato")%></span></div></td>
   <td nowrap="nowrap"><div align="left"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;"></span></div></td>
      <td nowrap="nowrap"><div align="left"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;"></span></div></td>
      <td nowrap="nowrap"><div align="left"><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;"><</span></div></td>
      <td nowrap="nowrap"><div align="center">
        <div align="center"><a href="" class="link02 style9">[Confirma]</a></div>
      </div></td>
      </tr>
   <%
     rs.MoveNext 
     
     Loop


end if

%>
  </table>
</form>
</div>
</body>

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



  • Forum Statistics

    • Total Topics
      150.9k
    • Total Posts
      648.8k
×
×
  • Create New...