Visualiser Issues - Reports Module [Lead: Andrew Nurse]

Forum DotNetNuke® Pro... Reports Module ... Visualiser Issues

9/19/2007 7:02 PM

	Edmedia
128 posts
www.edmedia.com.au

Visualiser Issues

a few questions:

First: how do I create a report that displays a new record in each cell of a table.. for instance currently if I do this

[FieldName] [FieldName]

it returns this

result1 result1

result2 result2

result3 result3

but what I need is this

result1 result2

result3 result4

result5 result5

how do I do it??

Second question does the HTML file automatically use the skin CSS?

if not how do I connect the CSS in a similar manrrer as using the <%=skinpath%>?

Third question how do I link images fron the portal root file/folder to the transformed HTML page?

Fourth Question does the HTML page only need the tags between to body tags or does the uploaded HEML file need to be a fully taged page: <html><head></head><body></body></html> etc..?

thanks

9/24/2007 10:20 PM

	Edmedia
128 posts
www.edmedia.com.au

Re: Visualiser Issues

Just putting this question back on top..I still need an answer

regards

9/25/2007 12:10 AM

	Andrew Nurse
366 posts

Re: Visualiser Issues

1) The HTML Visualizer does not support this in the current version. The more powerful XSLT Visualizer should be able to do what you need. If you are running the most recent version of Reports, you can see a sample of the XML that is passed to the stylesheet provided in the Visualizer by going to the Module Settings page and selecting "Show Xml Source". I don't know a lot about XSLT but maybe others can provide more details, or there are plenty of XSLT resources out on the web.

2) It should, it is basically injected into the page, so it will use all the CSS files applied to that particular page

3) You'll have to use relative urls, using the DesktopModules/Reports folder as a base, so to get back to the root you prefix your url with '../../'. For example (~/Portals/0/images/foo.gif => ../../Portals/0/images/foo.gif). This may be updated in a future version

4) Just the content between the body tags.

Andrew Nurse
DotNetNuke Core Team Member and Reports Module Project Lead
Microsoft Certified Professional Developer

9/25/2007 8:54 PM

	Edmedia
128 posts
www.edmedia.com.au

Re: Visualiser Issues

Andrew thanks for the reply. Ive sorted out how to do what I want in XSL (outside of DNN) but dont know how to attach the DNN data source to the XSL?

This is what I'm doing

<?xml version="1.0" encoding="utf-8"?>

<!DOCTYPE xsl:stylesheet [
<!ENTITY nbsp   " ">
<!ENTITY copy   "©">
<!ENTITY reg    "®">
<!ENTITY trade "™">
<!ENTITY mdash "—">
<!ENTITY ldquo "“">
<!ENTITY rdquo "”">
<!ENTITY pound "£">
<!ENTITY yen    "¥">
<!ENTITY euro   "€">
]>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="html" encoding="utf-8"/>
<xsl:include href="FillerCells.xsl"/>

<xsl:variable name="cellsPerRow" select="3"/>
<xsl:variable name="imageWidth" select="120"/>
<xsl:variable name="imageHeight" select="160"/>
<xsl:template match="/">

</xsl:template>

<xsl:template match="DocumentElement">
<xsl:for-each select="QueryResults[position() mod $cellsPerRow = 1]">
  <tr>
  <xsl:apply-templates
   select=".|following-sibling::QueryResults[position() < $cellsPerRow]"/>
  </tr>
</xsl:for-each>
</xsl:template>

<xsl:template match="QueryResults">
<td class="PhotoCell" align="center">


    <div align="center" class="CareerButtons">

<table border="1" cellspacing="0" cellpadding="0">
<tr>
    <td width="8px" class="BL_ButtonLeft"></td>
    <td class="BL-buttonLable_BG">

           <a class="ButtonLink"><xsl:attribute name="href">../default.aspx?tabid=<xsl:value-of select="TabID" /></xsl:attribute><xsl:value-of select="TabName" /></a>

    </td>
    <td width="7px" class="BL_ButtonRight"></td>
</tr>
</table>

</div>


  <br clear="all"/>
  </td>
<xsl:if test="(position() = last()) and (position() < $cellsPerRow)">
  <xsl:call-template name="FillerCells">
   <xsl:with-param name="cellCount" select="$cellsPerRow - position()"/>
  </xsl:call-template>
</xsl:if>
</xsl:template>

</xsl:stylesheet>

But when I try to use it in DNN I get the following error

For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method.

i have no Idea what that mean and how to fix it..

So how do I pass the DNN datasource to my XLS?
Can I use the XSL in DNN reports that way I'm doing it?
How do I fix the DTD issue/? or is it caued by the other problems?

regards

9/25/2007 10:27 PM

	Stefan Cullmann
1572 posts

Re: Visualiser Issues

You don't need to pass the data, you don#t need to define any XMLSource/ data island etc in your stylesheet.
I am not sure whether the inculde is allowed inside reports, and you need to remove the DTD entity definition.
All other code looks fine and should work if it matches the XML source
Remove
<!DOCTYPE xsl:stylesheet [
<!ENTITY nbsp   " ">
<!ENTITY copy   "©">
<!ENTITY reg    "®">
<!ENTITY trade "™">
<!ENTITY mdash "—">
<!ENTITY ldquo "“">
<!ENTITY rdquo "”">
<!ENTITY pound "£">
<!ENTITY yen    "¥">
<!ENTITY euro   "€">
]>
Use   instead of   inside your XSL script... I don't see any use of these entities in this part of the script, though it may be used in your include "FillerCells.xsl".

Stefan Cullmann - stefan.cullmann [at] dotnetnuke.com
form and List will be the successor of the User Defined Table module.
----------------------------------------------------------------------
Do you want to import external data to form and List /User Defined Table?
Check out http://www.codeplex.com/Csv2UDTImport

Page 1 of 1

Forum

DotNetNuke® Pro...

Reports Module ...

Visualiser Issues