Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsReportsReportspasso a passo Módulo Reports HTML (portugues - Brasil)passo a passo Módulo Reports HTML (portugues - Brasil)
Previous
 
Next
New Post
1/22/2010 1:37 PM
 

 

Manual módulo reports (HTML)
 logado como host
1)      HOST > HOST SETTINGS >OTHER SETTINGS > ALLOWABLE FILE EXTENSION:
·         Adicionar na caixa as extensões HTM, HTML e clicar em  update
(obs.: ao fazer update verificar se Host Email é valido. Pois o email padrão não é valido e é um campo obrigatório )
 
2)      Adicionar na pagina o modulo REPORTS e ir no seguinte caminho:
SETTINGS > REPORT SETTINGS > DATA SOURCE SETTINGS >QUERY
·         Colocar a query na qua lira trazer as informações desejadas
(ex. SELECT * FROM users)
·         Clicar em SHOW XML SOURCE e OK, se sua query estiver correta ira montar um XML da seguinte forma:
<DocumentElement>
<QueryResults>
                       <UserID>1</UserID>
                 <Username>host</Username>
                        <FirstName>SuperUser</FirstName>
                       <LastName>Account</LastName>
                       <IsSuperUser>true</IsSuperUser>
                       <Email>host@change.me</Email>
                       <DisplayName>SuperUser Account</DisplayName>
                       <UpdatePassword>false</UpdatePassword>
                       <LastIPAddress>187.75.193.36</LastIPAddress>
                       <IsDeleted>false</IsDeleted>
                       <CreatedByUserID>-1</CreatedByUserID>
                       <CreatedOnDate>2009-12-09T15:37:37.577-02:00</CreatedOnDate>
                       <LastModifiedByUserID>-1</LastModifiedByUserID>
                       <LastModifiedOnDate>2010-01-22T15:21:42.55-02:00</LastModifiedOnDate>
      </QueryResults>
</DocumentElement>
 
Cada nó que esta dentro do nó pai QueryResults  desse XML é nome de um campo na tabela, e será usada para montarmos o nosso modelo de HTML.
(EX. UserID, Username, FirstName, LastModifiedOnDate)
 
3)      Abra o seu FrameWork (Visual Studio , Dreamwever e etc) e desenvolva o HTML da forma que você deseja exibir suas informações, lembrando que o nome dos campos devera ficar entre colchetes ( ] ) da seguinte forma Ex:
 
<table>
    <tr>
        <td rowspan="2">
            [UserID]
        </td>
        <td>
            [Username]
        </td>
        <td>
            [FirstName]
        </td>
        <td>
            [LastName]
        </td>
    </tr>
    <tr>
        <td>
            [IsSuperUser]
        </td>
        <td>
            [Email]
        </td>
        <td>
            [DisplayName]
        </td>
    </tr>
</table>
Esse HTML será repetido em todos os registros em loop.
Após finalizar o seu HTML salve-o e volte a seu projeto.
4)      Abra a pagina que se encontra o seu módulo REPORTS, vá em:
SETTINGS > REPORT SETTINGS > Display and Caching Settings > TEMPLATE FILE > FILE NAME > UPLOAD NEW FILE > PROCURAR
Selecione o arquivo HTML que criou e clique em UPLOAD SELECTED FILE, caso apareça a mensagem :
The File .mpe Is A Restricted File Type. Valid File Types Include ( *. swf, *.jpg, *.jpeg, *.jpe, *.gif, *.bmp, *.png, *.doc, *.xls, *.ppt, *.pdf, *.txt, *.xml, *.xsl, *.css, *.zip ). Please Contact Your Hosting Provider If You Need To Upload A File Type Which Is Not Supported.
                Faça o passo 1 novamente, caso contrario seu relatório estará pronto
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsReportsReportspasso a passo Módulo Reports HTML (portugues - Brasil)passo a passo Módulo Reports HTML (portugues - Brasil)


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.

Copyright 2014 by DNN Corp | Terms of Use | Privacy | Design by Parker Moore Design