Click here to Skip to main content
15,905,963 members

Comments by kwgibson (Top 2 by date)

kwgibson 9-May-13 13:20pm View    
No body has anything?
kwgibson 2-May-13 14:05pm View    
Hopefully someone can point me in the right direction. Here is the XSLT.


<xsl:stylesheet version="1.0" exclude-result-prefixes="msxsl" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<user:data xmlns:user="user">
<datamodel name="Labor.WeeklySchedule"><fields>JobCodeName,FullName,Day1,Day2,Day3,Day4,Day5,Day6,Day7<filters><totals>
<sorting><sort field="JobCodeName" order="primaryascending"><sort field="LastName" order="secondaryascending">
<grouping><group field="JobCodeName" level="1">
<parameters><parameter field="ScheduleStartDate" prompt="true" /><parameter field="StoreName" prompt="true" /></parameters>

<version>1.0
<reportdescription>The Weekly Schedule displays a 7 day shift
grouped by job. Parameters: Store Name and schedule start date.
Fields Displayed: Job Category,End Time,Full Name,Start
Time,Store
<orientation value="horizontal">

<xsl:output method="html">
<xsl:template match="data">
<html>
<style type="text/css">div.col1{width:auto;left}div.col2{width:auto;left}div.col3{width:auto;left}div.col4{width:auto;left}div.col5{width:auto;left}div.col6{width:auto;left}div.col7{width:auto;left}div.col8{width:auto;left}div.col9{width:auto;left}</style>
<head>
<table class="report_header">
<tr>
<td class="title">test weekly schedule 2</td>
</tr>
<tr>
<td />
<td class="parameterlabel">
<div class ="col1" />
<xsl:value-of select="schedulestartdate/@displayas">
</td>
<td>
<div class ="col2" /><xsl:value-of select="schedulestartdate">
</td>
<td>
<div class ="col3" />
</td>
<td>
<div class ="col4" />
</td>
<td>
<div class ="col5" />
</td>
<td>
<div class ="col6" />
</td>
<td>
<div class ="col7" />
</td>
<td>
<div class ="col8" />
</td>
<td>
<div class ="col9" />
</td>
</tr>
<tr>
<td />
<td class="parameterlabel"><xsl:value-of select="storename/@displayas">:</td>
<td><xsl:value-of select="storename"></td>
</tr>
</table>
</head>
<body>
<table class="report_tabulardata">
<thead class="table_header">
<tr class="columnheader">
<xsl:apply-templates select="colheaders/colheader">
</tr>
</thead>
<tbody>
<tr class ="groupheadrow">
<xsl:apply-templates select="groups/group" mode="m1">
</tr>
</tbody>
</table>
</body>
</html>

<xsl:template match="colheader">
<tr class="columnheader">
<th>
<div class="col1">Job Name</div>
</th>
<th>
<div class="col2">Full Name</div>
</th>
<th>
<div class="col3">
<xsl:value-of select="@day1name">
</div>
</th>
<th>
<div class="col4">
<xsl:value-of select="@day2name">
</div>
</th>
<th>
<div class="col5">
<xsl:value-of select="@day3name">
</div>
</th>
<th>
<div class="col6">
<xsl:value-of select="@day4name">
</div>
</th>
<th>
<div class="col7">
<xsl:value-of select="@day5name">
</