This report provides summary information about the alerts generated by all monitored Network Device devices during a defined period. Jalasoft Xian Network Manager collects data for this report (using alerts generated by one or more rules included in the Jalasoft Xian NM plug-in for Network Devices).
| Accessibility | Public |
| Visible | True |
Home
<Report ID="Jalasoft.Xian.OpsMgr2007MP.Report.NetworkDevice.JsXNetworkDeviceSnmpDeviceElement_Alert.Summary" Accessibility="Public" Target="Standard_Snmp_Rfc1213!Jalasoft.Xian.Common.Elements.Standard.Snmp.Rfc1213.JsXNetworkDeviceSnmpDeviceElement" Visible="true">
<ParameterBlock xmlns="http://schemas.microsoft.com/mom/reporting/2007/ReportParameterSettings" columns="2">
<Controls>
<Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.RelativeDateTimePicker" rowSpan="3" columnSpan="1">
<ReportParameters>
<ReportParameter name="TimeZone" binding="TimeZone"/>
<ReportParameter name="TimeZoneName" binding="TimeZoneName"/>
<ReportParameter name="StartDate_BaseType" binding="StartDate_BaseType"/>
<ReportParameter name="StartDate" binding="StartDate_BaseValue"/>
<ReportParameter name="StartDate_OffsetType" binding="StartDate_OffsetType"/>
<ReportParameter name="StartDate_OffsetValue" binding="StartDate_OffsetValue"/>
<ReportParameter name="EndDate_BaseType" binding="EndDate_BaseType"/>
<ReportParameter name="EndDate" binding="EndDate_BaseValue"/>
<ReportParameter name="EndDate_OffsetType" binding="EndDate_OffsetType"/>
<ReportParameter name="EndDate_OffsetValue" binding="EndDate_OffsetValue"/>
</ReportParameters>
</Control>
</Controls>
</ParameterBlock>
<Definition>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="DataWarehouseMain">
<DataSourceReference>Data Warehouse Main</DataSourceReference>
</DataSource>
</DataSources>
<BottomMargin>1in</BottomMargin>
<RightMargin>1in</RightMargin>
<PageWidth>11in</PageWidth>
<ReportParameters>
<ReportParameter Name="StartDate">
<DataType>DateTime</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>Start Date</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate">
<DataType>DateTime</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>End Date</Prompt>
</ReportParameter>
<ReportParameter Name="TimeZone">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>Time Zone</Prompt>
</ReportParameter>
<ReportParameter Name="TimeZoneName">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>TimeZoneName</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate_BaseType">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>StartDate_BaseType</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate_OffsetType">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>StartDate_OffsetType</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate_OffsetValue">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>StartDate_OffsetValue</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_BaseType">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>EndDate_BaseType</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_OffsetType">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>EndDate_OffsetType</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_OffsetValue">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>EndDate_OffsetValue</Prompt>
</ReportParameter>
<ReportParameter Name="DeviceType">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Jalasoft.Xian.Common.Elements.Standard.Snmp.Rfc1213.JsXNetworkDeviceSnmpDeviceElement</Value>
</Values>
</DefaultValue>
</ReportParameter>
<ReportParameter Name="PluginName">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Jalasoft Xian NM plugin for Network Devices</Value>
</Values>
</DefaultValue>
</ReportParameter>
</ReportParameters>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>11in</InteractiveWidth>
<rd:GridSpacing>0.05in</rd:GridSpacing>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ReportItems>
<List Name="NoDataList">
<Left>0.7in</Left>
<DataSetName>ReportData</DataSetName>
<Top>3.45in</Top>
<NoRows>There is no data available for this report. This may occur when there are no alerts generated for Network Device devices for the selected date range.</NoRows>
<ZIndex>5</ZIndex>
<Visibility>
<Hidden>=iif(CountRows()>0,true,false)</Hidden>
</Visibility>
<Width>7.55in</Width>
<Style>
<TextAlign>Center</TextAlign>
</Style>
<Height>2in</Height>
</List>
<Rectangle Name="rectangle13">
<Left>0.55in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<ReportItems>
<Image Name="image7">
<Sizing>AutoSize</Sizing>
<Left>5.50714in</Left>
<MIMEType>image/png</MIMEType>
<Top>0.05in</Top>
<ZIndex>7</ZIndex>
<Width>16pt</Width>
<Source>External</Source>
<Style>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
</Style>
<Height>16pt</Height>
<Value>AlertSeverity_Unknown16x16.png</Value>
</Image>
<Textbox Name="textbox38">
<Left>5.80714in</Left>
<ZIndex>6</ZIndex>
<Width>0.95in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Unknown</Value>
</Textbox>
<Textbox Name="textbox39">
<Left>4.3381in</Left>
<ZIndex>5</ZIndex>
<Width>0.95in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Critical</Value>
</Textbox>
<Textbox Name="textbox41">
<Left>2.86905in</Left>
<ZIndex>4</ZIndex>
<Width>0.95in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Warning</Value>
</Textbox>
<Image Name="image1">
<Sizing>AutoSize</Sizing>
<Left>1.1in</Left>
<MIMEType>image/png</MIMEType>
<Top>0.05in</Top>
<ZIndex>3</ZIndex>
<Width>16pt</Width>
<Source>External</Source>
<Style>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
</Style>
<Height>16pt</Height>
<Value>AlertSeverity_Information16x16.png</Value>
</Image>
<Image Name="image3">
<Sizing>AutoSize</Sizing>
<Left>2.56905in</Left>
<MIMEType>image/png</MIMEType>
<Top>0.05in</Top>
<ZIndex>2</ZIndex>
<Width>16pt</Width>
<Source>External</Source>
<Style>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
</Style>
<Height>16pt</Height>
<Value>AlertSeverity_Warning16x16.png</Value>
</Image>
<Image Name="image6">
<Sizing>AutoSize</Sizing>
<Left>4.0381in</Left>
<MIMEType>image/png</MIMEType>
<Top>0.05in</Top>
<ZIndex>1</ZIndex>
<Width>16pt</Width>
<Source>External</Source>
<Style>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
</Style>
<Height>16pt</Height>
<Value>AlertSeverity_CriticalError16x16.png</Value>
</Image>
<Textbox Name="textbox42">
<Left>1.4in</Left>
<Width>0.95in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Information</Value>
</Textbox>
</ReportItems>
<Top>2.8in</Top>
<ZIndex>4</ZIndex>
<Width>7.85in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
</Style>
<Height>0.32in</Height>
</Rectangle>
<Rectangle Name="recReportDetails">
<ReportItems>
<Textbox Name="txtTargetCounter">
<Left>1.95in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.45in</Top>
<ZIndex>10</ZIndex>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>=Count(Fields!ManagedEntityRowId.Value, "SelectedObjectList") & " " & "element(s) found"</Value>
</Textbox>
<Image Name="imgSeparator">
<Sizing>Fit</Sizing>
<MIMEType/>
<Top>0.9in</Top>
<ZIndex>9</ZIndex>
<Source>External</Source>
<Style/>
<Height>0.05in</Height>
<Value>../gradient_portrait.gif</Value>
</Image>
<List Name="lstTargetDevices">
<ReportItems>
<Textbox Name="txtTargetNames">
<Left>1.95in</Left>
<CanShrink>true</CanShrink>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!DisplayName.Value</Value>
</Textbox>
</ReportItems>
<DataSetName>SelectedObjectList</DataSetName>
<Top>0.65in</Top>
<ZIndex>8</ZIndex>
<Visibility>
<ToggleItem>lbTargetlDeviceList</ToggleItem>
<Hidden>true</Hidden>
</Visibility>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
<DataInstanceElementOutput>NoOutput</DataInstanceElementOutput>
<Height>0.2in</Height>
</List>
<Textbox Name="lblSeparator3">
<Left>1.85in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.45in</Top>
<ZIndex>7</ZIndex>
<Width>0.1in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>:</Value>
</Textbox>
<Textbox Name="lbTargetlDeviceList">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.45in</Top>
<ZIndex>6</ZIndex>
<Width>1.85in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>Target Devices List</Value>
</Textbox>
<Textbox Name="txtGeneratedAt">
<Left>1.95in</Left>
<DataElementOutput>Output</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.05in</Top>
<ZIndex>5</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<CanGrow>true</CanGrow>
<DataElementName>Created</DataElementName>
<Height>0.2in</Height>
<Value>=Code.GetGeneratedAtTime(Parameters!TimeZoneName.Value)</Value>
</Textbox>
<Textbox Name="lblSeparator2">
<Left>1.85in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.25in</Top>
<ZIndex>4</ZIndex>
<Width>0.1in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>:</Value>
</Textbox>
<Textbox Name="lblSeparator1">
<Left>1.85in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.05in</Top>
<ZIndex>3</ZIndex>
<Width>0.1in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>:</Value>
</Textbox>
<Textbox Name="lblGeneratedAt">
<Left>0.2in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.05in</Top>
<ZIndex>2</ZIndex>
<Width>1.65in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>Generated At</Value>
</Textbox>
<Textbox Name="txtReportStartEnd">
<Left>1.95in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.25in</Top>
<ZIndex>1</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>=Code.SelectedDateValue(Parameters!StartDate.Value,Parameters!StartDate_BaseType.Value,Parameters!StartDate_OffsetType.Value,Parameters!StartDate_OffsetValue.Value) &" - "& Code.SelectedDateValue(Parameters!EndDate.Value,Parameters!EndDate_BaseType.Value,Parameters!EndDate_OffsetType.Value,Parameters!EndDate_OffsetValue.Value)</Value>
</Textbox>
<Textbox Name="lblReportStartEnd">
<Left>0.2in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.25in</Top>
<Width>1.65in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>Report Start - End Time</Value>
</Textbox>
</ReportItems>
<Top>1.413in</Top>
<ZIndex>3</ZIndex>
<Height>1in</Height>
</Rectangle>
<Rectangle Name="recTitle">
<ReportItems>
<Textbox Name="lblReportDescription">
<DataElementOutput>NoOutput</DataElementOutput>
<Top>0.3in</Top>
<ZIndex>2</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<Color>DimGray</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>Description</Value>
</Textbox>
<Textbox Name="txtReportTitle">
<Left>0.2in</Left>
<DataElementOutput>Output</DataElementOutput>
<Top>0.05in</Top>
<ZIndex>1</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>11pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<CanGrow>true</CanGrow>
<DataElementName>Title</DataElementName>
<Height>0.25in</Height>
<Value>Alerts - Summary</Value>
</Textbox>
<Rectangle Name="recDescription">
<ReportItems>
<Textbox Name="txtReportDescription">
<Left>0.2in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>This report provides summary information about the alerts generated by all monitored Network Device devices during a defined period. Jalasoft Xian Network Manager collects data for this report (using alerts generated by one or more rules included in the Jalasoft Xian NM plug-in for Network Devices).</Value>
</Textbox>
</ReportItems>
<Top>0.6in</Top>
<Visibility>
<ToggleItem>lblReportDescription</ToggleItem>
<Hidden>true</Hidden>
</Visibility>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
</Rectangle>
</ReportItems>
<Top>0.563in</Top>
<ZIndex>2</ZIndex>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
<Height>0.85in</Height>
</Rectangle>
<Image Name="imgHeaderBanner">
<Sizing>Fit</Sizing>
<MIMEType/>
<ZIndex>1</ZIndex>
<Source>External</Source>
<Style/>
<Height>0.563in</Height>
<Value>ReportHeaderLandscape.jpg</Value>
</Image>
<Table Name="tblAlerts">
<Footer>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ColSpan>8</ColSpan>
<ReportItems>
<Textbox Name="textbox10">
<rd:DefaultName>textbox10</rd:DefaultName>
<ZIndex>8</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>N/A: Not available</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
</Footer>
<Left>0.1in</Left>
<DataSetName>ReportData</DataSetName>
<Top>3.45in</Top>
<TableGroups>
<TableGroup>
<Grouping Name="tblAlerts_Group1">
<GroupExpressions>
<GroupExpression>=Fields!Id.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</TableGroup>
</TableGroups>
<Visibility>
<Hidden>=iif(CountRows()>0,false,true)</Hidden>
</Visibility>
<Width>8.8in</Width>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox9">
<rd:DefaultName>textbox9</rd:DefaultName>
<ZIndex>7</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!DName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="txtDeviceName">
<ZIndex>6</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!DeviceName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Image Name="image4">
<Sizing>AutoSize</Sizing>
<MIMEType>image/png</MIMEType>
<ZIndex>5</ZIndex>
<Source>Database</Source>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>4pt</PaddingLeft>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingTop>2pt</PaddingTop>
</Style>
<Value>=Fields!Image.Value</Value>
</Image>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Chart Name="chtAlert">
<Legend>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Position>RightCenter</Position>
</Legend>
<Subtype>PercentStacked</Subtype>
<Title>
<Style/>
</Title>
<CategoryAxis>
<Axis>
<Title/>
<MajorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<Min>0</Min>
<Margin>true</Margin>
</Axis>
</CategoryAxis>
<PointWidth>0</PointWidth>
<ThreeDProperties>
<Rotation>30</Rotation>
<Inclination>30</Inclination>
<Shading>Simple</Shading>
<WallThickness>50</WallThickness>
</ThreeDProperties>
<DataSetName>ReportData</DataSetName>
<SeriesGroupings>
<SeriesGrouping>
<StaticSeries>
<StaticMember>
<Label>Green</Label>
</StaticMember>
<StaticMember>
<Label>Yellow</Label>
</StaticMember>
<StaticMember>
<Label>Red</Label>
</StaticMember>
<StaticMember>
<Label>White</Label>
</StaticMember>
</StaticSeries>
</SeriesGrouping>
</SeriesGroupings>
<PlotArea>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
</PlotArea>
<ValueAxis>
<Axis>
<Title/>
<MajorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<Min>0</Min>
<Scalar>true</Scalar>
</Axis>
</ValueAxis>
<ZIndex>4</ZIndex>
<Type>Bar</Type>
<Palette>SemiTransparent</Palette>
<ChartData>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!Information.Value)</Value>
</DataValue>
</DataValues>
<DataLabel/>
<Style>
<BackgroundColor>DarkSeaGreen</BackgroundColor>
<BackgroundGradientEndColor>Green</BackgroundGradientEndColor>
<BackgroundGradientType>TopBottom</BackgroundGradientType>
</Style>
<Marker>
<Size>6pt</Size>
</Marker>
</DataPoint>
</DataPoints>
</ChartSeries>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!Warning.Value)</Value>
</DataValue>
</DataValues>
<DataLabel/>
<Style>
<BackgroundColor>Yellow</BackgroundColor>
<BackgroundGradientEndColor>Gold</BackgroundGradientEndColor>
<BackgroundGradientType>TopBottom</BackgroundGradientType>
</Style>
<Marker>
<Size>6pt</Size>
</Marker>
</DataPoint>
</DataPoints>
</ChartSeries>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!Critical.Value)</Value>
</DataValue>
</DataValues>
<DataLabel/>
<Style>
<BackgroundColor>Red</BackgroundColor>
<BackgroundGradientEndColor>IndianRed</BackgroundGradientEndColor>
<BackgroundGradientType>TopBottom</BackgroundGradientType>
</Style>
<Marker>
<Size>6pt</Size>
</Marker>
</DataPoint>
</DataPoints>
</ChartSeries>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!Unknown.Value)</Value>
</DataValue>
</DataValues>
<DataLabel/>
<Style>
<BackgroundColor>WhiteSmoke</BackgroundColor>
<BackgroundGradientEndColor>LightGrey</BackgroundGradientEndColor>
<BackgroundGradientType>TopBottom</BackgroundGradientType>
</Style>
<Marker>
<Size>6pt</Size>
</Marker>
</DataPoint>
</DataPoints>
</ChartSeries>
</ChartData>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>5pt</PaddingLeft>
<PaddingBottom>5pt</PaddingBottom>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>White</BackgroundColor>
<PaddingRight>5pt</PaddingRight>
<PaddingTop>5pt</PaddingTop>
</Style>
</Chart>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="txtInformation">
<ZIndex>3</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Code.FormatNumber(Fields!Information.Value,"##0", "")</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="txtWarning">
<ZIndex>2</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Code.FormatNumber(Fields!Warning.Value,"##0", "")</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="txtError">
<ZIndex>1</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>White</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Code.FormatNumber(Fields!Critical.Value,"##0", "")</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="txtSuccessAudit">
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Code.FormatNumber(Fields!Unknown.Value,"##0", "")</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
<Grouping Name="table1_Details_Group">
<GroupExpressions>
<GroupExpression>=Fields!DeviceName.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</Details>
<Style>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
</Style>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox2">
<rd:DefaultName>textbox2</rd:DefaultName>
<ZIndex>15</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>Gray</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!DName.Value</SortExpression>
<SortExpressionScope>tblAlerts_Group1</SortExpressionScope>
</UserSort>
<Value>=First(Fields!ManagedEntityTypeDefaultName.Value, "DeviceTypeDisplayName")</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ColSpan>2</ColSpan>
<ReportItems>
<Textbox Name="lblDeviceType">
<ZIndex>14</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>Gray</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!DeviceName.Value</SortExpression>
<SortExpressionScope>tblAlerts_Group1</SortExpressionScope>
</UserSort>
<Value>Object</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="lblChartAlert">
<ZIndex>13</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>5pt</PaddingLeft>
<PaddingBottom>5pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>Gray</BackgroundColor>
<Color>White</Color>
<PaddingRight>5pt</PaddingRight>
<PaddingTop>5pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value/>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="lblInformation">
<ZIndex>12</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>Gray</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Information</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="lblWarning">
<ZIndex>11</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>Gray</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Warning</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="lblError">
<ZIndex>10</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>Gray</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Critical</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="lblSuccessAudit">
<ZIndex>9</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>Gray</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Unknown</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.35in</Height>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
</Header>
<TableColumns>
<TableColumn>
<Width>1.7in</Width>
</TableColumn>
<TableColumn>
<Width>1.9in</Width>
</TableColumn>
<TableColumn>
<Width>0.25in</Width>
</TableColumn>
<TableColumn>
<Width>1.95in</Width>
</TableColumn>
<TableColumn>
<Width>0.75in</Width>
</TableColumn>
<TableColumn>
<Width>0.75in</Width>
</TableColumn>
<TableColumn>
<Width>0.75in</Width>
</TableColumn>
<TableColumn>
<Width>0.75in</Width>
</TableColumn>
</TableColumns>
<Height>0.85in</Height>
</Table>
</ReportItems>
<Height>6.5in</Height>
</Body>
<rd:ReportID>35a17b5f-7553-4dd3-8658-df45b62c3e23</rd:ReportID>
<LeftMargin>1in</LeftMargin>
<DataSets>
<DataSet Name="ReportData">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>EXEC SC_JSXIO_GetSummarizedAlertData_SP @StartDate, @EndDate, @DeviceType</CommandText>
<QueryParameters>
<QueryParameter Name="@StartDate">
<Value>=Code.GetNewTimeZone(Code.SelectedDateValue(Parameters!StartDate.Value,Parameters!StartDate_BaseType.Value,Parameters!StartDate_OffsetType.Value,Parameters!StartDate_OffsetValue.Value),Parameters!TimeZoneName.Value)</Value>
</QueryParameter>
<QueryParameter Name="@EndDate">
<Value>=Code.GetNewTimeZone(Code.SelectedDateValue(Parameters!EndDate.Value,Parameters!EndDate_BaseType.Value,Parameters!EndDate_OffsetType.Value,Parameters!EndDate_OffsetValue.Value),Parameters!TimeZoneName.Value)</Value>
</QueryParameter>
<QueryParameter Name="@DeviceType">
<Value>=Parameters!DeviceType.Value</Value>
</QueryParameter>
</QueryParameters>
<DataSourceName>DataWarehouseMain</DataSourceName>
</Query>
<Fields>
<Field Name="DeviceName">
<rd:TypeName>System.String</rd:TypeName>
<DataField>DeviceName</DataField>
</Field>
<Field Name="Information">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>Information</DataField>
</Field>
<Field Name="Warning">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>Warning</DataField>
</Field>
<Field Name="Critical">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>Critical</DataField>
</Field>
<Field Name="Unknown">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>Unknown</DataField>
</Field>
<Field Name="Image">
<rd:TypeName>System.Byte[]</rd:TypeName>
<DataField>Image</DataField>
</Field>
<Field Name="Id">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>Id</DataField>
</Field>
<Field Name="DName">
<rd:TypeName>System.String</rd:TypeName>
<DataField>DName</DataField>
</Field>
</Fields>
</DataSet>
<DataSet Name="SelectedObjectList">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>SELECT EN.ManagedEntityRowId, EN.Name, EN.DisplayName
FROM vManagedEntity EN
INNER JOIN vManagedEntityType ENT
ON EN.[ManagedEntityTypeRowId] = ENT.[ManagedEntityTypeRowId]
WHERE ENT.[ManagedEntityTypeSystemName] = @DeviceType</CommandText>
<QueryParameters>
<QueryParameter Name="@DeviceType">
<Value>=Parameters!DeviceType.Value</Value>
</QueryParameter>
</QueryParameters>
<DataSourceName>DataWarehouseMain</DataSourceName>
</Query>
<Fields>
<Field Name="ManagedEntityRowId">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>ManagedEntityRowId</DataField>
</Field>
<Field Name="Name">
<rd:TypeName>System.String</rd:TypeName>
<DataField>Name</DataField>
</Field>
<Field Name="DisplayName">
<rd:TypeName>System.String</rd:TypeName>
<DataField>DisplayName</DataField>
</Field>
</Fields>
</DataSet>
<DataSet Name="DateRange">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>SELECT * FROM SC_JSXIO_GetDateRange_F(7)</CommandText>
<DataSourceName>DataWarehouseMain</DataSourceName>
</Query>
<Fields>
<Field Name="BeginDate">
<rd:TypeName>System.DateTime</rd:TypeName>
<DataField>BeginDate</DataField>
</Field>
<Field Name="EndDate">
<rd:TypeName>System.DateTime</rd:TypeName>
<DataField>EndDate</DataField>
</Field>
</Fields>
</DataSet>
<DataSet Name="DeviceTypeDisplayName">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>SELECT [ManagedEntityTypeDefaultName] FROM vManagedEntityType WHERE [ManagedEntityTypeSystemName] LIKE @DeviceType</CommandText>
<QueryParameters>
<QueryParameter Name="@DeviceType">
<Value>=Parameters!DeviceType.Value</Value>
</QueryParameter>
</QueryParameters>
<DataSourceName>DataWarehouseMain</DataSourceName>
</Query>
<Fields>
<Field Name="ManagedEntityTypeDefaultName">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ManagedEntityTypeDefaultName</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Author>Jalasoft Corporation</Author>
<Code>
private function FirstDayMonth() As DateTime
return DateAdd("d",-Today.Day()+1,Today())
end function
private function FirstDayQuarter() As DateTime
return DateAdd("q",DATEDIFF("q",FirstDayYear(),Now()),FirstDayYear())
end function
private function FirstDayYear() As DateTime
return DateAdd("m",-Today.Month()+1,FirstDayMonth())
end function
public function SelectedDateValue(aSpecificDateTime, aBaseType, aOffsetType, aOffsetValue) As DateTime
Dim specificDateTime As DateTime
Dim hours As Integer
Dim minutes As Integer
select case aBaseType
case "Fixed"
return aSpecificDateTime
case "Today"
specificDateTime = Today()
case "Sunday"
specificDateTime = DateAdd("d",1-Weekday(Today()),Today())
case "Monday"
specificDateTime = DateAdd("d",2-Weekday(Today()),Today())
case "Tuesday"
specificDateTime = DateAdd("d",3-Weekday(Today()),Today())
case "Wednesday"
specificDateTime = DateAdd("d",4-Weekday(Today()),Today())
case "Thursday"
specificDateTime = DateAdd("d",5-Weekday(Today()),Today())
case "Friday"
specificDateTime = DateAdd("d",6-Weekday(Today()),Today())
case "Saturday"
specificDateTime = DateAdd("d",7-Weekday(Today()),Today())
case "FirstDayMonth"
specificDateTime = FirstDayMonth()
case "LastDayMonth"
specificDateTime = DateAdd("d",-1,DateAdd("m",1,FirstDayMonth()))
case "FirstDayQuarter"
specificDateTime = FirstDayQuarter()
case "LastDayQuarter"
specificDateTime = DateAdd("d",-1,DateAdd("q",1,FirstDayQuarter()))
case "FirstDayYear"
specificDateTime = FirstDayYear()
case "LastDayYear"
specificDateTime = DateAdd("m",11,DateAdd("d",30,FirstDayYear()))
end select
hours = Hour(aSpecificDateTime)
minutes = Minute(aSpecificDateTime)
if (aOffsetType = "None")
return DateAdd("n",minutes,DateAdd("h",hours,specificDateTime))
else
if (aBaseType = "LastDayMonth" AND aOffsetType = "Month")
specificDateTime = DateAdd("d",-1,DateAdd("m",aOffsetValue+1,FirstDayMonth()))
else if (aBaseType = "LastDayQuarter" AND aOffsetType = "Quarter")
specificDateTime = DateAdd("d",-1,DateAdd("q",aOffsetValue+1,FirstDayQuarter()))
else
specificDateTime = DateAdd(DateTimeType(aOffsetType),aOffsetValue,specificDateTime)
end if
end if
return DateAdd("n",minutes,DateAdd("h",hours,specificDateTime))
end function
private function DateTimeType(aOffsetType) As String
select case aOffsetType
case "Day"
return "d"
case "Week"
return "ww"
case "Month"
return "m"
case "Quarter"
return "q"
case "Year"
return "yyyy"
end select
end function
public function GetGeneratedAtTime(aTimeZone) As String
Dim hours As Integer
Dim minutes As Integer
Dim diffUtcServerTime As Integer
hours = System.TimeZone.CurrentTimeZone.GetUtcOffset(DateTime.Now).Hours
minutes = System.TimeZone.CurrentTimeZone.GetUtcOffset(DateTime.Now).Minutes
diffUtcServerTime = hours * 60
if (hours > 0)
diffUtcServerTime = diffUtcServerTime + minutes
else
diffUtcServerTime = diffUtcServerTime - minutes
end if
return DateAdd("n",(diffUtcServerTime *(-1)) + GetTimeZoneMinutesDiff(aTimeZone), Now())
end function
public function GetTimeZoneMinutesDiff(aTimeZone) As Integer
Dim minutes As Integer
if (Mid(aTimeZone,5,1) = ")")
return 0
else
minutes = CInt(Mid(aTimeZone,6,2))*60 + CInt(Mid(aTimeZone,9,2))
return CInt(Mid(aTimeZone,5,1) + CStr(minutes))
end if
end function
public function GetNewTimeZone(aSelectedDate, aTimeZone) As DateTime
return DateAdd("n",GetTimeZoneMinutesDiff(aTimeZone)*(-1), aSelectedDate)
end function
public function FormatNumber(fieldValue, formatString, unit) as string
if (fieldValue is Nothing)
FormatNumber = "N/A"
else
FormatNumber = Format(fieldValue,formatString) & " " & unit
end if
end function</Code>
<Width>9in</Width>
<InteractiveHeight>8.5in</InteractiveHeight>
<Language>en-US</Language>
<PageFooter>
<ReportItems>
<Textbox Name="lblPageNumber">
<Left>7.1in</Left>
<Top>0.15in</Top>
<ZIndex>1</ZIndex>
<Width>1.7in</Width>
<Style>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<Color>DimGray</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.1875in</Height>
<Value>="Page " & Globals.PageNumber & "/" & Globals.TotalPages</Value>
</Textbox>
<Textbox Name="lblJalasoft">
<Left>0.1in</Left>
<Top>0.15in</Top>
<Action>
<Hyperlink>http://www.jalasoft.com</Hyperlink>
</Action>
<Width>1.1in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<Color>DimGray</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.1875in</Height>
<Value>Jalasoft Corporation</Value>
</Textbox>
</ReportItems>
<Height>0.45in</Height>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
</PageFooter>
<TopMargin>1in</TopMargin>
<PageHeight>8.5in</PageHeight>
</Report>
</Definition>
</Report>