Excel Rendering Taking Hours

Question

Post reply

Excel Rendering Taking Hours

Beratung

SSC Eights!

Points: 940
More actions
August 14, 2006 at 11:41 am

#169875

We have a report that we render to excel. When trying to export to excel from IE it just hangs. If we have a subscription send the report as an excel file attached to an email it may go out 8 hours after it starts rendering.
This report rendered to excel fine at one time, but now it doesn't. I have seen posts about data having an affect on excel rendering. For instance, when the data changes and say some rows are null it can affect the performance of the report.
We have other reports that render to excel just fine. Has anyone run into this issue?
I know SP2 was suppose to fix excel rendering perfomance but it has no affect on our issue.

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

ezisqlservercentral SSC Veteran Points: 241 More actions · Answer 1

Hi Darin

Have you tried exporting the report in a simpler format, say CSV, rather than Excel?

Also, an extract of the report code and expected file size would be useful for diagnosis.

Chris

Beratung SSC Eights! Points: 940 More actions · Answer 2

Thanks for responding Chris...

The report exports to CSV and PDF no problem. The Open/Save dialog box pops up immediately, whereas the dialog box never appears with the Excel export. The export doesn't respond for Excel when rendering from VS .NET 2003 design either.

When the export worked the Excel file was about 4MB.

How would you like the code? Pasted into this thread?

ezisqlservercentral SSC Veteran Points: 241 More actions · Answer 3

Darin

I'm bound to ask, Aren't the CSV or PDF formats OK for your reporting requirments?

And yep, pop the code in this thread, better for all to be able to comment on.

Chris

Beratung SSC Eights! Points: 940 More actions · Answer 4

Chris,

THe report has drill down detail, so Excel is required. Plus, the users like to reformat and massage the data.

Here's the code:

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

<Source>Embedded</Source>

<Bookmark>HOMEPAGE</Bookmark>

<Sizing>AutoSize</Sizing>

</Image>

</ReportItems>

</PageHeader>

<Body>

<Style>

</Style>

<rdefaultName>textbox79</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox20</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox24</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<Value>=Parameters!Year.Value-1 & " Period Sales"</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<Value>=Parameters!Year.Value & " Period Sales"</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<rdefaultName>textbox115</rdefaultName>

<Value>Open Orders</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<Value>Level I</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<Value>Level I Variance</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<Value>Level I Commission</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<Value>Level II Variance</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<Value>Level II Commission</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<Value>Total Commission</Value>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

</TableRow>

</TableRows>

</Header>

<Style>

</Style>

<rdefaultName>MONTHNAME</rdefaultName>

<Bookmark>=Fields!MONTHNAME.Value & "A"</Bookmark>

<Value>=First(Fields!MONTHNAME.Value)</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox81</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Shading>Simple</Shading>

</ThreeDProperties>

<Style>

<BackgroundColor>White</BackgroundColor>

</Style>

<Style>

<Default>Solid</Default>

</BorderStyle>

</Style>

<Position>RightCenter</Position>

</Legend>

<Palette>Default</Palette>

<Value>= SUM(Fields!SLSAMNT.Value)/ SUM(Fields!L1Sales.Value)</Value>

</DataValue>

</DataValues>

<Style>

</Style>

</DataLabel>

<Style>

<BackgroundColor>=IIF(

SUM( Fields!SLSAMNT.Value )/SUM( Fields!L1Sales.Value ) < .8,

"RED",

IIF(

SUM( Fields!SLSAMNT.Value )/SUM( Fields!L1Sales.Value ) <1,

"YELLOW",

"GREEN"))</BackgroundColor>

</BorderWidth>

<Default>Solid</Default>

</BorderStyle>

</Style>

</Marker>

</DataPoint>

</DataPoints>

</ChartSeries>

</ChartData>

<Axis>

<Style>

<Default>Solid</Default>

</BorderStyle>

</Style>

</MajorGridLines>

<Style>

<Default>Solid</Default>

</BorderStyle>

</Style>

</MinorGridLines>

</Axis>

</CategoryAxis>

<DataSetName>Complete</DataSetName>

</StaticMember>

</StaticSeries>

</SeriesGrouping>

</SeriesGroupings>

<Subtype>Plain</Subtype>

<ToggleItem>MONTHNAME</ToggleItem>

<Hidden>=IIF(FIRST( Fields!SLSAMNT.Value )/FIRST( Fields!L1Sales.Value ) = 0, TRUE, FALSE)</Hidden>

</Visibility>

<Style>

<BackgroundColor>White</BackgroundColor>

</BorderWidth>

<Default>Solid</Default>

</BorderStyle>

</Style>

</PlotArea>

<Axis>

<Style>

<Default>Solid</Default>

</BorderStyle>

</Style>

</MajorGridLines>

<Style>

<Default>Solid</Default>

</BorderStyle>

</Style>

</MinorGridLines>

</Axis>

</ValueAxis>

