Displaying Midweek Assignment in a Grid

[ajtruckle]

Here is a simple report that displays all assignments for the Midweek meeting (excluding students) in a table like grid:

Sample Script File
This script can be downloaded as a compressed (ZIP) file that includes these essential components:

1. Template (XSL File): This file's name will appear in the drop-down list within the Meeting Editor.
2. Stylesheet (CSS File): This file contains all the styling for the report.

Download:
Workbook-S-140-Grid

File	Filename
Template	Workbook-S-140-Grid.xsl
Stylesheet	Workbook-S-140-Grid.css

Installing the Script File (ZIP)

To install the script file, follow these steps:

1. Open Meeting Editor: Navigate to the Meeting Editor and click on the "Workbook" tab in the right panel.
2. Click Import Style: Press the Import Style button.
3. Select Workbook File Type: From the list, choose "Workbook ZIP" as the file type and locate the ZIP file you downloaded.
4. Click Open: The script will now appear in the Style drop-down list

Copying to Excel

It is very easy to copy / paste this report into other applications, like Microsoft Excel:

Translations

The column headings can be translated if required (lines 54 to 97):

<thead>
	<td>
		<xsl:text>Date</xsl:text>
	</td>
	<td>
		<xsl:text>Chairman</xsl:text>
	</td>
	<td>
		<xsl:text>Counsellor</xsl:text>
	</td>
	<td>
		<xsl:text>Prayer Open</xsl:text>
	</td>
	<td>
		<xsl:text>Treasures</xsl:text>
	</td>
	<td>
		<xsl:text>Gems</xsl:text>
	</td>
	<td>
		<xsl:text>Discussion 1</xsl:text>
	</td>
	<td>
		<xsl:text>Discussion 2</xsl:text>
	</td>
	<td>
		<xsl:text>Living 1</xsl:text>
	</td>
	<td>
		<xsl:text>Living 2</xsl:text>
	</td>
	<td>
		<xsl:text>Living 3</xsl:text>
	</td>
	<td>
		<xsl:text>CBS Conductor</xsl:text>
	</td>
	<td>
		<xsl:text>CBS Reader</xsl:text>
	</td>
	<td>
		<xsl:text>Prayer Close</xsl:text>
	</td>
</thead>