What’s going on with RDL?

I was thinking right now how was going on the different development around tools that generate RDL. Perhaps in the next Trivial Pursuit will appear Who designed Report Definition Language? and you should know it [:)] It is nice to see several projects/companies involved in this type of development, as the platform (RS) is so extensible. Some…

0

WordML in Reporting Services

Although Reporting Services is almost 22 months old, I haven’t found any pure render extension yet (please comment on this[:-*]). Many people ask me ‘how can I export reports in Microsoft Word format?’, and I usually redirect them to our BOL. But after looking up in the RS documentation, I realized that it is not…

4

AdW2KProducts.doc

<?xml version=”1.0″ encoding=”UTF-8″ standalone=”yes”?><?mso-application progid=”Word.Document”?> <w:wordDocument xmlns:w=”http://schemas.microsoft.com/office/word/2003/wordml” xmlns:wx=”http://schemas.microsoft.com/office/word/2003/auxHint“> <w:body>  <wx:sect>   <w:p>    <w:pPr>     <w:jc w:val=”center” />     <w:rPr>      <w:b />      <w:sz w:val=”28″ />      <w:sz-cs w:val=”28″ />     </w:rPr>    </w:pPr>    <w:r>     <w:rPr>      <w:b />      <w:sz w:val=”28″ />      <w:sz-cs w:val=”28″ />     </w:rPr>     <w:t>AdW2KProducts</w:t>    </w:r>   </w:p>   <w:p />   <w:tbl>    <w:tr>     <w:tc>      <w:tcPr>       <w:tcW w:w=”8856″ w:type=”dxa” />       <w:shd w:val=”clear” w:color=”auto” w:fill=”A6A6A6″ />      </w:tcPr>      <w:p>       <w:r>        <w:rPr>         <w:b />         <w:color w:val=”FFFFFF” />        </w:rPr>        <w:t>Name</w:t>       </w:r>      </w:p>     </w:tc>     <w:tc>      <w:tcPr>       <w:tcW w:w=”8856″ w:type=”dxa” />       <w:shd w:val=”clear” w:color=”auto” w:fill=”A6A6A6″ />      </w:tcPr>      <w:p>       <w:r>        <w:rPr>         <w:b />         <w:color w:val=”FFFFFF” />        </w:rPr>        <w:t>Color</w:t>       </w:r>      </w:p>     </w:tc>     <w:tc>      <w:tcPr>       <w:tcW w:w=”8856″ w:type=”dxa” />       <w:shd w:val=”clear” w:color=”auto” w:fill=”A6A6A6″ />      </w:tcPr>      <w:p>       <w:r>        <w:rPr>         <w:b />         <w:color w:val=”FFFFFF” />        </w:rPr>        <w:t>ListPrice</w:t>       </w:r>      </w:p>     </w:tc>    </w:tr>    <w:tr>     <w:tc>      <w:tcPr>       <w:tcW w:w=”8856″ w:type=”dxa” />      </w:tcPr>      <w:p>       <w:r>        <w:t>men’s sports…

1

transform01.xsl

<?xml version=”1.0″ encoding=”utf-8″ standalone=”yes”?><xsl:stylesheet version=”1.0″ xmlns:xsl=”http://www.w3.org/1999/XSL/Transform” xmlns:w=”http://schemas.microsoft.com/office/word/2003/wordml” xmlns:wx=”http://schemas.microsoft.com/office/word/2003/auxHint“> <xsl:output method=”xml” media-type=”text/xml” standalone=”yes” omit-xml-declaration=”no” encoding=”UTF-8″/> <xsl:template match=”/”> <xsl:processing-instruction name=”mso-application”>  <xsl:text>progid=”Word.Document”</xsl:text> </xsl:processing-instruction>  <w:wordDocument>    <w:body>     <wx:sect>      <xsl:apply-templates/>     </wx:sect>    </w:body> </w:wordDocument></xsl:template> <xsl:template match=”Report”> <w:p>  <w:pPr>   <w:jc w:val=”center”/>   <w:rPr>    <w:b/>    <w:sz w:val=”28″/>    <w:sz-cs w:val=”28″/>   </w:rPr>  </w:pPr>  <w:r>   <w:rPr>    <w:b/>    <w:sz w:val=”28″/>    <w:sz-cs w:val=”28″/>   </w:rPr>   <w:t><xsl:value-of select=”@Name”/></w:t>  </w:r> </w:p> <w:p/> <w:tbl>    <w:tr>     <w:tc>      <w:tcPr>       <w:tcW w:w=”8856″ w:type=”dxa”/>       <w:shd…

1

AdW2KProducts.rdl

<?xml version=”1.0″ encoding=”utf-8″?><Report xmlns=”http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition” xmlns:rd=”http://schemas.microsoft.com/SQLServer/reporting/reportdesigner“>  <rd:GridSpacing>0.25cm</rd:GridSpacing>  <RightMargin>2.5cm</RightMargin>  <Body>    <ReportItems>      <Table Name=”table1″>        <Height>1.90476cm</Height>        <ZIndex>1</ZIndex>        <Style />        <Header>          <TableRows>            <TableRow>              <Height>0.63492cm</Height>              <TableCells>                <TableCell>                  <ReportItems>                    <Textbox Name=”textbox2″>                      <Style>                        <PaddingLeft>2pt</PaddingLeft>                        <BackgroundColor>IndianRed</BackgroundColor>                        <TextAlign>Center</TextAlign>                        <PaddingBottom>2pt</PaddingBottom>                        <PaddingTop>2pt</PaddingTop>                        <PaddingRight>2pt</PaddingRight>                        <FontWeight>700</FontWeight>                      </Style>                      <ZIndex>8</ZIndex>                      <rd:DefaultName>textbox2</rd:DefaultName>                      <CanGrow>true</CanGrow>                      <Value>Name</Value>                    </Textbox>                  </ReportItems>                </TableCell>                <TableCell>                  <ReportItems>                    <Textbox Name=”textbox3″>                      <Style>                        <PaddingLeft>2pt</PaddingLeft>                        <BackgroundColor>IndianRed</BackgroundColor>                        <TextAlign>Center</TextAlign>                        <PaddingBottom>2pt</PaddingBottom>                        <PaddingTop>2pt</PaddingTop>                        <PaddingRight>2pt</PaddingRight>                        <FontWeight>700</FontWeight>                      </Style>                      <ZIndex>7</ZIndex>                      <rd:DefaultName>textbox3</rd:DefaultName>                     …

1

Starting again

Hi, Let’s try to write about what I read, see or think. First, I work at IW MCS Team at Spain, so I’ll write about Office development and RS, although I love many other stuff. I was searching time ago apps/tools in order to manage Word documents at the server, as you perhaps know Microsoft Office were…

2