Eclipse Community Forums: BIRT » Table x-axis

Messages: 25
Registered: September 2009

Junior Member

Hi.
I have created a table where the x-axis is computed as:
BirtDateTime.weekDay(row.[Date],4)

This returns Monday, Tuesday .... but they are displayed on the x-axis according to their alphabetical order:
Friday, Monday, Saturday, Sunday, Thursday, Tuesday, Wednesday.
I would like them to be ordered by their time sequence (Sunday, Monday, Tuesday...).

In the "Format Chart" tab the x-axis type is text, origin is value and value is 0.
If I change x-axis type to datetime, then I have the following error:
Chart NewChart1:
+ Unable to use a text data to render a numerical/datetime axis.

As a possible solution can I manually set the order for each weekday?

Thanks.
Michele

Re: Table x-axis - Weekday Sorting [message #488677 is a reply to message #488590]

Tue, 29 September 2009 17:18

Messages: 9167
Registered: July 2009

Senior Member

Michele,

There are a couple of ways of doing this.
First complex way:

Using an after datset filled script you can re-arrange the datapoints by
getting the dataset

var list = dataSet.getValues();
list.sort();

The only issue is that this gets called for the category dataset and
each of the values datasets. So if you have one series with these values

Monday - 55
Tuesday - 67
Wednesday - 35

The first time the script is called the list will contain
Monday
Tuesday
Wednesday

The second time it is called the list will contain
55
67
35

So if you change the order in one of the JavaScript arrays you will need
to do it in both. You can name your series on the third tab of the
chart wizard and look for the name in the script

series.getSeriesIdentifier()

To check for the category series use this:
if( series.getSeriesIdentifier() == "" ){
}

Easier Way:
Select the unsorted on the second tab of the wizard, which will process
the data how it comes in. Add a table above the chart that is bound to
the same dataset your chart uses. Name the table. Select the chart and
change its binding to point to a report item instead of a dataset.
Point it at the table you created. Set the visibility on the table to
be hidden always. Select the table and click on the sorting tab and
enter a sort expression that you want to use for the key. Something like:

if( row["cat"] == "Monday" ){
1;
}else if( row["cat"] == "Tuesday"){
2;
}else if( row["cat"] == "Wednesday"){
3
}else if( row["cat"] == "Thursday"){
4;
}else if( row["cat"] == "Friday"){
5;
}

Jason

Michele wrote:
> Hi.
> I have created a table where the x-axis is computed as:
> BirtDateTime.weekDay(row.[Date],4)
>
> This returns Monday, Tuesday .... but they are displayed on the x-axis
> according to their alphabetical order:
> Friday, Monday, Saturday, Sunday, Thursday, Tuesday, Wednesday.
> I would like them to be ordered by their time sequence (Sunday, Monday,
> Tuesday...).
>
> In the "Format Chart" tab the x-axis type is text, origin is value and
> value is 0.
> If I change x-axis type to datetime, then I have the following error:
> Chart NewChart1: + Unable to use a text data to render a
> numerical/datetime axis.
> As a possible solution can I manually set the order for each weekday?
>
> Thanks.
> Michele

Re: Table x-axis - Weekday Sorting [message #488772 is a reply to message #488677]

Wed, 30 September 2009 08:44

Messages: 25
Registered: September 2009

Junior Member

Hi Jason.

I've tried the "Easy way" but got stuck.

My chart was already nested into a table - visible - which was linked to the dataset (keywords).

When I built the chart I linked the chart to the dataset (keywords).
I had a look at the option on the second tab of the chart in order to change "Select data"|"Use Data From" from my dataset (keywords) to a "Report Items", but in the list of available reports, my table was not there.

I could see other charts and a cube that are in my report, but not that table (Weekly Contacts).

Do I need to change some settings in order to be able to see that table?

Quick background: I am trying to build a report which shows daily number of visitors in a line chart, and to have a chart for each week of the month.
So I created a table with one column and added a group. In the table group header I inserted my chart.

Thanks.
Michele

Re: Table x-axis - Weekday Sorting [message #488898 is a reply to message #488772]

Wed, 30 September 2009 15:40

Messages: 9167
Registered: July 2009

Senior Member

Michele,

If its already in the table you can choose inherit columns. Take a look
at this example.

Jason

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.20"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.5.0.v20090603 Build <2.5.0.v20090617-0630></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2007 <<Your Company
Name here>></property>
<html-property name="description">Creates a blank report with no
predefined content.</html-property>
<text-property name="displayName">Blank Report</text-property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="layoutPreference">auto layout</property>
<parameters>
<scalar-parameter name="Scale" id="15">
<property name="valueType">static</property>
<property name="dataType">string</property>
<simple-property-list name="defaultValue">
<value type="constant">50</value>
</simple-property-list>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
<data-sources>
<script-data-source name="Data Source1" id="13"/>
</data-sources>
<data-sets>
<script-data-set name="Data Set1" id="14">
<list-property name="resultSetHints">
<structure>
<property name="position">0</property>
<property name="name">cat</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">1</property>
<property name="name">val</property>
<property name="dataType">float</property>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">cat</property>
</structure>
<structure>
<property name="columnName">val</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">cat</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">val</property>
<property name="dataType">float</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source1</property>
<method name="open"><![CDATA[i = 0;

sourcedata = new Array( new Array(2),
new Array(2),
new Array(2));
sourcedata[0][0] = "Wednesday";
sourcedata[0][1] = 25.63;

sourcedata[1][0] = "Monday";
sourcedata[1][1] = 51.2;

sourcedata[2][0] = "Tuesday";
sourcedata[2][1] = 2.4;
]]></method>
<method name="fetch"><![CDATA[if ( i < 3 )
{
row["cat"] = sourcedata[i][0];
row["val"] = sourcedata[i][1];
i++;
return true;
}
return false;]]></method>
</script-data-set>
</data-sets>
<styles>
<style name="crosstab" id="4">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab-cell" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
</styles>
<page-setup>
<simple-master-page name="NewSimpleMasterPage" id="12">
<property name="topMargin">1in</property>
<property name="leftMargin">1.25in</property>
<property name="bottomMargin">1in</property>
<property name="rightMargin">1.25in</property>
</simple-master-page>
</page-setup>
<body>
<table name="mytable" id="33">
<property name="dataSet">Data Set1</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">cat</property>
<property name="displayName">cat</property>
<expression
name="expression">dataSetRow["cat"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">val</property>
<property name="displayName">val</property>
<expression
name="expression">dataSetRow["val"]</expression>
<property name="dataType">float</property>
</structure>
</list-property>
<list-property name="sort">
<structure>
<expression name="key">if( row["cat"] == "Monday"
){
5;
}else if( row["cat"] == "Tuesday"){
1;
}else if( row["cat"] == "Wednesday"){
3
}</expression>
<property name="direction">asc</property>
</structure>
</list-property>
<column id="47"/>
<column id="48"/>
<header>
<row id="34">
<cell id="35">
<label id="36">
<text-property name="text">cat</text-property>
</label>
</cell>
<cell id="37">
<label id="38">
<text-property name="text">val</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="39">
<cell id="40">
<data id="41">
<property name="resultSetColumn">cat</property>
</data>
</cell>
<cell id="42">
<data id="43">
<property name="resultSetColumn">val</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="44">
<cell id="45">
<extended-item extensionName="Chart"
name="NewChart" id="50">
<xml-property
name="xmlRepresentation"><![CDATA[<model:ChartWithAxes
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:attribute="http://www.birt.eclipse.org/ChartModelAttribute"
xmlns:data="http://www.birt.eclipse.org/ChartModelData"
xmlns:layout="http://www.birt.eclipse.org/ChartModelLayout"
xmlns:model="http://www.birt.eclipse.org/ChartModel"
xmlns:type="http://www.birt.eclipse.org/ChartModelType">
<Version>2.5.0</Version>
<Type>Bar Chart</Type>
<SubType>Side-by-side</SubType>
<Block>
<Children xsi:type="layout:TitleBlock">
<Bounds>
<Left>0.0</Left>
<Top>0.0</Top>
<Width>0.0</Width>
<Height>0.0</Height>
</Bounds>
<Insets>
<Top>3.0</Top>
<Left>3.0</Left>
<Bottom>3.0</Bottom>
<Right>3.0</Right>
</Insets>
<Row>-1</Row>
<Column>-1</Column>
<Rowspan>-1</Rowspan>
<Columnspan>-1</Columnspan>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Visible>true</Visible>
<Label>
<Caption>
<Value>Bar Chart Title</Value>
<Font>
<Size>16.0</Size>
<Bold>true</Bold>
<Alignment>
<horizontalAlignment>Center</horizontalAlignment>
<verticalAlignment>Center</verticalAlignment>
</Alignment>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>true</Visible>
</Label>
</Children>
<Children xsi:type="layout:Plot">
<Bounds>
<Left>0.0</Left>
<Top>0.0</Top>
<Width>0.0</Width>
<Height>0.0</Height>
</Bounds>
<Insets>
<Top>3.0</Top>
<Left>3.0</Left>
<Bottom>3.0</Bottom>
<Right>3.0</Right>
</Insets>
<Row>-1</Row>
<Column>-1</Column>
<Rowspan>-1</Rowspan>
<Columnspan>-1</Columnspan>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Visible>true</Visible>
<HorizontalSpacing>5</HorizontalSpacing>
<VerticalSpacing>5</VerticalSpacing>
<ClientArea>
<Outline>
<Style>Solid</Style>
<Thickness>0</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>0.0</Left>
<Bottom>0.0</Bottom>
<Right>0.0</Right>
</Insets>
</ClientArea>
</Children>
<Children xsi:type="layout:Legend">
<Bounds>
<Left>0.0</Left>
<Top>0.0</Top>
<Width>0.0</Width>
<Height>0.0</Height>
</Bounds>
<Insets>
<Top>3.0</Top>
<Left>3.0</Left>
<Bottom>3.0</Bottom>
<Right>3.0</Right>
</Insets>
<Row>-1</Row>
<Column>-1</Column>
<Rowspan>-1</Rowspan>
<Columnspan>-1</Columnspan>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Visible>true</Visible>
<ClientArea>
<Outline>
<Style>Solid</Style>
<Thickness>0</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>2.0</Top>
<Left>2.0</Left>
<Bottom>2.0</Bottom>
<Right>2.0</Right>
</Insets>
</ClientArea>
<Text>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Text>
<Orientation>Vertical</Orientation>
<Direction>Top_Bottom</Direction>
<Separator>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>true</Visible>
</Separator>
<Position>Right</Position>
<ItemType>Series</ItemType>
<Title>
<Caption>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>false</Visible>
</Title>
<TitlePosition>Above</TitlePosition>
</Children>
<Bounds>
<Left>0.0</Left>
<Top>0.0</Top>
<Width>323.25</Width>
<Height>192.0</Height>
</Bounds>
<Insets>
<Top>3.0</Top>
<Left>3.0</Left>
<Bottom>3.0</Bottom>
<Right>3.0</Right>
</Insets>
<Row>-1</Row>
<Column>-1</Column>
<Rowspan>-1</Rowspan>
<Columnspan>-1</Columnspan>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Visible>true</Visible>
</Block>
<Dimension>Two_Dimensional</Dimension>
<Units>Points</Units>
<SeriesThickness>10.0</SeriesThickness>
<SampleData>
<BaseSampleData>
<DataSetRepresentation>A, B, C</DataSetRepresentation>
</BaseSampleData>
<OrthogonalSampleData>
<DataSetRepresentation>5,4,12</DataSetRepresentation>
<SeriesDefinitionIndex>0</SeriesDefinitionIndex>
</OrthogonalSampleData>
</SampleData>
<Interactivity/>
<EmptyMessage>
<Caption>
<Value>This chart contains no data.</Value>
<Font>
<Alignment>
<horizontalAlignment>Center</horizontalAlignment>
<verticalAlignment>Center</verticalAlignment>
</Alignment>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>64</Transparency>
<Red>127</Red>
<Green>127</Green>
<Blue>127</Blue>
</Background>
<Outline>
<Color>
<Transparency>128</Transparency>
<Red>127</Red>
<Green>127</Green>
<Blue>127</Blue>
</Color>
<Visible>true</Visible>
</Outline>
<Insets>
<Top>10.0</Top>
<Left>10.0</Left>
<Bottom>10.0</Bottom>
<Right>10.0</Right>
</Insets>
</EmptyMessage>
<Axes>
<Type>Text</Type>
<Title>
<Caption>
<Value>X-Axis Title</Value>
<Font>
<Size>14.0</Size>
<Bold>true</Bold>
<Alignment>
<horizontalAlignment>Center</horizontalAlignment>
<verticalAlignment>Center</verticalAlignment>
</Alignment>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>false</Visible>
</Title>
<TitlePosition>Below</TitlePosition>
<AssociatedAxes>
<Type>Linear</Type>
<Title>
<Caption>
<Value>Y-Axis Title</Value>
<Font>
<Size>14.0</Size>
<Bold>true</Bold>
<Alignment>
<horizontalAlignment>Center</horizontalAlignment>
<verticalAlignment>Center</verticalAlignment>
</Alignment>
<Rotation>90.0</Rotation>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>false</Visible>
</Title>
<TitlePosition>Left</TitlePosition>
<SeriesDefinitions>
<Query>
<Definition></Definition>
</Query>
<SeriesPalette>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>80</Red>
<Green>166</Green>
<Blue>218</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>242</Red>
<Green>88</Green>
<Blue>106</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>232</Red>
<Green>172</Green>
<Blue>57</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>255</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>64</Red>
<Green>128</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>128</Green>
<Blue>192</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>170</Red>
<Green>85</Green>
<Blue>85</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>128</Green>
<Blue>0</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>192</Red>
<Green>192</Green>
<Blue>192</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>192</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>7</Red>
<Green>146</Green>
<Blue>94</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>0</Red>
<Green>128</Green>
<Blue>255</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>128</Green>
<Blue>192</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>0</Red>
<Green>255</Green>
<Blue>255</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>128</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>0</Red>
<Green>128</Green>
<Blue>192</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>128</Green>
<Blue>192</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>0</Green>
<Blue>255</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>64</Green>
<Blue>64</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>128</Green>
<Blue>64</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>80</Red>
<Green>240</Green>
<Blue>120</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>0</Red>
<Green>64</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>0</Green>
<Blue>64</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>0</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>128</Green>
<Blue>64</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>128</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>128</Green>
<Blue>255</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>0</Red>
<Green>64</Green>
<Blue>0</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>128</Green>
<Blue>0</Blue>
</Entries>
</SeriesPalette>
<Series xsi:type="type:BarSeries">
<Visible>true</Visible>
<Label>
<Caption>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>false</Visible>
</Label>
<DataDefinition>
<Definition>row["val"]</Definition>
<Grouping>
<Enabled>false</Enabled>
<GroupType>Text</GroupType>
<AggregateExpression xsi:nil="true"/>
</Grouping>
</DataDefinition>
<SeriesIdentifier>Series 1</SeriesIdentifier>
<DataPoint>
<Components>
<Type>Orthogonal_Value</Type>
</Components>
<Separator>, </Separator>
</DataPoint>
<LabelPosition>Outside</LabelPosition>
<Stacked>false</Stacked>
<Riser>Rectangle</Riser>
</Series>
<Grouping>
<GroupType>Text</GroupType>
<AggregateExpression>Sum</AggregateExpression>
</Grouping>
</SeriesDefinitions>
<Orientation>Vertical</Orientation>
<LineAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Visible>true</Visible>
</LineAttributes>
<Label>
<Caption>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>true</Visible>
</Label>
<LabelPosition>Left</LabelPosition>
<MajorGrid>
<LineAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>196</Red>
<Green>196</Green>
<Blue>196</Blue>
</Color>
<Visible>false</Visible>
</LineAttributes>
<TickStyle>Across</TickStyle>
<TickAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>196</Red>
<Green>196</Green>
<Blue>196</Blue>
</Color>
<Visible>true</Visible>
</TickAttributes>
</MajorGrid>
<MinorGrid>
<LineAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>225</Red>
<Green>225</Green>
<Blue>225</Blue>
</Color>
<Visible>false</Visible>
</LineAttributes>
<TickStyle>Across</TickStyle>
<TickAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>225</Red>
<Green>225</Green>
<Blue>225</Blue>
</Color>
<Visible>false</Visible>
</TickAttributes>
</MinorGrid>
<Scale>
<MinorGridsPerUnit>5</MinorGridsPerUnit>
</Scale>
<Origin>
<Type>Min</Type>
<Value xsi:type="data:NumberDataElement">
<Value>0.0</Value>
</Value>
</Origin>
<PrimaryAxis>true</PrimaryAxis>
<Percent>false</Percent>
</AssociatedAxes>
<SeriesDefinitions>
<Query>
<Definition></Definition>
</Query>
<SeriesPalette>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>80</Red>
<Green>166</Green>
<Blue>218</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>242</Red>
<Green>88</Green>
<Blue>106</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>232</Red>
<Green>172</Green>
<Blue>57</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>255</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>64</Red>
<Green>128</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>128</Green>
<Blue>192</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>170</Red>
<Green>85</Green>
<Blue>85</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>128</Green>
<Blue>0</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>192</Red>
<Green>192</Green>
<Blue>192</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>192</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>7</Red>
<Green>146</Green>
<Blue>94</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>0</Red>
<Green>128</Green>
<Blue>255</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>128</Green>
<Blue>192</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>0</Red>
<Green>255</Green>
<Blue>255</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>128</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>0</Red>
<Green>128</Green>
<Blue>192</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>128</Green>
<Blue>192</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>0</Green>
<Blue>255</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>64</Green>
<Blue>64</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>128</Green>
<Blue>64</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>80</Red>
<Green>240</Green>
<Blue>120</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>0</Red>
<Green>64</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>0</Green>
<Blue>64</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>0</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>128</Green>
<Blue>64</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>128</Red>
<Green>128</Green>
<Blue>128</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>128</Green>
<Blue>255</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>0</Red>
<Green>64</Green>
<Blue>0</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Entries>
<Entries xsi:type="attribute:ColorDefinition">
<Transparency>255</Transparency>
<Red>255</Red>
<Green>128</Green>
<Blue>0</Blue>
</Entries>
</SeriesPalette>
<Series>
<Visible>true</Visible>
<Label>
<Caption>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
<Visible>false</Visible>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>false</Visible>
</Label>
<DataDefinition>
<Definition>row["cat"]</Definition>
</DataDefinition>
<SeriesIdentifier></SeriesIdentifier>
<DataPoint>
<Components>
<Type>Orthogonal_Value</Type>
</Components>
<Separator>, </Separator>
</DataPoint>
<LabelPosition>Outside</LabelPosition>
<Stacked>false</Stacked>
</Series>
<Grouping>
<Enabled>false</Enabled>
<GroupType>Text</GroupType>
<AggregateExpression>Sum</AggregateExpression>
</Grouping>
</SeriesDefinitions>
<Orientation>Horizontal</Orientation>
<LineAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Visible>true</Visible>
</LineAttributes>
<Label>
<Caption>
<Value></Value>
<Font>
<Alignment/>
</Font>
</Caption>
<Background xsi:type="attribute:ColorDefinition">
<Transparency>0</Transparency>
<Red>255</Red>
<Green>255</Green>
<Blue>255</Blue>
</Background>
<Outline>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>0</Red>
<Green>0</Green>
<Blue>0</Blue>
</Color>
</Outline>
<Insets>
<Top>0.0</Top>
<Left>2.0</Left>
<Bottom>0.0</Bottom>
<Right>3.0</Right>
</Insets>
<Visible>true</Visible>
</Label>
<LabelPosition>Below</LabelPosition>
<MajorGrid>
<LineAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>196</Red>
<Green>196</Green>
<Blue>196</Blue>
</Color>
<Visible>false</Visible>
</LineAttributes>
<TickStyle>Across</TickStyle>
<TickAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>196</Red>
<Green>196</Green>
<Blue>196</Blue>
</Color>
<Visible>true</Visible>
</TickAttributes>
</MajorGrid>
<MinorGrid>
<LineAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>225</Red>
<Green>225</Green>
<Blue>225</Blue>
</Color>
<Visible>false</Visible>
</LineAttributes>
<TickStyle>Across</TickStyle>
<TickAttributes>
<Style>Solid</Style>
<Thickness>1</Thickness>
<Color>
<Transparency>255</Transparency>
<Red>225</Red>
<Green>225</Green>
<Blue>225</Blue>
</Color>
<Visible>false</Visible>
</TickAttributes>
</MinorGrid>
<Scale>
<MinorGridsPerUnit>5</MinorGridsPerUnit>
</Scale>
<Origin>
<Type>Min</Type>
<Value xsi:type="data:NumberDataEleme

Re: Table x-axis - Weekday Sorting [message #489284 is a reply to message #488898]

Fri, 02 October 2009 08:52

Messages: 25
Registered: September 2009

Junior Member

Hi Jason.
Sorry but I could not open your example.

Can you attach the .rptdesign file to a post so that I can download it, please?

I tried to copy and paste the text into a text editor and save the file as .rptdesign, but that did not work.

Thanks,
Michele

Re: Table x-axis - Weekday Sorting [message #489368 is a reply to message #489284]

Fri, 02 October 2009 15:48

Messages: 9167
Registered: July 2009

Senior Member

This is a multi-part message in MIME format.
--------------020909030108040404090400
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Here it is

Michele wrote:
> Hi Jason.
> Sorry but I could not open your example.
>
> Can you attach the .rptdesign file to a post so that I can download it,
> please?
>
> I tried to copy and paste the text into a text editor and save the file
> as .rptdesign, but that did not work.
>
> Thanks,
> Michele

--------------020909030108040404090400
Content-Type: application/x-zip-compressed;
name="sortpoints.zip"
Content-Transfer-Encoding: base64
Content-Disposition: inline;
filename="sortpoints.zip"

UEsDBBQAAAAIAOZdQjsp1uAOsB8AALViAQAUAAAAc29ydHBvaW50cy5ycHRk ZXNpZ27tXXtz
2za2/7uZ2e+A1c50ktYSJfkRx2G013aSNjNxNtdOm3YzmQ4twRK3FKlLUra1 nX73ixdfwAFI
UWlM2czsuiJexHniAPgBtP95O/fQNQ4jN/BfdAa9fgdhfxxMXH/6ovPTh9fd w84/R4/sEC+C
MEaksB+96MzieHFkWTc3Nz089txFhHtBOLUu3TC2hv3+vjXBkTv1O1nDu71h b0jadifkJZ3R
I0T+2YswWOAwXiHfmeMXnXGInRhPTlad0SveKjp5c/4BvWSN4RD9zFtDw95+ r9+7Jm961j/o
76KTpetN0Lde/LyQM3ja7R/s9ke2lbwIfu/Sd+OoM3L9soLjYD7HPi17GixW oTudxejx+Aki
r3vKXk///2uwDNFpMF84/gq9I/XQDId4pPZiFs+9rvQGwrdx6C5iQiV5CeNH hBx06Tn+70jI
4MaNZ8gP0CLEE3zl+niCxoEfk471bKvQqHhRjG9j5UVutPCcFe1fZ3TCmj9n zdtWoTjMCJe8
8LXrkaqk9Jw0RLppsU7+xjvZm7pXZdwkrw+W8fsQXxH++GPSmLOMA8ST1cpO SGrFRAN4AkuM
xo7nhN00T7R8QZKx0LX9TlYe6sW14y3xh9WCvD6Kndgdy2/WVZw4sZPUC4m1 aOtFLuEQTjna
9dwoTsV95Sy9+GfaB6mfrCrrHIrJW6jy+aSDftwZ7fdti+VIL7KgN5mJYJwT VLDKVamnGhcG
Hq/KNOYyuK3MOtIv1x8TUuJwqX8l4etyHC9DLKpdBeHciSE+yZ0j+jgNQuJH fvJ5JeJWtK+x
0vfkNMuSVUuooSXroU31oBsRox/jompSO+7mckXnXpIUdMFSBkJHdztW0rza mngBjrWt47jQ
NI6Tdvdk3acKIXuCEEdEBUmtH13m2lTuAvwp5Ms6FUQud2B9Hc91VX3mjoj4 1q1Y1RhZXUjg
aWZtYgf1iCWGXJ/YKy8w80pLq20VdKGCnowDbzn3v5SS8NbeVZH3F5VX/r0l rK/JO9lrjZ3x
DE/OcOxQ84RYZ7RKoELxNXA+K1NfV6HqlY0TqryOgbL6JqGzAhsxYFifARUM Fqq8htGy6kal
NyqgVm2BHvFxqDPKD0ragZIMe7NgImqTEoSP9t8/nb48/nD8yUUvUP/5o0d8 6KJNkwQf36Dj
MHRWj3M/h092Hn1D/6FvShOfPM81+Kn/mfyPNNv5iCc+jibOqiPnD2j+cL93 sFvoC0kXVc8C
X6k3EPX2B71hsdowqfZhCbxvmLyvt/f80efPJMLnHDKx7QrH41meb1foMXKR jXbRk0d/PPom
DG4+0filQxvOvculPXku8okKAvkDmu9+/z0thYn4fUSjq+eP/kyfrxwvws/B ntKApxBS8Kwk
IEmjD2J2K68Y6NCExNeFQUSC1Esefyjhh6SAl0E4weFJEMfB/DTwgrAz+scp +1c1kMy3cEH7
QdxL4Ln6WM9Q/6M7iYlkBgutbcK13+KreJPe0/r1+05r1+35OZ3AbtJ11kD9 vrPqdTv/IVhs
0nVSvX7HSWVzt6kPJo2XWEl3jD2Pm0rZLLU1ldZUHoCpiIdkrFk4U0zHnuUi b0l8kWPuRGQS
3qVFxAvf4ZsLlnfGst6THDEPHpZYVxwszpxw6tLIWF0F1NXyiD6l1XrD/eo1 L5kV1XglW3Is
f2e6EpRjUsJgmaf2ZTDJVyV+KXVU8xV74lzc3S3hIosn6YQlXYbQkgXNeC6D pT+hVU/ZFO1L
TDLp33rLCfnV0Sr18e2CzNjY4jRvIUvojARjztPQzray7Ioduqv1Dc7COosU eRZWqV+ZhSz6
3YSFX3PVJApCcMWyTAwKN37Hq87IvXqM8jOEbEKDnvzx7T8GZNaz/5z/909M Yn0EVEimMkmF
QVmFbLaVVNkVNWoIwQ3xmE/BnUi71M5q1pMBX9/h04+nybIqmHuo5M6wM0kW egsZhCHcBcoz
mrQEjeR4ETmSKxTznEssyh0YyrGy0K4NTRMOCdilAZux2Ds13bZov0tJelqR pMP6JDEH8VeS
ZFtEiLIiQQK3Jzh2XKiFVAuelWrBXt/EMrY6wooNyjgmj//JqiAfI6uvxrFp /CZKsCfHUIVi
GUVykKAULaOo6vJaDYpAHYDEbV8FQWz0BHvlnmDP6AmIqmN/giddN8ZzxJ6o F33HmHI6c8io
kYW14plNFE2axVq+VXeVSdI5po4a+3SLM8gv3NnzYIK9I/aKj248O77FEd/m P7qN3MJW/80u
2+Uf9vsD65eztxfjGZ47XZdtS45JlMhrOTGJUC6XMS7UpdCAAlaAvfCMvvs4 qZC0QCVbtTJb
Uxf1+M5x1ZpvWemkLuNC1apJJb4xW60ODz3+RmRnCxjDiIEVbCt5ZHm02OjE CRGraVvsmeVc
LC/Zw4U7wd3LVTci/7WtJJUVOfGC8e/sJ3k4nbneJMQ+ImIUPeUMOvrgxh5m ZTuiMK1Lw+8o
fSYpdL486tMesl+5HDKp4xn0Ry6dzfR4Dv+Zy/sR07kLzxS/03db0svtNz5b cZReuQu8knVt
F+okX6rgeeJ3LpdNqHnmudQZ6eU2CTpHXTKXof9NE7m7YuniZ758tHD8pA77 LdVL83OPaZF/
LWPP9XG+t2z+Pbrg02/+kOfNzB3/TkK0iO7rZA+5Emz6n0uglUKHvpciL1aj 4f4+qZlPKZQ9
xxO6l0v/U0j/IcTYpzn8RyHvhOITKOvpf3NdseS+2D+7kUtmmSO2Ok3MQTxm ApEZktbg6AGl
wlsWHuTJdxiipthBBrrITA0xqyCtOcUOk5KvAz8upFCJuP/Fo8EB1R/2U8o+ CbyJ6B77KWUf
e+7Up1AiKYNkzYLQ/S95oeNlhU7JHxySeAXIUxq4Jo7fHUPV1RypWxacY1sS B4gQFY7aJ874
92lIDTnncdLB4IiJ/SXFK4ktOL029st0kamrRhtZnk4fWaaikVnP88mqGZYZ YhVTBI1xPXPU
G6TZJPVGCZqlYnYI8MtIOxgg4ZuHgG9GqXfug94ZGfwzUj00KvUIVt4lEFrF 0Jgk6IfK914Q
t4NkO0jev0Hyx3QsuVg4Y9efjgh1amLWnBg8cqXlpEx+nkvGkOMQO3kSNnSo /S13qOVChMSI
ajldyCGhqk63X8npEgJlKa/jWN/iKZn/tq61da33z7W27u9ruL9h3ZhzaHZ/ w7ruj/YL3xZq
8cmkOqlUp5TZlNAqvLZQkNCbf4H9r9BNVvRGyWBMeJhLTYu+TDZeRoRlv3Hq bStLTQteYIpw
j4sm8iDsXzd3UDlivxdA0hHTE9tKn9MSb2I858t1mIgjIvqTJGTKQhccClzS L1NUXpcA1UhR
JNRO4R/AFB59xYjz607ztUN10aa4iaXGeXwZXGNRRrJYNXSVQ0JNNArzRUSi u8Pd3nBfDkaT
UHTwbKgEo1IoKksCDkN1QagpBNVxXuI6EHxqQ09D4FkadiqmajLTMhNVzLO6 acJmqTdJ2Bxl
UzTrrWyCtd1wVTJhB6x3vrDjBZyuYSilVZPNKRKMzPl25+jDTfBb+kSDlyyL lfyJHs0dvQ/o
qSPb4k8sgw+rOUVgNiin8qIOxcLRjcKMwRFWUmm/BMqosFc6Ot5BJzvolPQN zM64ATRKQrR4
FkwpbdVfuL+ztzMYmt+XsiBThDf+BN+OUi7IGamy6XpEKkoJb+i+gUMCxGs3 XvGAwn41X8Sr
M8JciikUbcqhhAhaiBwiNGabK/S4qOP6ET23TLd3e3JAIwczmi2SjbZHam6N QNsihXhKjqW+
kAEf7JnsdzB8CtovS4fsl2WU2K/ihc2edDA8NHtSpZOmbuo6ivT+FArZFXcK jaEDdchmQ+cA
GOHFyDmAghgxjA6UNbPCOGpbitXYFGeRlGXzAjq1s63cFEGaIADTA2Fnv3SP b4mlaTYwgbkm
37zcYx5T3rw0bl1qNy433LasvWkJb1kq02bFQdWf6VSd5+hmOaY5jm6GA85v HtY6HbAKBy/S
QuvC2hmKeX6yziJtSYSXN2VpVnKCveBGMys5jqJg7NJLUXLuAgmH8ZZwwwkL LgPJTgMZVxV+
NToOZEI+wM4Dmd0H2jbkA9WBQMRdz7iPD6QwjFdvV1dEYguQuI8rJ7R7sItC 6jyk8N7/XeJQ
UtCs5IjMcbKHPAFyNfGS946H41iSzCs/pnnrG1UtrTo0qdXg4MCkWMPBIaha goK7JGu4NzTQ
dXhoImvQP2gsWbsmsgZPhya69uV5CMtqAlls4qUlS+PhU3ENG6uFdMqrl9bQ rIXNJcssrjK6
ng0bS9dTkzM8NGrhoRpo3AdpwbFDE6h6ZvSEz4yesME6CIa6aPtdYYkWlsir uXQpC4IsR1C1
Zwyfnu01lShjTGh2GNCMaytMa3uHLZO0ShzGvZVWcx3GBrbV5NDpnoaEZi00 Lrs02LbM0qKz
Fj1ZB40dtTbyGM0ly7hCM9wz6uBg2NgA3kSVWQO3Nso1impb7apE/+7nIkZz hbXZQNxccW3k
3Bs8FNd3g1vp2WtsVDVe+R7oHKuqtBIAn7rZJXbBcsTSv0cnTsgzihSWHGxg ReSrElgihBjg
DWrPIrBsAC3A0jVnElievHPOE+EebLSDzhooyNe0i85KGyRerstmbaZEgrvq LAvaWWcZJbvr
rEyFHXZWjnELEtdaZsFqaJ0YyzU6MlZCax4sFzjXwNJLzzbw2jAzoZ16lq7d rWe5hh17ll+y
a8/KGHbuWb66e8+SK5BbvOdApFE4b2YUcqu5HHrt37f/twzi59eOx3981mzQ s6o/EN1d5M99
pzmvfHpt6CTpavIImBBp4cMqBT9mz0rR4+k0xFMnxq+yixGpD/Bdj3hB4uA6 snMRzckd5LBq
DVXCwb6ZEGflXrk4FMe30CBxyrkshcsMpi73gn4JKvBJJUjXKKkZHvs35ldt C+AANQJNO7kT
ezsIOq3G68Md5ANAiukgtsKvlSomF1kUE7+VCTd5LJQ5dyPCoHM8jh1/SrFl PCErk7AznwSL
q5qOQPoxuljObQvKyPdDeauKn896uc6JSwrPO07GpgKhm6I0yw4sat681r1I 7YFDZBjANYN3
C4m7r3cGIdlTckQc7CbtM+c/QfhD6BZ0Q+sPmqUig2cHxn1n4w4ty66gKKhC OKP1Y5QswgHO
pmP2MQVCVpoiFWtZnqaVzQc5F6GRw1I12j5z/a1V8uHQuD4xNK9PDOH1iVbJ t4Tlei1XVNpm
nxLN107LRO9xSA+k0puw1MSs0WILNIKcuoUgiAWzZ/RLDlJYy0OxXGRET04e vVvOL3FIw/lX
HqaBl7zqw+I2NkgqR8HkQ5eW1Bv7fejOnXBFj4UIN5FPyYrhcEzenDA5eeT5 JOaGjq0YcOIK
SrwUIy4jxLX48PoLhOvouHbfMfHhMC5cKDeACgfXBb8eKSAaXNACY8HFYAQg we+aFAgBnogF
xn9zWgD09x2TAm5VVZnCQNtUd0wLhPQ2L6M3lhSTWMy0ADCeu6YFQnQnhm/Q MADNva1SUae6
d00JhNxOJwcGD9ZA/aq9CrNtdm+US/NoAVDZCSUwJptTAiCy75gQQwxmMnp4 ka+xprJtw4pe
KjWWXrdUKs0z+pq20sSw5R6FYCYNA9foG2srJqnAUC1OCgAW3Farbx4phlUK DTY68V+NC4z1
lJi0a8siSYNItstOjLp1fyb1zRNK/cGxeWKp7YgbODzWc19b5IUNFt84KkyK 9WDmKFWkokMn
2yqgq3S/GUArapC/JuQxjDvWo44BzDGMON4Qb1yUmwmgZJJbmRaa9JASpkEZ azDG5Qjjavhi
Dbp4HVVm5TUOhuUZnAzL16g0ywMxxdUgtiDGC4bsGrDEZiRxOY7YjCIGMcSV 0AgyRNAEls2l
Z9jhsRObscMGAK4KvzXCbjWgWz3ktjLgVgu3rQC2haG26wJty2C2CoDWBuCz dikQ264Cr60H
rhVtZT3SA2sLsNrsG2QQsFaHMNrovnjzdcLgG6WxS3857xf8+Et7iy0qFyZq b7Hd/BZbjSHk
P6JZdFziElvImwFo2L8QG/8FZA/CMdN9PcNuGATFrPO9MZ2LqwII1MMBHxJr dZBukDkquhXA
tjZbZUFwZeKjYWil8NIAsLJV2aRsI1ir01lJRSWk6no41SJKVcao6hCqNfCp enRq8VlCplbC
pZIYLMbToFCqkJS0pQevkog2AaxWPOrFvlBzkXwTl9GVT2FFkjvDaXBnW/Ng gr0j9s35j248
Ey/8/JlEirdzr7sIgwV522qUUyj1n50UQ74zJ5wPlvFiGb8OwrlD+H3x8w+2 Va8h15+RID0+
5R9o6iRMqtfYjH3aqkOCloPiv32qS/XavKHf0uqM9np7h8/2D3fTf9VatC0y y8H+BE+6bozn
cEHbGmPP0+TRLOROXnT2DjqWWsa2yFS4mGxbV0EQk5lrzg3EdCKWSyj0CrEn Opl6x0hmutIR
9L/DN+x50GG9GBx0pLfllUjUIUnFjwh1RvbfP52+PP5w/MkG9BGRCn50RAyb yDCOF0eWdXNz
07vZ7QXh1Br2+wPrl7O3F+MZnjtd149ixx/jjqiVzj8KdS/dMO7hsecuIsxa YS88o+9OnVvS
AnUjVStTP5PU458WrlrzLSud1GVcqFo1qcS9XrU61HNyT8jd6YkTIpabc6r2 xfKSPVy4E9y9
XHX5GkGSyopkn9GiHk/7fWV2Vzsrm7nf9hvLaWfabyx/xVkvqhDlrPuN5XXO Mp/gqyDEiIU4
a37m5IAqz73/zEl7WDtNbNCJOXDfw7zrod/zeEiHtW3lY676cfK9F8TtCNmO kPdvhMz2UdLp
KdE5JTFrTgweudJyUiY/9dv3oMjKhFYQW3/LHWq5ECExolpOF3JIqKrTVT5W yfIUi7cUKa/j
WN/iKZnRtq61da1b7Fp1NVr/9zX837Bu0Dk0+79hXf9H+4VvC7W++CZ/4QXr 3Df20g3xmCUR
lv3GqaffU09S04IgaOVBOADd5EHliJ1uYjM9sS31kqc3MZ6zZTmxx+DiiOhQ kpgpzBrfY628
ONFeupZLfuDzePQVw85t+Fbp8WVwjW34e8pK/CrHhZqQFOaLCEf3Bk97T/fl iDSJR4d7akQq
xaPgF+qVWFQXiZriUB3nJa4DEag2/jREn6Wxp2KqG6H2FDdf2TRhs9SbJGyO CrjLNMzIFljb
C1fzwLD31Xte2OsCHtdAJK2a7E2RaGTOtzBHH26C39InGr1kWazkxTh0F1Qx re++IwnfoVPH
8/AEOVcxDtEiWCw9Eun4UxTPMIr4dbx0h5Dob4+VZ3/+h47gc5HPUnL/LrJU UY42cIFjueDL
XLIo6Y6jsVzsDdu44x0/JSMuCdloEetvjwgV1tXSZxEXp0A0+dqlRD0WHdxJ OrDD2kdPaL0/
eHX3KinVm+JYhj8/foJevEAcYc3/oid/sGrzRRDG74m8nCl+jMSPqPcf59rp uQF68pyWIjNz
9AL5+Aa9D10//hi6pIuPWQLpIU6eBZT7yIpxFFuMjkl01YtvBbZ7B1HxoydZ q70Fbc/zk7oq
7d0uz/neSB1vkDL52gmR50a0v4JZtAYLkKLHtBgtRP6y0ldBiB4j90X/OXK/ 9eLntGLPw/40
npGUF+73gydJ0T80Pb52PPELfY9c8n/x0O1mybTZT+5n+vakm3/yjhCxV+oC K0q68I1lfUMl
LVqkQn0iktMW0x+sqYiI93HG77EXRFg8/yn+UBiPMCbEkSnRiAHRI45KiYTF Ma7n3CsboeRU
XtSZLzxM5Zj5rQgrqYhj8YmMijiD0fEOOtlBpxwTr2ZnbgZo1M6A+tVfuL+z tzMYmt+XsiDz
r2/8Cb4dpVyQM5J+GnpkH/tjoudOuKre2exycTN7dE2T7koJb+hGoEPcz7Ub r/jkwH41X8Sr
MyJS4g+SJhUoOTwBkScf0MSjMOmQJxxbO8zd40hFCUWg8FMNdjUTAFPwXzX8 NAT8tqWor52/
VDJ3dCU375Zm3frTGb90KTIQseKVFnE4LGCPOUwZFmAEBWghARsCAmrDAWAw QHvopD10kk//
iodOwOl+cbIvTfXFqRNwqg/eQYuEw6BwdSe0rfpLdb8aHQcyYYpg54HM7gNt G6aI6oDAPY+e
8R3HQIrCePV2yVIkttCj+7gcSbsHuyikTkMK75UvxUbl12LT3ih3aeuuxkYb 3ElRS6uMH+bV
XJGdWhdwSTal9pVy0cZXJwu8LDulC74uOyELujC7KWRBF2dn4oKvzk7oAi7P bghZ4G1IqMTD
p+ICbkRqCF3QhdqZtOBbX7aALLO4yuhq7nfywYu2M6dh1ELgsu37IC04dmgC VdAF3BlV8FXP
W6CDYKiLtt8VlmhhibyaSxdwSXdGFXxNd0IVcFF3Q4gyxoRmhwHNuLbCtLZ3 2DJJq8Rh3Ftp
NddhbGBbTQ6d7mlIaNZC47JLg23LLC34ptOELOAu3fvgMZpLlnGFRnM9eGpZ wAXhDSHLRJVZ
A7c2yjWKalvtqkT/7uciRnOFtdlA3FxxbeTcGzwU13eDW+nZa2xUNV75Hugc q6q0Evwe8B1Y
gbXLiKV/j06ckGcUKSy9uhxBl5cjGDHAGzRcYI40V5gjwyXmlFYIYgBeZE7Z uNFV5rLETbvo
rLRB4uW6bNZmSqTmUnOku9Ycle6uszIVdthZOcYtSFxrmQWroXViLNfoyFgJ rXmwXPCac1S6
pZ3UhpkJX3ZOqdft1rNcw449yy+98pxyS79zz/Kha8+rWbNy8zky3n2ONLef Xzue+fZz+ipD
u+oN6BlG2HATOtLdhc6UVXMbOpXYqtp96FyVdLeql9+JnlANXNa+5r3ozJKN N6OzMszsvCW7
2JFLPZ9SKHruRoSX53gcO/6Ugrl4QlYm4Xw+CbhsHdERteS69VxNhtQm6jIa 9Jh9S6lqHSYU
/SXtqOY17ZQ+hRoVB59Rv86Z5L/u0tyyI726C2nXuTesPY6LDCOxZhRusW33 9VotJDtrDm2D
PTVw6zsy+INmqQh4TXmqJJqLyhM1ga4qhxSllPtI78YoVW75zdqiWMvxNK2c 4xqGqZfEI+ia
+O3RcfBe85TjmpvNE45Dd5uXcNz00aEHouQNYrley9UvHxQvlkdrXi1PG5Wu ppeul0dId8E8
QjWumE8q8TFSOdKlXDsvX3Zf5ap5ZLxFnrYKHj/JzogCZ1KUQ2xMsaufSPl3 eyJFVG1vuc0l
t+H4gzlqYjgOh9qzJixLxJPtWZMsrxFktWdN8vlcXO1ZkxZY+GXoas+a5PIN wUMTqGrPmhTy
t9xntGdNkqwtx8PDWIR7cHqhPWuyTdJqz5q0IeEd46wbbFvtWZN8fsPJas+a ZNnbHeUaRdWe
NdmiEas9a7JVzr3BQ3F9N7iVnr3GTlXjle+BzrGqSqv0rEmxhfZEify2ghRN m+WstEGu5Rpr
1llKZHuiJCmhNQKW254oYckVyAWPlChnONpjHenryo51tOcwXO05jOy7ru1J jPYkhkhuoV8P
5SSGQH61RzHSfD7vX/9gQAtTb89i8Pz2LMZ9VvL2LAZ/fhBnMYBTFwY4tAKG LoVCy0BoLQy6
/jrYOiqu3V5LXDgMfxa6DYCfweWvr0cKCHoWtMCQZzEWAYDnuyYFAjonYoFh zpwWAOR8x6SA
OzJVpjDQbswd0wIBms2rxY0lxSQWMy0AWuWuaYGAy4nhGzQMAC1vq1TUqe5d UwIBlNO5gcGD
NVC/aq/CbJvdG+XSPFoA8HFCCQw95pQAwOM7JsQQg5mMHl7ka6ypbNuwopdK jaXXLZVK84y+
pq00MWy5RyGYScPANfrG2opJKjAiiZMCYOK21eqbR4phlUIDAU78V+MCYz0l Ju3askjSIJLt
shOjbt2fSX3zhFJ/cGyeWGo74gYOj/Xc1xZ5YYPFN44Kk2I9mDlKFanoQLgq BLd8uxmA62mg
ryboLQy81cNuAdAtDLndEHBblJsJoGSSW5kWmvSQEqaB2WpAtuUQ22oAWw28 dh1VZuU1Dobl
GZwMy9eoNMsDQbXVMKYgxgvGrBrAtGYobTmQ1gyjBUG0lcAIMkTQdHN6Lj27 j33sxOb72A23
sa8J1tVAdfVA3cowXS1ItwJEFwborgvPLQPnKtBcGwDm2qWw3LRWZVCuXQWS Ww+Qm71XJOnB
uGtAcXWQJJOrK3NyxqFNA+mRRjtgpNOOcuoIB49u0simjmobjGhVRzPdSGYa xXQjGDh6ASPX
xohqdTS4uzC42Bd1vFHHGt04ox9jzOOLfmxRxpUyQ8ipfHUALQCf/QvR9F9A 9iB+M90JNOyf
QdhNAFZdekmlzsVVQRDq8YMPibU6EDjIHBUOC4Bhm62yIBoz8dEwFlN4aQCJ 2apsUrYRrNXp
rKSiErR1PWBrEdYqg1p5oA1F1zUgrXpAa/FZArNWgrKSKCzG06BQqpCUtKXH u5KYNgG5VvxQ
j035eLFwxjTS3Wd05VNYkfOgGMQe0y8l5czkF5Yw6g5ZdfGU5v7Kn/f2aeav Uua/+TOr+G8p
j8nqHZn4FMRGAb3p64luZ32zrXkwwd7R6cwJ449uPBO8+PyZhLG3c6+7CIMF YcRqlNN20kaS
jHxnTpQgWMaLZfw6COcOEf3Fzz/YVrWKVHsuMKlDdQeRX4OqNWeYRjYdEuXs Fv/tUyB2tTZu
3Ek864z2e4f9Yf8wa8LQgudGcVdq5pLGt5QAYurLuR91inVYvYjo5jhehljN Y/lSk/RvZ0Tm
4rqOpBVxOg8TVbOEzkiw95zM7juksQ6Z02fZ1XpCm6Cq1BkREoh6mzpkWwYy 67Hgmhrgl2IB
aWwzFlx5gVkkWg7YVkFzyq3ixPUnhN3n+Kozmq9iOvGHXkypibE/wZOuG+P5 SNj7ZTAhhWwr
xIsgjEeP/h9QSwECFAAUAAAACADmXUI7KdbgDrAfAAC1YgEAFAAAAAAAAAAB ACAAAAAAAAAA
c29ydHBvaW50cy5ycHRkZXNpZ25QSwUGAAAAAAEAAQBCAAAA4h8AAAAA
--------------020909030108040404090400--

Re: Table x-axis - Weekday Sorting [message #489370 is a reply to message #489368]

Fri, 02 October 2009 16:05

Messages: 25
Registered: September 2009

Junior Member

Sorry Jason.

But your attachment is "inline".
How can I download it?

Thanks.
Michele

Re: Table x-axis - Weekday Sorting [message #490952 is a reply to message #489370]

Mon, 12 October 2009 15:04

Messages: 9167
Registered: July 2009

Senior Member

Michele,

I was out most of last week. Did you get the report?

Jason

Michele wrote:
> Sorry Jason.
>
> But your attachment is "inline".
> How can I download it?
>
> Thanks.
> Michele

Re: Table x-axis - Weekday Sorting [message #490969 is a reply to message #490952]

Mon, 12 October 2009 15:48

Messages: 25
Registered: September 2009

Junior Member

Hi Jason.

No, I did not get the report.

Probably was caught by our spam filter Sad

Can you please send it to
michele [dot] mor [at] gmail [dot] com

Thanks.
Michele

Re: Table x-axis - Weekday Sorting [message #490980 is a reply to message #490969]

Mon, 12 October 2009 16:03

Messages: 9167
Registered: July 2009

Senior Member

Sent.

Michele wrote:
> Hi Jason.
>
> No, I did not get the report.
>
> Probably was caught by our spam filter :(
>
> Can you please send it to
> michele [dot] mor [at] gmail [dot] com
>
> Thanks.
> Michele