</Chart>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<Value>=Sum(Fields!PreviousYear.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<Value>=Sum(Fields!SLSAMNT.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<rdefaultName>ORDERAMOUNT</rdefaultName>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<Value>=Sum(Fields!ORDERAMOUNT.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<Value>=Sum(Fields!L1Sales.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<Value>=Sum(Fields!L1State.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<Value>=Sum(Fields!L1COM.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<Value>=Sum(Fields!L2State.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<Value>=Sum(Fields!L2COM.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<Value>=SUM(Fields!L1COM.Value+ Fields!L2COM.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

</TableRow>

</TableRows>

</Header>

<GroupExpression>=Fields!MONTH.Value</GroupExpression>

</GroupExpressions>

</Grouping>

<Style>

</Style>

<rdefaultName>textbox136</rdefaultName>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<rdefaultName>textbox38</rdefaultName>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

</Textbox>

</ReportItems>

</TableCell>

<Shading>Simple</Shading>

</ThreeDProperties>

<Style>

<Default>Solid</Default>

</BorderStyle>

</Style>

<Position>RightCenter</Position>

</Legend>

<Palette>Default</Palette>

<Value>= SUM(Fields!SLSAMNT.Value)/ SUM(Fields!L1Sales.Value)</Value>

</DataValue>

</DataValues>

<Style>

</Style>

</DataLabel>

<Style>

<BackgroundColor>=IIF(

SUM( Fields!SLSAMNT.Value )/SUM( Fields!L1Sales.Value ) < .8,

"RED",

IIF(

SUM( Fields!SLSAMNT.Value )/SUM( Fields!L1Sales.Value ) <1,

"YELLOW",

"GREEN"))</BackgroundColor>

</BorderWidth>

<Default>Solid</Default>

</BorderStyle>

</Style>

</Marker>

</DataPoint>

</DataPoints>

</ChartSeries>

</ChartData>

<Axis>

<Style>

<Default>Solid</Default>

</BorderStyle>

</Style>

</MajorGridLines>

<Style>

<Default>Solid</Default>

</BorderStyle>

</Style>

</MinorGridLines>

</Axis>

</CategoryAxis>

<DataSetName>Complete</DataSetName>

</StaticMember>

</StaticSeries>

</SeriesGrouping>

</SeriesGroupings>

<Subtype>Plain</Subtype>

<Hidden>=IIF(FIRST( Fields!SLSAMNT.Value )/FIRST( Fields!L1Sales.Value ) = 0, TRUE, FALSE)</Hidden>

</Visibility>

<Style>

<BackgroundColor>White</BackgroundColor>

</Style>

<Style>

<BackgroundColor>White</BackgroundColor>

</BorderWidth>

<Default>Solid</Default>

</BorderStyle>

</Style>

</PlotArea>

<Axis>

<Style>

<Default>Solid</Default>

</BorderStyle>

</Style>

</MajorGridLines>

<Style>

<Default>Solid</Default>

</BorderStyle>

</Style>

</MinorGridLines>

</Axis>

</ValueAxis>

</Chart>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

<TextAlign>Right</TextAlign>

</Style>

<rdefaultName>PreviousYear_1</rdefaultName>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<Value>=Sum(Fields!PreviousYear.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

<TextAlign>Right</TextAlign>

</Style>

<rdefaultName>SLSAMNT_2</rdefaultName>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<Value>=Sum(Fields!SLSAMNT.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

<TextAlign>Right</TextAlign>

</Style>

<rdefaultName>ORDERAMOUNT_2</rdefaultName>

<Value>=Sum(Fields!ORDERAMOUNT.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

<TextAlign>Right</TextAlign>

</Style>

<rdefaultName>L1Sales</rdefaultName>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<Value>=Sum(Fields!L1Sales.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

<TextAlign>Right</TextAlign>

</Style>

<rdefaultName>L1State_1</rdefaultName>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<Value>=Sum(Fields!L1State.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

<TextAlign>Right</TextAlign>

</Style>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<Value>=Sum(Fields!L1COM.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

<TextAlign>Right</TextAlign>

</Style>

<rdefaultName>L2State_1</rdefaultName>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<Value>=Sum(Fields!L2State.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

<TextAlign>Right</TextAlign>

</Style>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<Value>=Sum(Fields!L2COM.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

</Style>

<rdefaultName>textbox146</rdefaultName>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<Value>=SUM(Fields!L1COM.Value+ Fields!L2COM.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

</TableRow>

</TableRows>

</Footer>

</TableGroup>

<Style>

</Style>

<rdefaultName>textbox41</rdefaultName>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextDecoration>Underline</TextDecoration>

<TextAlign>Right</TextAlign>

</Style>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<BookmarkLink>=Fields!SLPRSNID.Value & "B"</BookmarkLink>

</Action>

<Value>=Fields!SLPRSNID.Value</Value>

<ToolTip>Take you to the Salesperson's Report</ToolTip>

</Textbox>

</ReportItems>

</TableCell>

<Shading>Simple</Shading>

</ThreeDProperties>

<Style>

<BackgroundColor>White</BackgroundColor>

</Style>

<Style>

<Default>Solid</Default>

</BorderStyle>

</Style>

<Position>RightCenter</Position>

</Legend>

<Palette>Default</Palette>

<Value>=IIF(FIRST( Fields!SLSAMNT.Value )/FIRST( Fields!L1Sales.Value ) = 0, "", FIRST( Fields!SLSAMNT.Value )/FIRST( Fields!L1Sales.Value ))</Value>

</DataValue>

</DataValues>

<Style>

</Style>

</DataLabel>

<Style>

<BackgroundColor>=IIF(

FIRST( Fields!SLSAMNT.Value )/FIRST( Fields!L1Sales.Value ) < .8,

"RED",

IIF(

FIRST( Fields!SLSAMNT.Value )/FIRST( Fields!L1Sales.Value ) <1,

"YELLOW",

"GREEN"))</BackgroundColor>

</BorderWidth>

<Default>Solid</Default>

</BorderStyle>

</Style>

</Marker>

</DataPoint>

</DataPoints>

</ChartSeries>

</ChartData>

<Axis>

<Style>

<Default>Solid</Default>

</BorderStyle>

</Style>

</MajorGridLines>

<Style>

<Default>Solid</Default>

</BorderStyle>

</Style>

</MinorGridLines>

</Axis>

</CategoryAxis>

<DataSetName>Complete</DataSetName>

</StaticMember>

</StaticSeries>

</SeriesGrouping>

</SeriesGroupings>

<Subtype>Plain</Subtype>

<Hidden>=IIF(FIRST( Fields!SLSAMNT.Value )/FIRST( Fields!L1Sales.Value ) = 0, TRUE, FALSE)</Hidden>

</Visibility>

<Style>

<BackgroundColor>White</BackgroundColor>

</BorderWidth>

<Default>Solid</Default>

</BorderStyle>

</Style>

</PlotArea>

<Axis>

<Style>

<Default>Solid</Default>

</BorderStyle>

</Style>

</MajorGridLines>

<Style>

<Default>Solid</Default>

</BorderStyle>

</Style>

</MinorGridLines>

</Axis>

</ValueAxis>

</Chart>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<Value>=Sum(Fields!PreviousYear.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<Value>=Sum(Fields!SLSAMNT.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<Value>=Sum(Fields!ORDERAMOUNT.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<Value>=Sum(Fields!L1Sales.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<Value>=Sum(Fields!L1State.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<Value>=Sum(Fields!L1COM.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<Value>=Sum(Fields!L2State.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<Value>=Sum(Fields!L2COM.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

<Value>=SUM(Fields!L1COM.Value+ Fields!L2COM.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

<ToggleItem>MONTHNAME</ToggleItem>

</Visibility>

</TableRow>

</TableRows>

</Header>

<GroupExpression>=Fields!SLPRSNID.Value</GroupExpression>

</GroupExpressions>

</Grouping>

</TableGroup>

</TableGroups>

<Style>

</Style>

<rdefaultName>textbox67</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox68</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox78</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

<TextAlign>Right</TextAlign>

</Style>

<Value>=Sum(Fields!PreviousYear.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

<TextAlign>Right</TextAlign>

</Style>

<Value>=Sum(Fields!SLSAMNT.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

<TextAlign>Right</TextAlign>

</Style>

<rdefaultName>ORDERAMOUNT_3</rdefaultName>

<Value>=Sum(Fields!ORDERAMOUNT.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

<TextAlign>Right</TextAlign>

</Style>

<Value>=Sum(Fields!L1Sales.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

<TextAlign>Right</TextAlign>

</Style>

<Value>=Sum(Fields!L1State.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

<TextAlign>Right</TextAlign>

</Style>

<Value>=Sum(Fields!L1COM.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

<TextAlign>Right</TextAlign>

</Style>

<Value>=Sum(Fields!L2State.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

<TextAlign>Right</TextAlign>

</Style>

<Value>=Sum(Fields!L2COM.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

</Style>

<Value>=SUM(Fields!L1COM.Value+ Fields!L2COM.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

</TableRow>

</TableRows>

</Footer>

</TableColumn>

</TableColumn>

</TableColumn>

</TableColumn>

</TableColumn>

</TableColumn>

</TableColumn>

</TableColumn>

</TableColumn>

</TableColumn>

</TableColumn>

</TableColumn>

</TableColumns>

</Table>

<Style>

</Style>

<rdefaultName>textbox98</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<rdefaultName>textbox6</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<rdefaultName>textbox4</rdefaultName>

<Style>

<TextAlign>Right</TextAlign>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<rdefaultName>textbox29</rdefaultName>

<Value>=Parameters!Year.Value-1 & " Period Sales"</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<Value>=Parameters!Year.Value & " Period Sales"</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<rdefaultName>textbox3</rdefaultName>

<Value>Open Orders</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<rdefaultName>textbox37</rdefaultName>

<Value>Level I</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<rdefaultName>textbox2</rdefaultName>

<Value>Level I Variance</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<Value>Level I Commission</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<Value>Level II Variance</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<Value>Level II Commission</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<Value>Total Commission</Value>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

</TableRow>

</TableRows>

</Header>

<Style>

</Style>

<rdefaultName>textbox35</rdefaultName>

<ToggleItem>CUSTNAME</ToggleItem>

</Visibility>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox14</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>DOCNUMBR</rdefaultName>

<ToggleItem>CUSTNAME</ToggleItem>

</Visibility>

<Value>=Fields!DOCNUMBR.Value</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox33</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<rdefaultName>SLSAMNT_Detail</rdefaultName>

<ToggleItem>CUSTNAME</ToggleItem>

</Visibility>

<Value>=Fields!SLSAMNT_Detail.Value+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox130</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

<ToggleItem>CUSTNAME</ToggleItem>

</Visibility>

</TableRow>

</TableRows>

</Details>

<DataSetName>Complete</DataSetName>

<Style>

</Style>

<rdefaultName>SLPRSNID</rdefaultName>

<Bookmark>=Fields!SLPRSNID.Value & "B"</Bookmark>

<Value>=Fields!SLPRSNID.Value</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox9</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox5</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox30</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox106</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox8</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

</TableRow>

</TableRows>

</Header>

<GroupExpression>=Fields!SLPRSNID.Value</GroupExpression>

</GroupExpressions>

</Grouping>

<Style>

</Style>

<rdefaultName>textbox1</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox12</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<rdefaultName>textbox18</rdefaultName>

<Value>=RTRIM(Fields!SLPRSNID.Value) & " Total"</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

</Style>

<rdefaultName>textbox36</rdefaultName>

<Value>=FIRST( Fields!PYTotal.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

<TextAlign>Right</TextAlign>

</Style>

<Value>=First( Fields!CurrentYearSales.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

<TextAlign>Right</TextAlign>

</Style>

<rdefaultName>OpenAmountYEAR</rdefaultName>

<Value>=FIRST(Fields!OpenAmountYEAR.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

</Style>

<Value>=FIRST( Fields!L1SalesYear.Value )+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

</Style>

<Value>=FIRST( Fields!L1StateYear.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

</Style>

<Value>=FIRST( Fields!L1COM_YT.Value )+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

</Style>

<Value>=FIRST( Fields!L2StateYear.Value )+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

</Style>

<Value>=FIRST( Fields!L2COM_YT.Value )+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</BorderWidth>

<Top>Black</Top>

</BorderColor>

<Top>Solid</Top>

</BorderStyle>

</Style>

<Value>=First( Fields!L1COM_YT.Value )+First( Fields!L2COM_YT.Value )+0</Value>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

</TableRow>

</TableRows>

</Footer>

</TableGroup>

<Style>

</Style>

<rdefaultName>MONTH</rdefaultName>

<Value>=Fields!MONTHNAME.Value</Value>

<ToolTip>Takes you back to Summary Report</ToolTip>

</Textbox>

</ReportItems>

</TableCell>

<Shading>Simple</Shading>

</ThreeDProperties>

<Style>

<BackgroundColor>White</BackgroundColor>

</Style>

<Style>

<Default>Solid</Default>

</BorderStyle>

</Style>

<Position>RightCenter</Position>

</Legend>

<Palette>Default</Palette>

<Value>=IIF(FIRST( Fields!SLSAMNT.Value )/FIRST( Fields!L1Sales.Value ) = 0, "", FIRST( Fields!SLSAMNT.Value )/FIRST( Fields!L1Sales.Value ))</Value>

</DataValue>

</DataValues>

<Style>

</Style>

</DataLabel>

<Style>

<BackgroundColor>=IIF(

FIRST( Fields!SLSAMNT.Value )/FIRST( Fields!L1Sales.Value ) < .8,

"RED",

IIF(

FIRST( Fields!SLSAMNT.Value )/FIRST( Fields!L1Sales.Value ) <1,

"YELLOW",

"GREEN"))</BackgroundColor>

</BorderWidth>

<Default>Solid</Default>

</BorderStyle>

</Style>

</Marker>

</DataPoint>

</DataPoints>

</ChartSeries>

</ChartData>

<Axis>

<Style>

<Default>Solid</Default>

</BorderStyle>

</Style>

</MajorGridLines>

<Style>

<Default>Solid</Default>

</BorderStyle>

</Style>

</MinorGridLines>

</Axis>

</CategoryAxis>

<DataSetName>Complete</DataSetName>

</StaticMember>

</StaticSeries>

</SeriesGrouping>

</SeriesGroupings>

<Subtype>Plain</Subtype>

<Hidden>=IIF(FIRST( Fields!SLSAMNT.Value )/FIRST( Fields!L1Sales.Value ) = 0, TRUE, FALSE)</Hidden>

</Visibility>

<Style>

<BackgroundColor>White</BackgroundColor>

</BorderWidth>

<Default>Solid</Default>

</BorderStyle>

</Style>

</PlotArea>

<Axis>

<Style>

<Default>Solid</Default>

</BorderStyle>

</Style>

</MajorGridLines>

<Style>

<Default>Solid</Default>

</BorderStyle>

</Style>

</MinorGridLines>

</Axis>

</ValueAxis>

</Chart>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<ToggleItem>MONTH</ToggleItem>

</Visibility>

<Value>=First( Fields!PreviousYear.Value )+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<rdefaultName>SLSAMNT</rdefaultName>

<ToggleItem>MONTH</ToggleItem>

</Visibility>

<Value>=First(Fields!SLSAMNT.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<rdefaultName>OpenAmount</rdefaultName>

<Value>=FIRST(Fields!OpenAmount.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<ToggleItem>MONTH</ToggleItem>

</Visibility>

<Value>=First( Fields!L1Sales.Value )+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<ToggleItem>MONTH</ToggleItem>

</Visibility>

<Value>=First( Fields!L1State.Value )+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<ToggleItem>MONTH</ToggleItem>

</Visibility>

<Value>=First( Fields!L1COM.Value )+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<ToggleItem>MONTH</ToggleItem>

</Visibility>

<Value>=First( Fields!L2State.Value )+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<ToggleItem>MONTH</ToggleItem>

</Visibility>

<Value>=First( Fields!L2COM.Value )+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<ToggleItem>MONTH</ToggleItem>

</Visibility>

<Value>=First( Fields!L1COM.Value ) + FIRST(Fields!L2COM.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

</TableRow>

</TableRows>

</Header>

<GroupExpression>=Fields!MONTH.Value</GroupExpression>

</GroupExpressions>

</Grouping>

<Style>

</Style>

<rdefaultName>textbox21</rdefaultName>

<ToggleItem>MONTH</ToggleItem>

</Visibility>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox22</rdefaultName>

<ToggleItem>MONTH</ToggleItem>

</Visibility>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<rdefaultName>textbox23</rdefaultName>

<ToggleItem>MONTH</ToggleItem>

</Visibility>

<Value>=Fields!MONTHNAME.Value & " Total"</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<ToggleItem>MONTH</ToggleItem>

</Visibility>

<Value>=First(Fields!PreviousYear.Value )+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<ToggleItem>MONTH</ToggleItem>

</Visibility>

<Value>=First(Fields!SLSAMNT.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<rdefaultName>OpenAmount_1</rdefaultName>

<Value>=FIRST(Fields!OpenAmount.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<ToggleItem>MONTH</ToggleItem>

</Visibility>

<Value>=First (Fields!L1Sales.Value )+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<ToggleItem>MONTH</ToggleItem>

</Visibility>

<Value>=First (Fields!L1State.Value )+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<ToggleItem>MONTH</ToggleItem>

</Visibility>

<Value>= Fields!L1COM.Value+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<ToggleItem>MONTH</ToggleItem>

</Visibility>

<Value>=First (Fields!L2State.Value )+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<ToggleItem>MONTH</ToggleItem>

</Visibility>

<Value>= Fields!L2COM.Value+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<ToggleItem>MONTH</ToggleItem>

</Visibility>

<Value>= Fields!L1COM.Value+Fields!L2COM.Value+0</Value>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

<ToggleItem>MONTH</ToggleItem>

</Visibility>

</TableRow>

</TableRows>

</Footer>

</TableGroup>

<Style>

</Style>

<rdefaultName>DOCDATE</rdefaultName>

<ToggleItem>MONTH</ToggleItem>

</Visibility>

<Value>=Fields!DOCDATE.Value</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox17</rdefaultName>

<ToggleItem>MONTH</ToggleItem>

</Visibility>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox31</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<ToggleItem>DOCDATE</ToggleItem>

</Visibility>

<Value>=Sum(Fields!SLSAMNT_Detail.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox124</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

<ToggleItem>MONTH</ToggleItem>

</Visibility>

</TableRow>

</TableRows>

</Header>

<GroupExpression>=Fields!DOCDATE.Value</GroupExpression>

</GroupExpressions>

</Grouping>

<Style>

</Style>

<rdefaultName>textbox25</rdefaultName>

<ToggleItem>DOCDATE</ToggleItem>

</Visibility>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox26</rdefaultName>

<ToggleItem>DOCDATE</ToggleItem>

</Visibility>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<rdefaultName>textbox27</rdefaultName>

<ToggleItem>DOCDATE</ToggleItem>

</Visibility>

<Value>= Fields!DOCDATE.Value & " Total"</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox34</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<ToggleItem>DOCDATE</ToggleItem>

</Visibility>

<Value>=Sum(Fields!SLSAMNT_Detail.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox131</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

<ToggleItem>DOCDATE</ToggleItem>

</Visibility>

</TableRow>

</TableRows>

</Footer>

<SortExpression>=Fields!DOCDATE.Value</SortExpression>

<Direction>Ascending</Direction>

</SortBy>

</Sorting>

</TableGroup>

<Style>

</Style>

<rdefaultName>textbox16</rdefaultName>

<ToggleItem>DOCDATE</ToggleItem>

</Visibility>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>CUSTNAME</rdefaultName>

<ToggleItem>DOCDATE</ToggleItem>

</Visibility>

<Value>=Fields!CUSTNAME.Value</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox32</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

<TextAlign>Right</TextAlign>

</Style>

<rdefaultName>SLSAMNT_Detail_1</rdefaultName>

<ToggleItem>DOCDATE</ToggleItem>

</Visibility>

<Value>=Sum(Fields!SLSAMNT_Detail.Value)+0</Value>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox128</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

<ToggleItem>DOCDATE</ToggleItem>

</Visibility>

</TableRow>

</TableRows>

</Header>

<GroupExpression>=Fields!CUSTNAME.Value</GroupExpression>

</GroupExpressions>

</Grouping>

</TableGroup>

</TableGroups>

<Style>

</Style>

<rdefaultName>textbox7</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox15</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox19</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox39</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox138</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox49</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox42</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox69</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox99</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

<rdefaultName>textbox89</rdefaultName>

</Textbox>

</ReportItems>

</TableCell>

<Style>

</Style>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

</TableRow>

</TableRows>

</Footer>

</TableColumn>

</TableColumn>

</TableColumn>

</TableColumn>

</TableColumn>

</TableColumn>

</TableColumn>

</TableColumn>

</TableColumn>

</TableColumn>

</TableColumn>

</TableColumn>

</TableColumns>

</Table>

</ReportItems>

</Body>

<ConnectString>data source=CLYDE;initial catalog=RGU_COM</ConnectString>

</ConnectionProperties>

</DataSource>

</DataSource>

</DataSources>

<DataField>SLPRSNID</DataField>

<rd:TypeName>System.String</rd:TypeName>

</Field>

<DataField>MONTH</DataField>

<rd:TypeName>System.Int32</rd:TypeName>

</Field>

<DataField>MONTHNAME</DataField>

<rd:TypeName>System.String</rd:TypeName>

</Field>

<rd:TypeName>System.Int32</rd:TypeName>

</Field>

<DataField>SLSAMNT</DataField>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

<DataField>CurrentYearSales</DataField>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

<DataField>OpenAmount</DataField>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

<DataField>OpenAmountYEAR</DataField>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

<DataField>PreviousYear</DataField>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

<DataField>PYTotal</DataField>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

<DataField>L1Sales</DataField>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

<DataField>L1SalesYear</DataField>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

<DataField>L2Sales</DataField>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

<DataField>L2SalesYear</DataField>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

<DataField>L1State</DataField>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

<DataField>L1StateYear</DataField>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

<DataField>L2State</DataField>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

<DataField>L2StateYear</DataField>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

<DataField>DOCDATE</DataField>

<rd:TypeName>System.DateTime</rd:TypeName>

</Field>

<DataField>CUSTNAME</DataField>

<rd:TypeName>System.String</rd:TypeName>

</Field>

<DataField>DOCNUMBR</DataField>

<rd:TypeName>System.String</rd:TypeName>

</Field>

<DataField>SLSAMNT_Detail</DataField>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

</Fields>

<Query>

<CommandType>StoredProcedure</CommandType>

<CommandText>RGU_Commissions_Complete_WithOpenOrders</CommandText>

<Value>=Parameters!Year.Value</Value>

</QueryParameter>

</QueryParameters>

</Query>

</DataSet>

<DataField>SLPRSNID</DataField>

<rd:TypeName>System.String</rd:TypeName>

</Field>

<DataField>MONTH</DataField>

<rd:TypeName>System.Int32</rd:TypeName>

</Field>

<DataField>MONTHNAME</DataField>

<rd:TypeName>System.String</rd:TypeName>

</Field>

<rd:TypeName>System.Int32</rd:TypeName>

</Field>

<DataField>SLSAMNT</DataField>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

<DataField>ORDERAMOUNT</DataField>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

<DataField>PreviousYear</DataField>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

<DataField>L1Sales</DataField>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

<DataField>L2Sales</DataField>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

<DataField>L1State</DataField>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

<DataField>L2State</DataField>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

<rd:TypeName>System.Decimal</rd:TypeName>

</Field>

</Fields>

<Query>

<CommandType>StoredProcedure</CommandType>

<CommandText>RGU_Commissions_YEAR_WITHOPENORDERS</CommandText>

<Value>=Parameters!Year.Value</Value>

</QueryParameter>

</QueryParameters>

</Query>

</DataSet>

</DataSets>

<MIMEType>image/jpeg</MIMEType>

<ImageData>/9j/4AAQSkZJRgABAgEASABIAAD/4QvHRXhpZgAATU0AKgAAAAgABwESAAMAAAABAAEAAAEaAAUAAAABAAAAYgEbAAUAAAABAAAAagEoAAMAAAABAAIAAAExAAIAAAAcAAAAcgEyAAIAAAAUAAAAjodpAAQAAAABAAAApAAAANAACvyAAAAnEAAK/IAAACcQQWRvYmUgUGhvdG9zaG9wIENTMiBXaW5kb3dzADIwMDU6MTI6MTUgMjE6Mzg6NTgAAAAAA6ABAAMAAAAB//8AAKACAAQAAAABAAABM6ADAAQAAAABAAAAWQAAAAAAAAAGAQMAAwAAAAEABgAAARoABQAAAAEAAAEeARsABQAAAAEAAAEmASgAAwAAAAEAAgAAAgEABAAAAAEAAAEuAgIABAAAAAEAAAqRAAAAAAAAAEgAAAABAAAASAAAAAH/2P/gABBKRklGAAECAABIAEgAAP/tAAxBZG9iZV9DTQAC/+4ADkFkb2JlAGSAAAAAAf/bAIQADAgICAkIDAkJDBELCgsRFQ8MDA8VGBMTFRMTGBEMDAwMDAwRDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAENCwsNDg0QDg4QFA4ODhQUDg4ODhQRDAwMDAwREQwMDAwMDBEMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwM/8AAEQgALgCgAwEiAAIRAQMRAf/dAAQACv/EAT8AAAEFAQEBAQEBAAAAAAAAAAMAAQIEBQYHCAkKCwEAAQUBAQEBAQEAAAAAAAAAAQACAwQFBgcICQoLEAABBAEDAgQCBQcGCAUDDDMBAAIRAwQhEjEFQVFhEyJxgTIGFJGhsUIjJBVSwWIzNHKC0UMHJZJT8OHxY3M1FqKygyZEk1RkRcKjdDYX0lXiZfKzhMPTdePzRieUpIW0lcTU5PSltcXV5fVWZnaGlqa2xtbm9jdHV2d3h5ent8fX5/cRAAICAQIEBAMEBQYHBwYF

NQEAAhEDITESBEFRYXEiEwUygZEUobFCI8FS0fAzJGLhcoKSQ1MVY3M08SUGFqKygwcmNcLSRJNUoxdkRVU2dGXi8rOEw9N14/NGlKSFtJXE1OT0pbXF1eX1VmZ2hpamtsbW5vYnN0dXZ3eHl6e3x//aAAwDAQACEQMRAD8A9VXK/WL6619OyTgYDBkZTNLHAF7Wu/0Wxjmb7P3/AH/o1e+s/XaenYduNXZtz76iMdo7F36Nlm7+svMW7bmZHpMt3kU+m0OLjG5/rgekK3bPT2fmKbFj4tZD0tjl8PGeKQPD9gL3nQ/rx9oy2YXVqxi23GKrHNNQJiWg+oXt930d2/6a6wPa4loIJb9IA8fFeKCamV1ubY1gsl1W4slu3T22ts/R7/5z9Gt36t/We/o2S6p9RyKMx9ZILofWHABkHb+k2Meny5cys4xsLq/++RzcMeEcZPDEyEB+kDOXZ9QSVPP6nVg+nvpyL/VmPs1L7o2/6T0Wu9Pn27vprO/539Pf0zI6pRRlW4mPjvyxaaXVssrZr+hsyPSa5zvzFWYHdSTD7k6SlJLPzut4uHmVYLq7rsq+t91VVNZcSysgWu3+2v2bmfn/AJ6hV9Y+j2dJs6w7IFODTuF1lzXVmtzHelZTbVa1trbm2/ovS2b7LP5tJTppLLZ1+l11VZw82uu9wZXe/He1ku0Z6rXfp8fd/wB2aaVZwOqYnUHZTcYuccK92LfuaWxawNe9rd30/bYz3pKbaSqdO6ni9SoffilxrZa+l29pYd9TjVaIeB9Gxu1DzetYWJlMwosyM2xhsbjY7HWPDAdvq27P0ePVu9rLMiyr1f8ABJKb6Sp9O6nXni3bTfj2Uu2WVZFZrdqJa5s+y2t3+kqe9XElKSSSSUpJJJJT/9B/rXk1P65m1WseXNuYWvDojSv/AL4ss4bLa330ue5wcQ1mhDgHHUbo/SLQ+udfp/WLIPHqNrePu2/99VfAIFBkwA4yToOf9qtZojB

yuPNiuzITnEnihMyPr/u8X9RoDNmxDmzDJKPBKEo0flGTL6uEf9Uad+K+lpLiHDds3NMDd4D897m/nqxjBr8wnbIqE1kCIBLdu7+q122pLqjm7qKxEgOeQPFzvpf2lGl1xe2mlp91lTnlv7sMbsP8ncn3PLykJ+mEskZ3K/bjGHySmZf1sfH/AOGIhmy58Gc5ZyyGM+XmOI8XDZni9P7vzvsNRmmT4Lj6I/8AGkMf+VD/APz05dY7f9jf6dYufsdtqcdocY9tbnw7Zv8Ao7tq4xn1h6g7pw6dV9ULRgOYWfZiLBXtPuLNn2MM2qpGBlt+dOnHHKd8NadzGP8A0kvX87qXQs7qn7OvvuP7IdmbbnuvDL2Xeicyqu71K6PTqtfbZRSyvE/RfzC2ujdLysPO+0/tU5WHkYwFeK51lu9zXNcOoMyMrIyrG/o7PTfXj7Mf9JW/9xYh679Ybcn7V/zTLsg1HH9V7vcaSd7qHOfS39E5/u2IXTrPrD002O6V9UcfCdcZscx7Gk99vNf6Nv8Ao/5tH2pf1f8AGiu9ifUxH+HD/vnU+sI6k76zYP7Ksqrzh07NNHrsL63O34e2t+yyl1e//TfpPT/0NiyLMvpjOm/V/MaHV9Px+ql3WfXINlOcRdNvU3xW2p9XUbPUsseymj+Y9NldXoK27I+vFuXXnO+r2IcqppZXc6xm9rXfTY1/2jdtcox9dH2ZNj/q708uzmtZmbnMPrNaCxjcgeu5t2xjtn6T8xL2z3j/AIwV7J/eh/jxei631TJwLelsoax4z81mJbvnRjq7rnPr2n6f6D85Ufqk5rcv6xVuID29Wse5hOoa6nF9N5b+4/a7YsXE6P8AWHFtZdR9Wum1PqdvqizRjv36Weo9lLv+LRcvpf1hz8r7Zm/Vzpl+RAa6x9klzRwy7/TM9v0Ld6XAe8f8ZHtH96H+NF1/qRfTkdFsyKHB9V2bm2VvHDmuyb3scP6zSqv1TtYzr/1kxcsgdV

fm+vDtHvwyyuvp7mH/AAlVLd7P+B3/APCKWK/64YrXtx+jYFLbXute1l5bL3ndZY6GfTe76SFn4nXupuY7qX1ewMl9X81acj3t/wCLt9P1Gf2XocB7j/GCvbPeP+NFl1Pq3UcmjqePv+y/YeqYOJTbjFzbCy63CdZ6hdub7qsv0/o+mp42IcvrvUejXX5lWH03HxzhtblXtseck3235b8r1fteRssrbj1etfbVR6KjRg9Qox3Y7Pq5itqssbdY1t7DusYQ9l1jnM3WWse3dvejZtGd1Cxtmd9X2XWMaWB/r17tjv5ylz97HPos/Ppf+isS4D3H+NFHtnvH/Gi0fqp1XqedndJdm5D7fW6bmFx1Yy005dGPi5fo/wA262zF/Sep/wAN+5YqXQsnM6gPq1TfnZT6cxnVnXlt9jXXNZc1uNvvY9t36Fjv0FldnqM/M/RrbzMezOZj1531ZbezEIOO02Y7hXG0bax6ntr9jf0f82qWZ0WzM6l0ieiel0/C+2mzH3VBjX3Cq2qwejZ7fUu9f6DUDE+H2hBgR2/xout9VLcs4+fjZF78qvBzrsbFyLJL30sFbttlrv6RZj3PuxLL/wB/H9/6RbipYgupqZRTh141NYDa62PDWtaOGsZXXta1XG7o90A+WqCCKf/R2Prp0PLycw5mMGuDq21vrdofY4vY+t373u2rk/TyqnuxnsLPUBa5tntbBLTPqfRa5u1ewXHHNc5ADZGodEj/ADdyxc2n6vuDvVvaxveWkj5+1WIZcsYCPAJQ4vSZRP8AOn+b1jw+r+b4WCePERnHEAckYxym/krJjlCR/d9UYQfPXdO2tGx7nv0FVQElxMbmf5y6r6q/Vq6p4yMuHWEgho4bA2/2nK30uj6rtyCcbJY+yOAx40n8ze3bt3fuLqcf0do9GC3yTck+aMKzmUtd5Q9v93T/ABlvJ4o44ZBHIMnEY8fDXCOE/qv+clY3a0DwUk0nwS1ULZXSTe5N7klMk

k3uS1SUukm1Te5JTJJR9yXuSUulIUUklMpCafJMkkleSmSSSU//2f/tEHBQaG90b3Nob3AgMy4wADhCSU0EJQAAAAAAEAAAAAAAAAAAAAAAAAAAAAA4QklNA+0AAAAAABAASAAAAAEAAQBIAAAAAQABOEJJTQQmAAAAAAAOAAAAAAAAAAAAAD+AAAA4QklNBA0AAAAAAAQAAAAeOEJJTQQZAAAAAAAEAAAAHjhCSU0D8wAAAAAACQAAAAAAAAAAAQA4QklNBAoAAAAAAAEAADhCSU0nEAAAAAAACgABAAAAAAAAAAI4QklNA/UAAAAAAEgAL2ZmAAEAbGZmAAYAAAAAAAEAL2ZmAAEAoZmaAAYAAAAAAAEAMgAAAAEAWgAAAAYAAAAAAAEANQAAAAEALQAAAAYAAAAAAAE4QklNA/gAAAAAAHAAAP////////////////////////////8D6AAAAAD/////////////////////////////A+gAAAAA/////////////////////////////wPoAAAAAP////////////////////////////8D6AAAOEJJTQQIAAAAAAAQAAAAAQAAAkAAAAJAAAAAADhCSU0EHgAAAAAABAAAAAA4QklNBBoAAAAAA0UAAAAGAAAAAAAAAAAAAABZAAABMwAAAAgAaQBtAGcAXwBsAG8AZwBvAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAABAAAAAAAAAAAAAAEzAAAAWQAAAAAAAAAAAAAAAAAAAAABAAAAAAAAAAAAAAAAAAAAAAAAABAAAAABAAAAAAAAbnVsbAAAAAIAAAAGYm91bmRzT2JqYwAAAAEAAAAAAABSY3QxAAAABAAAAABUb3AgbG9uZwAAAAAAAAAATGVmdGxvbmcAAAAAAAAAAEJ0b21sb25nAAAAWQAAAABSZ2h0bG9uZwAAATMAAAAGc2xpY2VzVmxMcwAAAAFPYmpjAAAA

AQAAAAAABXNsaWNlAAAAEgAAAAdzbGljZUlEbG9uZwAAAAAAAAAHZ3JvdXBJRGxvbmcAAAAAAAAABm9yaWdpbmVudW0AAAAMRVNsaWNlT3JpZ2luAAAADWF1dG9HZW5lcmF0ZWQAAAAAVHlwZWVudW0AAAAKRVNsaWNlVHlwZQAAAABJbWcgAAAABmJvdW5kc09iamMAAAABAAAAAAAAUmN0MQAAAAQAAAAAVG9wIGxvbmcAAAAAAAAAAExlZnRsb25nAAAAAAAAAABCdG9tbG9uZwAAAFkAAAAAUmdodGxvbmcAAAEzAAAAA3VybFRFWFQAAAABAAAAAAAAbnVsbFRFWFQAAAABAAAAAAAATXNnZVRFWFQAAAABAAAAAAAGYWx0VGFnVEVYVAAAAAEAAAAAAA5jZWxsVGV4dElzSFRNTGJvb2wBAAAACGNlbGxUZXh0VEVYVAAAAAEAAAAAAAlob3J6QWxpZ25lbnVtAAAAD0VTbGljZUhvcnpBbGlnbgAAAAdkZWZhdWx0AAAACXZlcnRBbGlnbmVudW0AAAAPRVNsaWNlVmVydEFsaWduAAAAB2RlZmF1bHQAAAALYmdDb2xvclR5cGVlbnVtAAAAEUVTbGljZUJHQ29sb3JUeXBlAAAAAE5vbmUAAAAJdG9wT3V0c2V0bG9uZwAAAAAAAAAKbGVmdE91dHNldGxvbmcAAAAAAAAADGJvdHRvbU91dHNldGxvbmcAAAAAAAAAC3JpZ2h0T3V0c2V0bG9uZwAAAAAAOEJJTQQoAAAAAAAMAAAAAT/wAAAAAAAAOEJJTQQRAAAAAAABAQA4QklNBBQAAAAAAAQAAAABOEJJTQQMAAAAAAqtAAAAAQAAAKAAAAAuAAAB4AAAVkAAAAqRABgAAf/Y/+AAEEpGSUYAAQIAAEgASAAA/+0ADEFkb2JlX0NNAAL/7gAOQWRvYmUAZIAAAAAB/9sAhAAMCAgICQgMCQkMEQsKCxEVDww

MDxUYExMVExMYEQwMDAwMDBEMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMAQ0LCw0ODRAODhAUDg4OFBQODg4OFBEMDAwMDBERDAwMDAwMEQwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAz/wAARCAAuAKADASIAAhEBAxEB/90ABAAK/8QBPwAAAQUBAQEBAQEAAAAAAAAAAwABAgQFBgcICQoLAQABBQEBAQEBAQAAAAAAAAABAAIDBAUGBwgJCgsQAAEEAQMCBAIFBwYIBQMMMwEAAhEDBCESMQVBUWETInGBMgYUkaGxQiMkFVLBYjM0coLRQwclklPw4fFjczUWorKDJkSTVGRFwqN0NhfSVeJl8rOEw9N14/NGJ5SkhbSVxNTk9KW1xdXl9VZmdoaWprbG1ub2N0dXZ3eHl6e3x9fn9xEAAgIBAgQEAwQFBgcHBgU1AQACEQMhMRIEQVFhcSITBTKBkRShsUIjwVLR8DMkYuFygpJDUxVjczTxJQYWorKDByY1wtJEk1SjF2RFVTZ0ZeLys4TD03Xj80aUpIW0lcTU5PSltcXV5fVWZnaGlqa2xtbm9ic3R1dnd4eXp7fH/9oADAMBAAIRAxEAPwD1Vcr9YvrrX07JOBgMGRlM0scAXta7/RbGOZvs/f8Af+jV76z9dp6dh241dm3PvqIx2jsXfo2Wbv6y8xbtuZkeky3eRT6bQ4uMbn+uB6Qrds9PZ+YpsWPi1kPS2OXw8Z4pA8P2AvedD+vH2jLZhdWrGLbcYqsc01AmJaD6he33fR3b/prrA9riWgglv0gDx8V4oJqZXW5tjWCyXVbiyW7dPba2z9Hv/nP0a3fq39Z7+jZLqn1HIozH1kguh9YcAGQdv6TYx6fLlzKzjGwur/75HNwx4Rxk8MTIQH6QM5dn1BJU8/qdWD6e+nIv9WY+zUvujb/pPRa70+fbu+ms7/nf09/TMjqlFGVbiY+O/LFppdWyytmv6G

zI9JrnO/MVZgd1JMPuTpKUks/O63i4eZVguruuyr633VVU1lxLKyBa7f7a/ZuZ+f8AnqFX1j6PZ0mzrDsgU4NO4XWXNdWa3Md6VlNtVrW2tubb+i9LZvss/m0lOmkstnX6XXVVnDza673Bld78d7WS7Rnqtd+nx93/AHZppVnA6pidQdlNxi5xwr3Yt+5pbFrA172t3fT9tjPekptpKp07qeL1Kh9+KXGtlr6Xb2lh31ONVoh4H0bG7UPN61hYmUzCizIzbGGxuNjsdY8MB2+rbs/R49W72ssyLKvV/wAEkpvpKn07qdeeLdtN+PZS7ZZVkVmt2olrmz7La3f6Sp71cSUpJJJJSkkkklP/0H+teTU/rmbVax5c25ha8OiNK/8AviyzhstrffS57nBxDWaEOAcdRuj9ItD651+n9Ysg8eo2t4+7b/31V8AgUGTADjJOg5/2q1miMHK482K7MhOcSeKEzI+v+7xf1GgM2bEObMMko8EoSjR+UZMvq4R/1Rp34r6WkuIcN2zc0wN3gPz3ub+erGMGvzCdsioTWQIgEt27v6rXbakuqObuorESA55A8XO+l/aUaXXF7aaWn3WVOeW/uwxuw/ydyfc8vKQn6YSyRncr9uMYfJKZl/Wx8f8A4YiGbLnwZzlnLIYz5eY4jxcNmeL0/u/O+w1GaZPguPoj/wAaQx/5UP8A/PTl1jt/2N/p1i5+x22px2hxj21ufDtm/wCju2rjGfWHqDunDp1X1QtGA5hZ9mIsFe0+4s2fYwzaqkYGW3506cccp3w1p3MY/wDSS9fzupdCzuqfs6++4/sh2Ztue68MvZd6JzKq7vUro9Oq19tlFLK8T9F/MLa6N0vKw877T+1TlYeRjAV4rnWW73Nc1w6gzIysjKsb+js9N9ePsx/0lb/3FiHrv1htyftX/NMuyDUcf1Xu9xpJ3uoc59Lf0Tn+7YhdOs+sPTTY7pX1Rx8J1xmxzHsaT3281/o2/wCj/m0fa

l/V/wAaK72J9TEf4cP++dT6wjqTvrNg/sqyqvOHTs00euwvrc7fh7a37LKXV7/9N+k9P/Q2LIsy+mM6b9X8xodX0/H6qXdZ9cg2U5xF029TfFban1dRs9Syx7KaP5j02V1egrbsj68W5dec76vYhyqmlldzrGb2td9NjX/aN21yjH10fZk2P+rvTy7Oa1mZucw+s1oLGNyB67m3bGO2fpPzEvbPeP8AjBXsn96H+PF6LrfVMnAt6WyhrHjPzWYlu+dGOruuc+vafp/oPzlR+qTmty/rFW4gPb1ax7mE6hrqcX03lv7j9rtixcTo/wBYcW1l1H1a6bU+p2+qLNGO/fpZ6j2Uu/4tFy+l/WHPyvtmb9XOmX5EBrrH2SXNHDLv9Mz2/Qt3pcB7x/xke0f3of40XX+pF9OR0WzIocH1XZubZW8cOa7Jvexw/rNKq/VO1jOv/WTFyyB1V+b68O0e/DLK6+nuYf8ACVUt3s/4Hf8A8IpYr/rhite3H6NgUtte617WXlsved1ljoZ9N7vpIWfide6m5jupfV7AyX1fzVpyPe3/AIu30/UZ/ZehwHuP8YK9s94/40WXU+rdRyaOp4+/7L9h6pg4lNuMXNsLLrcJ1nqF25vuqy/T+j6anjYhy+u9R6NdfmVYfTcfHOG1uVe2x5yTfbflvyvV+15GyytuPV619tVHoqNGD1CjHdjs+rmK2qyxt1jW3sO6xhD2XWOczdZax7d296Nm0Z3ULG2Z31fZdYxpYH+vXu2O/nKXP3sc+iz8+l/6KxLgPcf40Ue2e8f8aLR+qnVep52d0l2bkPt9bpuYXHVjLTTl0Y+Ll+j/ADbrbMX9J6n/AA37lipdCyczqA+rVN+dlPpzGdWdeW32Ndc1lzW42+9j23foWO/QWV2eoz8z9GtvMx7M5mPXnfVlt7MQg47TZjuFcbRtrHqe2v2N/R/zapZnRbMzqXSJ6J6XT8L7abMfdUGNfcKrarB6Nnt9S71/oNQM

T4faEGBHb/Gi631Utyzj5+NkXvyq8HOuxsXIskvfSwVu22Wu/pFmPc+7Esv/AH8f3/pFuKliC6mplFOHXjU1gNrrY8Na1o4axlde1rVcbuj3QD5aoIIp/9HY+unQ8vJzDmYwa4OrbW+t2h9ji9j63fve7auT9PKqe7Gews9QFrm2e1sEtM+p9Frm7V7Bccc1zkANkah0SP8AN3LFzafq+4O9W9rG95aSPn7VYhlyxgI8AlDi9JlE/wA6f5vWPD6v5vhYJ48RGccQByRjHKb+SsmOUJH931RhB89d07a0bHue/QVVASXExuZ/nLqvqr9WrqnjIy4dYSCGjhsDb/acrfS6Pqu3IJxslj7I4DHjSfzN7du3d+4upx/R2j0YLfJNyT5owrOZS13lD2/3dP8AGW8nijjhkEcgycRjx8NcI4T+q/5yVjdrQPBSTSfBLVQtldJN7k3uSUySTe5LVJS6SbVN7klMklH3Je5JS6UhRSSUykJp8kySSV5KZJJJT//ZADhCSU0EIQAAAAAAVQAAAAEBAAAADwBBAGQAbwBiAGUAIABQAGgAbwB0AG8AcwBoAG8AcAAAABMAQQBkAG8AYgBlACAAUABoAG8AdABvAHMAaABvAHAAIABDAFMAMgAAAAEAOEJJTQQGAAAAAAAHAAYBAQABAQD/4TkeaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wLwA8P3hwYWNrZXQgYmVnaW49Iu+7vyIgaWQ9Ilc1TTBNcENlaGlIenJlU3pOVGN6a2M5ZCI/Pgo8eDp4bXBtZXRhIHhtbG5zOng9ImFkb2JlOm5zOm1ldGEvIiB4OnhtcHRrPSIzLjEuMS0xMTEiPgogICA8cmRmOlJERiB4bWxuczpyZGY9Imh0dHA6Ly93d3cudzMub3JnLzE5OTkvMDIvMjItcmRmLXN5bnRheC1ucyMiPgogICAgICA8cmRmOkRlc2NyaXB0aW9uIHJkZjphYm91dD0

iIgogICAgICAgICAgICB4bWxuczp4YXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyI+CiAgICAgICAgIDx4YXBNTTpEb2N1bWVudElEPnV1aWQ6MTc5MUY0ODRFRDZEREExMUFFM0FFRTc3Qjc1RTEzMUU8L3hhcE1NOkRvY3VtZW50SUQ+CiAgICAgICAgIDx4YXBNTTpJbnN0YW5jZUlEPnV1aWQ6MTg5MUY0ODRFRDZEREExMUFFM0FFRTc3Qjc1RTEzMUU8L3hhcE1NOkluc3RhbmNlSUQ+CiAgICAgIDwvcmRmOkRlc2NyaXB0aW9uPgogICAgICA8cmRmOkRlc2NyaXB0aW9uIHJkZjphYm91dD0iIgogICAgICAgICAgICB4bWxuczp4YXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iPgogICAgICAgICA8eGFwOkNyZWF0ZURhdGU+MjAwNS0xMi0xNVQyMTozNDozMi0wNzowMDwveGFwOkNyZWF0ZURhdGU+CiAgICAgICAgIDx4YXA6TW9kaWZ5RGF0ZT4yMDA1LTEyLTE1VDIxOjM4OjU4LTA3OjAwPC94YXA6TW9kaWZ5RGF0ZT4KICAgICAgICAgPHhhcDpNZXRhZGF0YURhdGU+MjAwNS0xMi0xNVQyMTozODo1OC0wNzowMDwveGFwOk1ldGFkYXRhRGF0ZT4KICAgICAgICAgPHhhcDpDcmVhdG9yVG9vbD5BZG9iZSBQaG90b3Nob3AgQ1MyIFdpbmRvd3M8L3hhcDpDcmVhdG9yVG9vbD4KICAgICAgPC9yZGY6RGVzY3JpcHRpb24+CiAgICAgIDxyZGY6RGVzY3JpcHRpb24gcmRmOmFib3V0PSIiCiAgICAgICAgICAgIHhtbG5zOmRjPSJodHRwOi8vcHVybC5vcmcvZGMvZWxlbWVudHMvMS4xLyI+CiAgICAgIC

AgIDxkYzpmb3JtYXQ+aW1hZ2UvanBlZzwvZGM6Zm9ybWF0PgogICAgICA8L3JkZjpEZXNjcmlwdGlvbj4KICAgICAgPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIKICAgICAgICAgICAgeG1sbnM6cGhvdG9zaG9wPSJodHRwOi8vbnMuYWRvYmUuY29tL3Bob3Rvc2hvcC8xLjAvIj4KICAgICAgICAgPHBob3Rvc2hvcDpDb2xvck1vZGU+MzwvcGhvdG9zaG9wOkNvbG9yTW9kZT4KICAgICAgICAgPHBob3Rvc2hvcDpIaXN0b3J5Lz4KICAgICAgPC9yZGY6RGVzY3JpcHRpb24+CiAgICAgIDxyZGY6RGVzY3JpcHRpb24gcmRmOmFib3V0PSIiCiAgICAgICAgICAgIHhtbG5zOnRpZmY9Imh0dHA6Ly9ucy5hZG9iZS5jb20vdGlmZi8xLjAvIj4KICAgICAgICAgPHRpZmY6T3JpZW50YXRpb24+MTwvdGlmZjpPcmllbnRhdGlvbj4KICAgICAgICAgPHRpZmY6WFJlc29sdXRpb24+NzIwMDAwLzEwMDAwPC90aWZmOlhSZXNvbHV0aW9uPgogICAgICAgICA8dGlmZjpZUmVzb2x1dGlvbj43MjAwMDAvMTAwMDA8L3RpZmY6WVJlc29sdXRpb24+CiAgICAgICAgIDx0aWZmOlJlc29sdXRpb25Vbml0PjI8L3RpZmY6UmVzb2x1dGlvblVuaXQ+CiAgICAgICAgIDx0aWZmOk5hdGl2ZURpZ2VzdD4yNTYsMjU3LDI1OCwyNTksMjYyLDI3NCwyNzcsMjg0LDUzMCw1MzEsMjgyLDI4MywyOTYsMzAxLDMxOCwzMTksNTI5LDUzMiwzMDYsMjcwLDI3MSwyNzIsMzA1LDMxNSwzMzQzMjs3NzVFRDE3NzZFRTIxMjBFODFEMTRFNDM1OUM3Mjg1Qjwvd

GlmZjpOYXRpdmVEaWdlc3Q+CiAgICAgIDwvcmRmOkRlc2NyaXB0aW9uPgogICAgICA8cmRmOkRlc2NyaXB0aW9uIHJkZjphYm91dD0iIgogICAgICAgICAgICB4bWxuczpleGlmPSJodHRwOi8vbnMuYWRvYmUuY29tL2V4aWYvMS4wLyI+CiAgICAgICAgIDxleGlmOlBpeGVsWERpbWVuc2lvbj4zMDc8L2V4aWY6UGl4ZWxYRGltZW5zaW9uPgogICAgICAgICA8ZXhpZjpQaXhlbFlEaW1lbnNpb24+ODk8L2V4aWY6UGl4ZWxZRGltZW5zaW9uPgogICAgICAgICA8ZXhpZjpDb2xvclNwYWNlPi0xPC9leGlmOkNvbG9yU3BhY2U+CiAgICAgICAgIDxleGlmOk5hdGl2ZURpZ2VzdD4zNjg2NCw0MDk2MCw0MDk2MSwzNzEyMSwzNzEyMiw0MDk2Miw0MDk2MywzNzUxMCw0MDk2NCwzNjg2NywzNjg2OCwzMzQzNCwzMzQzNywzNDg1MCwzNDg1MiwzNDg1NSwzNDg1NiwzNzM3NywzNzM3OCwzNzM3OSwzNzM4MCwzNzM4MSwzNzM4MiwzNzM4MywzNzM4NCwzNzM4NSwzNzM4NiwzNzM5Niw0MTQ4Myw0MTQ4NCw0MTQ4Niw0MTQ4Nyw0MTQ4OCw0MTQ5Miw0MTQ5Myw0MTQ5NSw0MTcyOCw0MTcyOSw0MTczMCw0MTk4NSw0MTk4Niw0MTk4Nyw0MTk4OCw0MTk4OSw0MTk5MCw0MTk5MSw0MTk5Miw0MTk5Myw0MTk5NCw0MTk5NSw0MTk5Niw0MjAxNiwwLDIsNCw1LDYsNyw4LDksMTAsMTEsMTIsMTMsMTQsMTUsMTYsMTcsMTgsMjAsMjIsMjMsMjQsMjUsMjYsMjcsMjgsMzA7MUVBQkRBMjVEMUE5RDk1RTVDQzEwQkQ3OThEODY5OUU8L2V4aWY6TmF0

aXZlRGlnZXN0PgogICAgICA8L3JkZjpEZXNjcmlwdGlvbj4KICAgPC9yZGY6UkRGPgo8L3g6eG1wbWV0YT4KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICA

gICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgIC

AgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgI

CAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAg

ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICA

gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC

AgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgI

CAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg

ICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICA

gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC

AgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgI

CAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg

ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICA

gICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgIC

AgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgI

CAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAg

ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAKPD94cGFja2V0IGVuZD0idyI/Pv/uACFBZG9iZQBkQAAAAAEDABADAgMGAAAAAAAAAAAAAAAA/9sAhAACAgICAgICAgICAwICAgMEAwICAwQFBAQEBAQFBgUFBQUFBQYGBwcIBwcGCQkKCgkJDAwMDAwMDAwMDAwMDAwMAQMDAwUEBQkGBgkNCgkKDQ8ODg4ODw8MDAwMDA8PDAwMDAwMDwwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAz/wgARCABZATMDAREAAhEBAxEB/8QA7gABAAEEAwEAAAAAAAAAAAAAAAkFBgcIAQIEAwEBAAICAwEAAAAAAAAAAAAAAAECBgcDBAUIEAAABQQBAgMIAQIHAAAAAAABAgMEBQAGBwgREBITFQkgMEBQITEUFiI0GEEjMzUXNxkRAAEDAwIDBQUDBwgHCQAAAAECAwQRBQYAEiExB0FRExQIYXGRIjKBscGhQlKyMxU3ECAwQFDwciTR4WKCkiMWonPTNHWVtXYXEgABAwEEBQgIBAYDAAAAAAABABECAyESMgQxQVFhcRBQgZGxwRMzoSJCUnKSwgUg0fFiYOGCsiMUU2Nz/9oADAMBAQIRAxEAAACfwHxNeex26vSmceLrfRIAAAAAAAAAAAAAAAA80It/ayWO7LdhVqnBKXg+sNyet0byrTsAAAAAAAAAAAAAAAdTTzsduFLMdkeLsdvxzy3D0PG2O62LzV4tjV4RfkAAAAAAAAAAAAAAGEa8UOeX7H1O9jJ8kxxW5NrRRdma/I++Wv8AuSiYLseOlO4UzhGIkRR2B0IwQbimKz0mPyQIj+JAjWAohyb

dHcAAAAEVWO65j4zTx7X9nfdEyzxuvo9T11xr3dHpyE6N6EtntbHjNWlCVifWyJLHBl6IkFVhOXzsjGiZg1dfTT1MpCsXi0oKIYyZo10NQC9ihlCM3mFk3FM7dxGcEAQi7B19otsfU2U9F/R934R880vO+xhfcXtVjHdrSG/P2JSx5TsaL1aVNSO9bzGEiSlGXERELfE+szuHEamo4W3oVjuWmRVhnTIaaHGWC1UZsTqzM1sqxtDEXojYcAh1y7EY2tz6TyZpX6bzDoT5to2ZX1x+qPayXpneOzHs67mvwLY2vXb9G3+fuWLN/Le1s2moTfm3Ljq1q3M+cx7E15GRVcYxGQq1vaY9da454ODKMcF3UrdFeK0IZHVsKsao8XHulM5WRV60uGvD3hFtkOPRPbt0Pe+s/qfJ2mflqyto8+MNt+jdeAfSUhuvdeyucGXasen72rno+zcFOGt0rXK8VZpw1alapStTrx1COP21r7Ij0xX7S+sR9Yj5xPW09JfA8y3ws8q3StqNw9HOFYuCOOv04vrEjRD0fPhl2toyn9b6hq8fJVS8ibd9719htbfVsvPjYhsbV6AAAAAAAAAAAAeaLjg6nSLDH1uPSm1dO/R9eyPM0v7de4vmbOdtSA9jIdkZitnIAAAAAAAB1OifnFvmlE8HAAABwUpGPJjGSLQRnlOVov7ZpycJ6nByDg5AOwOp84tyczHURPAAAAAABiDs9vL/AFuoOsvlD7gAAAAAAAAAAAAAAAA//9oACAECAAEFAOpGh1KVbnS+SCNRDAFlDEQTEyCK9PW3hLGLx8iapeIoYTkKRsQ5VmyZCmQ5TlGB1CiQxfkBlU06jI9MhXKQnERUIBe9SmKHhEt4xjs77ctzOfj59uovVsXX4MfLz7RFkwZqyDZOCWMMvEpNm0M3GJUjJZzKr/H4/XBNxIxyMi1vxgmxjYG9ncIxcXBLRcLJpqpRgTKMRF2wbvD4+zFex6A8jkcncz5rH7

UXE3Mc+DO204m6veOaRwCPAIMVVw8ocDQQrkaCEc15I5oIJcaCAVGv19agt9Wht9Wv19avIFgryFWjQS1eQrV5EvRoNwFDDuC0MYsFDHLBRmKgUDJShZrBQtFqOioSvxz14JwoUxChDjpaynZIsXiLxO8GIvULWst9cSONrPdQ8hKF5bfsLeAaLzUnKjUdIfiUNwDQ3AehuBSjT69GnXI0M25oZpyNDLuBrzVxQybga8yc15k5GvMHNDIOK8xcV5i4oJBxXmDivMXAV5m5oJNzQyi9DKLUq6OtXjmGhUEaEeesQ8Izd20ixbHlxMR5HwBLbcJ5Ziysoy7I+ej5l+R0mcPr8TzXNc1z7BREBSmHCQXm8fTaqcauKsagdk2L9vheffc1zXPTmua5rmua5rmua5rmua5rmuevNc+/ef6/QPkn/9oACAEDAAEFAOqDBdYV2aiAgHHyS3IozlcqTZEqjRs7CUZnarmIJfkTBD8hfxFUqbskVU1WiRSpoGUSueQjEjkOQwfHrOkGwQUQmCTxE568UyQEFdxTBAzdPLBSBP49OcxaDoPxmQhDw32SrgUTUuM8RAs86NBJJ5vKdOxcgzbqVzXHptp3H/2otD7A0PQaL1DoPug6D7GQCcoK/wAiZBS7rINyBllTHQso/bO55R7XePg4LRaGhoKHoNDQdB6F6G6BQ0FD0D2B9m80u9iYPpcxPFx+mPNCHLe1DdszntHltj4eQH6A0jHLooW4+NQWy+oLYfUFrvaJajs1FtJzQWi4r9RXr9RXr9RcUNouK/UXFDaTqv1N2FDabuhtR2FGt90Whg3IUaHXLQxawV5YtQxywV5etR250q/EWNQtFgoyJy1xx0upLvjjl/iYnj49SN/liPJbZ/3POaQGiLRh1mCQjxULMhHia8Pr+4KUa71xo92Oho10vBobnejQ3K+GjXC+Ghnnw0M4+oZt9XnT0a85eUMu8GvNnlBLvArzh5XnDygmnoUE09rzt

2FFnXYV566GnD5VwP5J+BVMauea4GuBqVbC5avIV0zGzifl2OCfaPbVvh2yV3TCL8wjyPxPbXbXaFdodeKEgGqJlVo5B/YiomTgXh1oS3m8aUfv8JwNAWuArgK4CuA9wIUJa7a7aAvTtrtrtrtrtCu0K7QrtCu0K7QrtrtrtoC1wFcBXaFdoVx75/8A1PUfkf8A/9oACAEBAAEFAOi6yaCd3bO4ntGRsXYbGN/OUjkUL8idLJt0tuNpGxlEHORbgSYvcnWapqfs7C3rbkTf1ozsqXj5AYeA3ByYvZGN7vYyyUjkS3yR152s1KwPZKE65a6u50Gz8jWnettXkzAeQ+OzXlRnjS1co5jnMvShGbczieaSN4S6bdWEdMopsxbXiiDab9PeQfsruya2yfK2pshl3cnXZxa9jbVIzetz+acbnF56nHiojNWxN/bnXFnnYzX7ZnYbP9n65Y+tFnuLlCFtu1dvLQyzsPnfLePtoueKwlnXL96bg8cjsvs9a+u8NCWht7eUZjaD22tLLhPd7gSpVb7lbKZmuhWxZecUexk3HO0UXa4QLFiSecODSpNU2beEvyKHua+pSmVR/wAfTG1m3Lfu5eAXV7Yn23gc0yWxOVtTprOTfKn+CN/y2M/UfwQ0ht2Mj7MPhvz1HO7+NybL42tjNm1hCKbyh99bil/9CjfZF3/yV6s/2CJ2ixfM5xXJlrKG69zT12WnkbZrG+Qtc8c7E5yuS7LS9Q657nszV/dO58mWngXYzBWcbJszW7Kx84YP675JHPeDB46YSFkvFXzqRtptLSqrKKnStHaSMunGLy1xazgBMixH9L6nMs2jH3P01qdtnG68SukX1PdVssWrqnlmxc5Y0ydcAffDMszV9VPM1uy+imf95rIuKakcHbpYGzXb2QLqtS5/VF9Q55J4zzWrtNrslaWjt0zVy7tD9R3PsDIeANlsYbXYAyvB4xuK3Lj9VjFLtuf1LthnJMGb2bvZDgnuuu2F

jPMDYH9QzYTFF/60b2TDKK1nzpsTi9rifVDE8jg/XrrvnHUUeBsUw+MIB33m5BvYbIEyLxc21gpPR549f5GjR4aZsv3WWEl1N3damxGG3GnVvTR9ydSDXNfe1mluSUoLeTWGwodb1IMRlFpu7rZF3LOeoZiK4I22PUAwraMXP7L6Z3ZIWttjqBZD2Y9QjBFwxtu7LaQ2nMNd3dXWNzp+ong0QJ6guAndO780KuZzZ2VdTrKdx2X9eULnmsu4gvCLstxq3jl7MZWw/csZFMdUIW3vUImrFuLDNksNasbLp5GshUrW54N8YggYK3riyq2Ss3XauLPXK3XnrpY284ve52kxbTUQ8VaNVmbg1Gx35FPRv0bbSayf3BoNvTLAAbemjawUh6a+Myi39OLCaVIenngJOkNAtdyUlolralSWkWsqVJ6aa1p0nqNrklSeqevBKLq5r4Sg1j1/Cia04BTr+3DAtDrTgEwjrNr+NDrJr8aj6ua9Ho2qGvBhNqfr/R9ScFKAnqZhxuN5aZYWvuDRxpbaB0bWhm5iIpJl7yV3lrbiyn944+uPzmkDgCTmXNcLQ+PJf8ycgpO3l8IYmm7kmMa2kSNatSdiXxArc14w14xqMoYwdLst8ZJvkTCTCWPeWt6hRjLIm7JSLIFOlYGFnM5KWDjhGPSjIxNokHAfBGEArxCUZUaE5xrvNXcajfzD2hKBqewzJ6WZxqwfBN4N8YjDXhFB9a2O28VSLdJAoKgFCsFeN9RV5oFTBXjGrxjV4x68Y9eMavGNXjV49GVEQ7jUBzBQqHGhMYa5Hj3uvf8A0H0N9ifI/wD/2gAIAQICBj8A5XiHQvBn5lc6kwTIx5jAZ0IxDbULysRvRe0MgacDYLWTEEceYHqSux1nYo5mkb0ToO1CIV0B2RjOLAhEDRayAG0qFGnig97+pm7DzBThCnKbk2RDl7GHA61mc19xy0qssrdiGDAA3vV4xYPxVPOzjOMKgEhAan18Nqp

5qhOE4TFhG5rONtq/yEAbl4tH1ZAh94WY+6ip/iFNzS/dEG6fSVXzeYLyqEEfD6zDmCoDrb6lVylTBVDHo0dqp5el5dKQiFmMtQiL1VxGZLGmwL3d8r3oX2/K0SJZjMhvFdzEOHvbze9CEKxvVIxjel7x/kq+Zq2gRAA96UnujpVWZsMpOR7pL2cwDenVXcR3ocFQAhfum83DWqxNruX7uhZSnCBlSjMeKxZonbt0FZbL5WAjTjEswZ8Ok606vQi6wLQ3La3StIHBY1bNWTWNYx0rHFYolauhWclo5bVZy26+W3lp69JbcBaehRrUZ34kEPvBtCr0Rsf5XU5ZWpGM6ZZpe076ODW8VXn9whdqCmbh9631ur1etVX93uUs1WtYARiNM5F2HDavFz9muERohE6uNgfklY95vQ/5qyCwKyA6VZGIWro5MTLGsaxrGsaxrGehY5LHJYz0rGsaxrGrZP0OtXyjvQvatwHYrFb+ClXnaISBPBV55et4kMxO/d/4yXf5vpRMRaDFvTYdx1qtmcnTvZeuL1SLsadS31o7pOepf7NaJEr5p+EC87Pb6e5Vq1An1LC+kaWB6io0o6k+7mFwWRc3hobaqcxUuRpxuiPV+SESNOvavBjr0pv4In8R7eZ//9oACAEDAgY/AOVoxdNMNzLeqYY9/wCiYaEYa0YatSt18xRp3bz9yEIU7gYvv/TvQMouXKNyLWIRnS8QP1KNLxrkw7w2aE8ZXhzBfrzuQ1lQz9Kd+nLCVAAtF7d6uwhrKu1A0XCkPZM1WMdLBVxLVc+rmChea68ix0Ei6zqD17kaTXBHQN3T3Kn9z+51pV69UPAe7LVH0of7OVn4msjWVIZDLSFQhr09ENnX3KllczXvQqyYvp29WxCcNFSnE9qr/wBH1cwU5bCfpR3hZGWy73IkbVbqWV+MLKT96J+lV+Mfq5gO7ky8vdhH0/ogdy6Vlj+4LJ1P+yX9oVc/B2STq9Ti4WBYFhZWt0

rTEK2cVjirZxVk4rHFY4rHFWTitMSvZXspjd62Xs/MO9W3fmivZ+Ydy1dEl/N+QXtehYXWBesG5am5kVGOymond2IrLf8ApHtVEi2QqgAbXClKrZ4giQNjXvz5JPF7zeh/zRu03VlMDirIRVgiF7KsIHBY1jXmLzSF5x6FbWkvNkvNkvNkvNkvNkvNkrK0lbVJ4rH2d60g8REq278sUDJrNgA08Eyt/BOmNJXr02FrLwWZoTRjsJ5MtPZVj1PavBo4Y9tj9ifmFpaFKhHBIEHpUp0KjmRJbihl5Biv3lnT/wAEVPjl2nmf/9oACAEBAQY/AP5FOOrS22kVUpR2gAdpOnLVMvKrhPZO11mAy5I2nuJbQqn26EG0XxMe4Gu2FLQ4w4adwcQiv2ctBaFBSVAEKHEcf7DU664G20JJUomnD3nhpzA8DurjiG1KbyS6xDRsLSAPKoeHNSuO6nKnt14sJTkO3njtTsjR0Gp4Ba+Kv8XbpmbPhfvuyoO+Q0NslITUfOh1r50KSeIUNQsUyq6GHltvQ4mN59RSZkdtR2utuL/abQaKI5cK6kWW0X2JcLnEBL0RlYWtIHPly1w40oPb/YBPYAdPRbbKXEuN/lM2xh5tW1aUvGjq0q7NqKmvZqzOC62iRZHJ7ECDBtz3iLjoddoXlpPBTiq7lE6yDH5M6ZcYdsW01H3vLbStCkBVdqCANT27dOmW9ESG7JjoYfcUPEbFQlSVEpUD3HVxvd1vlkDV1eVNt8R2QW3IskJA8RIb4p38lJHsrp6XlkmLHtrzfkZklSAwiKGySlLQTzBqSSdJn45eot2jLAKXIzgcFCK8actV/J/X505qQy5fXklFptzpNXXDTkE0JpXjpu2XuaqZKtjT78KC2wWmEPeGQU1UpRUoDl3asrrhdixoktt+U6wAXAW9pTUHnRSTUam5OjIbNNnT1JEjzDvlVgNjakeGe2nOmn1S7tEkLU0ptMG3krUSsUNXDp5hiOEIk

SAqKhfzlKlk9vtPPS4yiEqbZZ8RKBtTu8MFW38dZQh2QtVtucJpyO0pe7i0pwKp3fUNIidI75ZsayuRLYre77GcmRY8Wqi6Qw2Ula1UCU/MOeumLU/qjg+TjqbflWKOqNi643klVao4sKlr3/tewjlqBIzLr1is+wxn0quFttWHhiRIbB3FtMh6csN14DcGzr1n2q4X653S1WBywCzQJ0t6QzDROadkLajodUQ2jca0SAPfTRrThwoB/KPae+n9+NBrqr6cLVn1pw7FMKhPXi3XhrH2LhL8AohLZZUZDwSf/ODjT83XSjpD1KyaxdVun/WKbGiWjI27Oi0XKIqRLTDUCiK4WyWlrQVVB3BQpSh09nOW+NPfekN2/GschlPnbpPcFUsspNaAAFS1bflSCRVVEmJkuVZljXp4i3ZlMm34XZ7InIbxHacSFITPm3GR5dLgFKhtnh+dQ8Bg6cj6tWjq50cubs1nLXF2CHZrvApAfXEcAiq2OIMkNpUpKuH6HHh6dulOHXW3RsQ6syYzN/ZlwEyJKfCnhEosulaCAWFADgaU593aadvDjQfeddeOjWTXS2PYF0wiyJNmjRoAalrL8iMmIHJAUr6G3FV4ca67Kj6SK+0cRqyNvWuRmXUDM5PkMC6e29VJVwlKKEJUtYSsttJW4gKISpRJGxJOmbvlvWTG+kFwlth1OHYpjDN48nvG4Nv3C6yHUuuI+lQbb2bq0UoUOmbV1M6hWTqr0hnWqYuNkcSzxbRco1ybWz4CJLDBCQlaVLoWyofKa7eFacKU4U95/o7Ih6Uhpli3q8IrXs2kqFSPhqyuWu7utSLqVuBxT1S0oJJLgT2g6kRrVcENvszTDMxS9vgOiit7g7jXUmDdbY07LiK2SXmPoURwC0+xVK62R2UsBPFxZFdo/DVrZUt24R3ZB80wpfyE7T9PuOoNhVEHnWpy2o1yK/nShSqFtXuAFNJt0EUaYtSm1GtakKSSfiTpB7SB+OvS

eFcz1QiIH+8uOfw1StK69bON2zOrv0/x59/GXcjuuOKbjXp5aIhEVmNPcQ75ZB3OFwoTvVRG1SQFV6j+nC4dS8l6lYA5hEfNMYl5dLVcbnAkGTHjrZ82pKCUq8VRKQKfSdo47ursjJJvVWL0c6fX1WMYRjfTKDdkM3CRFBTMmXW52ZHmFFdEltkLSAlYJrrqrhmR2nPpnQOCwib0uyvqPHeZvbb4VHS5CU/KIkSGyFuFBcJKQ32V48teprLbT09vnUn924aHLjZMfdiolsRW4dkdcleHJda8VKNgTsbJWSoEAgHWN+q3JrjCiWvpTJdtHT/pPBcW9JtkxpwuKmXuQtLaVvLKkuNttICAEp+ZRB16Y+muQf8AOxTGIsS7xLa9Xw1zVqmTVOUPMqMFhPDtRrs3Dh7K8uXtPDWPdAboLyjqFlTbMiysswFuRHGXm3lh0yEmgCfAWFV5bdeiMmvGTOJ48P2yaUHt56r21pr1lLP1Jt9vCft8pX7tEVoaVqRUDuP2akw8mHmoHS+2LbxSC8attqiWhL6FJHYQ/Mcd+zRI4cyVHgKU7T7vu1cvT1B/fH/6RaS8bhGct7iIjbbDAkl3zJO0pUhaad9deoLocjrZleGdNIWK2y7CPY5CGZsQPs29ZYtz7rbiY2919wrWlJUUAp4V10U9FGDdUcnenXy2zsj6idW73KbuOTM2VlUh1qLHkLZ8NLshTKmg4psqbRs2g6m9dOh3WDO3r1g70STl2L5ZkErIrVdre64lh5xyPPU4G3ELWlZU3tASFUSKDXoW6gYZfbxh8bqtnFidyC1Wyc9FS81JVFVIgyg2seMhDm5G1Xdw1leR4fkt1xLILfdLOmJebNMegSUofmNsOoDrBC9qkOKqNelu+YFnV8xrJLnluJ2W5S4c2Q0m4G4QSrbPDa0rfQXWApQPMbqmhOsi659L/Up1DndTMFiO3+649c5jDmOXOHDSXpkZmzNMtRmAhtKlNpoutNpJUre

npv1UfjtRJ+XWdt67xI5JZanMKXHmIa3EkID7S9tSeHaef8zGH1fQYkhBNafnt6gzo7yxIhr3MlZ3AEA8NXqW+EtuS5KXpCTyKjTiNW2e8+WBAPFpB+V0hXyhY7QOPx1fJ00LYttmklMiAhvYHVJHYe0cOGo86EnyjKbg2qM2fzEFVAnTttZCwp2ctxakc207qqVpTQVuS3bgkLP1KooCp+Gk/wB+/XpUL7yGi11CE9RVzDURUTxFD3FxPx1SoHYPuH4a9dBadqrzGJI8P2sQnm3P+1rKm91FudGGmwjhVShPjLoK/wCyK66++nbrReI+FN3LMJGT4NlF0WWYE6NOGxJU+r5Wi4y0ytBVw+vjq94905yJnOBjcZD98yGzf5m0sOPLKWovn26sOPqCVKKG1qKQKq21FaVB2nly7+zXqGQiQlSpeKuQ4+47Sp6OxZd6AefJtRoOwV7NW71GdPYbx6A9U57du60YdDbK2YMl5alCS03yRUqU6yRyVvZHyuJ10X9bnQB5GYLwRuI/cnLcDIRItbL6pUOYEoG5bSVOutvgUIQpPIJJFvuELObTimSusoN2wm/zWYE+I/QBxtHjlpMhIUTRbdR37TwHp1fsF9tl7ZgYROiTJcCSzKaRK8rflhpTjK10UEqBoeVdelL1AuWuRMw7BLy9FyeUw2pYYBkx3ihZSDxeZL20U47T3a/60X1kxNywhgOhSLnHXLWaV8NMNCi+p01A8MN7tep285PZZeMXnMLJ+/IeN3AeHLjwHpsR6G3IaoNjgjSGipJG4V46NO3hWlO2n5NYp60um1gfyPHGhGT1FgREFXgOMseQfDxQFKbalQ6Nh3btQ4KqPEBUS84x1PsLLz7aVSMfus1i23KMop+Zp6LJcQs7VHbuSCgn6VKpXXVK6WG5w7xbpGFpjxrpCebkMOvM261IcCXG1KBKdhSfdr1NMJkIL3/QFjCmgfm3Ns2gq4doSFpr79dFPUFlRXC6V5bj7u

GX/JykmNbZpRKS2ZDlNrSSHml1PNCHO7WSYVic+PleadYRFxvp5jlpdRLlXGTMfaUtbLbKiopaaStZUOCSBXnr0UP3Bh2daehGXWBeby4iS6lpTbSHpDgCafIXWXEIJ7SnV1xfpzmlsz+5X2Za7jPasL6Z37ttseU2tUub4JX5dBd8NpPiU3LWKfSaelm/zH0ptds6h4JcpctHzJTHYt8l5xxKgaABKa1PZrJYOI5Za+oOZZ3Y5tp6d4Ljcpq53S8XC4R1sRW2YsZanAgLWFOuEBLaQpStdLemN5KDfMctAN+S0oLQifMecmSm0KHApQ68pII50r2/zMcuH6EhaP8AiSn/AEaSfbT8mrjTky4ws/dp2iqHcajv41/HU7c95ZDssoK/0q0on7dRN4+VMlk1/wB8U1l7rzyWZLyFG3KWK1c40HsrrIZM+SuTIchslZJqlJ3L4J7tI9x+/VqtPXBnGrheosQzLPDvdpTdH2I76ylS2asPFrepnmKV2+zSW0Z4tSGxtS23ap9EgcPl/wAuBw5UGrtkVjQxbL9fdy77fbfjj0eZMKqOEvvoYQ44eNaKJ0M0EBxeYpYENGUHHSLiWCKBrzJQHAih5FQ1FRn+FDOUwR/k13fHGpi2kqoSG3HaqAPCoBoe3UfHsHxG52KxQyry1ns9miwIyFGlSGUutpFe+nHVGsQyx6hG2rUNFeNOH+aJ7e7UrMrX0Ifh5ZIW68/lLFutTNwdU+kB1S5SVeKSsc6njqXZb30lu1/skxAbn2u4CDIjPJqkhLjDxWlYFAeI0iyYx0duOKWOOpbrNqtDcCNFQtZqrawzsSNx4mg07dMn9LcG83R5W96c/Z7M466vmStailSj/irqLc8O9OLWL3SOd0e42ux2SNJbUrgdrzTiVjn2HUuyZB05yO92e4NKbn2yZEtkqO83WhStt2WUqHsUNM5Fjfpyax69x1+LHukPHrK0+wtIrVpbb5LaqfoEV1NzOJ0yuMDLr

g2pq45Y3Zrc3cXgoJSW3JSHi8oEITX5iOGvmtuTJ48aw2j8NrxFNKYfi5EEPJKFoVbUupUlXApUA6TQ+7S7xcehMCXMlL3SJK8IZKnFK/OWUNEKr38dNy8E6XDFJzbZQ1PsmEOxH9jgO5IdjxEq40oeOpmY23DZkTMbmhTdyyhjDJ7dxeStKAUuy0Q/FUCG0jio8tScfyfHrpkFnngIm2e7YtcJEVYpUBbb0QoPsrx05eME6bQMLujqPDNztuJSIknY4aFIdbhhYSacRy1cLDkKHLxZbggx7larjYZ78V9s0JS407FUlSfeOer1ilo6e47bsYyBbL+RWBnFiiHNWy4HGjKa8oG3ShQCkhYNOzXRrGMZajLslv6uYpb12NuGqPHbiFiaz5dLJbSkI2/JtCaDTzmA4tieDTZO5EuXaLQxAfWeSkuPNMJWo1qOJPbrcjJIihWlApVftG2ukiFcBKKuWxDhHH2hI1UV49/D+RmfQFyJMaKK/wC2dpGksyWSw9RKth/RP0kfDV0eUoANstrIPaAvjT46itzo760T0eKl1HJINKV+PDUNi0PJdhKmAzA7+1SpP0/edNqPJLzSh3/tBz1OiMHZVRced7EI5FX2amXuLHcbhyGEsCS5zfKdx3j46aSqtVAHt7v9WsQMC9QsZuWOvyfN3d+Mp916K8hFGQEqRUBSAeJ92h53rFuVUlaWbIBxJJNCZw+7Q811TurtOfhW5hv9Z5zQ8xn2Tud/hohIr8WV01V/JsxkHu83CQPgIP46+d3J36cy5cWhX/gjJ1/zLTepNP07m8P1AjQ34fNf/wC8us78Hhr+HJdPeu6XT8JQGuHS+Iru3zbgr75J1RPSu1q/xOSlfe/rh0nsh96HT97h18vSPHVe+MT95Ov4Q40f8UNKvv0dvR/FTX9K3Mr/AFkmmv4P4n/7VG/8PVVdHcTJ/wDS44+5Gv4O4r9luZH3JGv4P4wPdBbH3DXzdIccFe1MUJ/VI1Ud

K7Q37WvGb/VcGqDp60z3eBOntfqSE6Iaxm6RfaxkF6a/VmjQLUXKE0PAJyq/AciOQne3Vsx6/tZPItlpvTV+hBWR3J5YmMtqaaWXJEh5RSgLVRII58a6ccQ/d1LdcLqy5dZxG5Rqrh41OPdpPgsvI28iZD6z7zuWrSQkUDY4E6+ofHX1D46u9stiQuYkh9lPf4ZSeGoca8WtUGXaWzFW8fqdCVVG73V4e/UpKHQgvNFCnB2d1ffq2265O+Bcra2GYshSNzbiTQAL7qU4aMFl5ssCOl794r4I3cyke6ukw5SW3n5TaVRA3yUoEcvjpV3u8Nxm2rShLbTv1OFNSRqOENeChIRsR3AClPs0kf1kcCKe3/VrgPj/AHGuQ92qcvd/K6jZvChxBFdPqlWhpzfWq9nHjp390KMVfHYlaOA7tp063Os37xccAS/cG0B00TWnA8uekmOy664pXgsQkpKHFOHkNp5Dv1Gv2SRBJkAJTCgkVbYR3D2nhX3aYAYSgppwSmgp2Ae7SEhNO/7NEDs/qQqQPfr6vv1RPx19R+zhr6j8dfUfjqi/mHceP8+hFdEOspNeZppXhtpBV7NVY2LUr60FPCnx151Vvjh8Hg4GxXTanWk1R2U4aCG0BIHcNU2n2a4JNdV2/l1wTT38dchrkPy/6dchrs12a5DXIa+n8uvp/LogAivbXX1H46qFHX1U92uKift1QqJHtNf6bof/APQMa/8Aio38w/2H/9k=</ImageData>

</EmbeddedImage>

</EmbeddedImages>

<rd:SnapToGrid>true</rd:SnapToGrid>

<rd:ReportID>0e94a6bc-aa26-4fba-9383-f53a962c1cb7</rd:ReportID>

<DataType>Integer</DataType>

</Values>

</DefaultValue>

</ReportParameter>

</ReportParameters>

</Report>

Beratung SSC Eights! Points: 940 More actions · Answer 5

Any help with this at all would be greatly appreciated. I'm dying here. This is not the only report we are having this problem with and they are crucial reports to the business.

Thanks,

Darin

some dude-341195 Newbie Points: 9 More actions · Answer 6

Did you ever find a solution to this? I have the EXACT same problem. We had our previous intranet reporting system written in asp.net. The particular report that wont export exported fine in asp.net in about 10 seconds. In SQL Reporting 2005 the report renders to the page fine, but when we export it to excel it just sits there trying to load and it never does...

marty.seed SSCrazy Points: 2661 More actions · Answer 7

marty.seed

SSCrazy

Points: 2661

April 6, 2009 at 7:51 am

#972532

Another user with the same problem!

marty.seed SSCrazy Points: 2661 More actions · Answer 8

marty.seed

SSCrazy

Points: 2661

April 6, 2009 at 8:10 am

#972547

Another user with the same problem!

tiffanyjanetblack SSCommitted Points: 1877 More actions · Answer 9

Another user with same problem.

Frankly, the only thing I've really noticed is if the output rowcount is very high or if the output columncount is very high (or both of course) then Excel just can't handle it. I've had this happen many a time and sadly I just ran the report's query in SSMS and dumped to excel and moved on. I'd really appreciate knowing a better solution...without having to rewrite the report in excel which I detest. 🙂

James Perry Right there with Babe Points: 718 More actions · Answer 10

how many rows does the report contain and how many groups does it have? What version of excel are you using?

Jim Russell-390299 SSCrazy Eights Points: 9333 More actions · Answer 11

If you reach the point where you want to try another approach, I have had excellent luck letting the workbook "pull" the data from the server on demand, using Import External Data. Lots of flexibility, including the ability to leave formulas in the template workbook. Best part, the data shown is always up to date.

itzik-408638 SSC Rookie Points: 30 More actions · Answer 12

I have a report that export to excel it takes about an hour to get the data and about 30 min to render it creates an Excel spreadsheet 90 Meg in size, it has 46,000 rows but a lot of columns.

But I had a few reports that just choked when tried to render to Excel and I ended up writing an SSIS package that wrote to Excel.

This report is my next candidate to move to SSIS.

The rendering extension for Excel can't handle large sizes of data.

Thanks,

Itzhak