This report provides a table with detailed information about the alerts generated by the selected Availability device(s) during a defined period. The report may be configured to show all alerts with any severity or only those alerts that match the severity report parameter (default value is 'All'). Aggregation level default value is 'Day'. 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 Availability).
| Accessibility | Public |
| Visible | True |
Home
<Report ID="Jalasoft.Xian.OpsMgr2007MP.Report.Availability.JsXAvailabilityDeviceElement_Alert.Detailed.Aggregated" Accessibility="Public" Target="ThirdParty_Availability!Jalasoft.Xian.Common.Elements.ThirdParty.Availability.JsXAvailabilityDeviceElement" 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>
<Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.ComboBox">
<ReportParameters>
<ReportParameter name="Severity"/>
</ReportParameters>
</Control>
<Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.ComboBox">
<ReportParameters>
<ReportParameter name="AgregLevel"/>
</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.ThirdParty.Availability.JsXAvailabilityDeviceElement</Value>
</Values>
</DefaultValue>
</ReportParameter>
<ReportParameter Name="PluginName">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Jalasoft Xian NM plugin for Availability</Value>
</Values>
</DefaultValue>
</ReportParameter>
<ReportParameter Name="Severity">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>0</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Severity</Prompt>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>0</Value>
<Label>All</Label>
</ParameterValue>
<ParameterValue>
<Value>4</Value>
<Label>Information</Label>
</ParameterValue>
<ParameterValue>
<Value>2</Value>
<Label>Warning</Label>
</ParameterValue>
<ParameterValue>
<Value>1</Value>
<Label>Critical</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
</ReportParameter>
<ReportParameter Name="AgregLevel">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Day</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Aggregation Level</Prompt>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>Hour</Value>
<Label>Hour</Label>
</ParameterValue>
<ParameterValue>
<Value>Day</Value>
<Label>Day</Label>
</ParameterValue>
<ParameterValue>
<Value>Week</Value>
<Label>Week</Label>
</ParameterValue>
<ParameterValue>
<Value>Month</Value>
<Label>Month</Label>
</ParameterValue>
<ParameterValue>
<Value>Quarter</Value>
<Label>Quarter</Label>
</ParameterValue>
<ParameterValue>
<Value>Year</Value>
<Label>Year</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
</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.5in</Top>
<NoRows>There is no data available for this report. This may occur when there are no alerts generated for Availability devices for the selected report parameters, as date range, alert severity and aggregation level.</NoRows>
<ZIndex>5</ZIndex>
<Visibility>
<Hidden>=iif(CountRows()>0,true,false)</Hidden>
</Visibility>
<Width>7.65in</Width>
<Style>
<TextAlign>Center</TextAlign>
</Style>
<Height>2in</Height>
</List>
<Rectangle Name="rectangle13">
<Left>0.7in</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.88542in</Top>
<ZIndex>4</ZIndex>
<Width>7.7in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
</Style>
<Height>0.32in</Height>
</Rectangle>
<Rectangle Name="recReportDetail">
<ReportItems>
<Textbox Name="textbox3">
<Left>1.85in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.45in</Top>
<ZIndex>13</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="textbox7">
<Left>1.96042in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.45in</Top>
<ZIndex>12</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>=Parameters!AgregLevel.Value</Value>
</Textbox>
<Textbox Name="textbox8">
<Left>0.2in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.45in</Top>
<ZIndex>11</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>Aggregation Level</Value>
</Textbox>
<Textbox Name="txtTargetCounter">
<Left>1.96042in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.65in</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>1.15in</Top>
<ZIndex>9</ZIndex>
<Source>External</Source>
<Style/>
<Value>../gradient_portrait.gif</Value>
</Image>
<List Name="lstTargetDevices">
<ReportItems>
<Textbox Name="txtTargetNames">
<Left>1.96042in</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.85in</Top>
<ZIndex>8</ZIndex>
<Visibility>
<ToggleItem>lblTargetDeviceList</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.65in</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="lblTargetDeviceList">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.65in</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.96042in</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.96042in</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>1.2in</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 - Aggregated</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 a table with detailed information about the alerts generated by the selected Availability device(s) during a defined period. The report may be configured to show all alerts with any severity or only those alerts that match the severity report parameter (default value is 'All'). Aggregation level default value is 'Day'. 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 Availability).</Value>
</Textbox>
</ReportItems>
<Top>0.55in</Top>
<Visibility>
<ToggleItem>lblReportDescription</ToggleItem>
<Hidden>true</Hidden>
</Visibility>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
<Height>0.25in</Height>
</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="textbox16">
<rd:DefaultName>textbox16</rd:DefaultName>
<ZIndex>8</ZIndex>
<Style>
<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>N/A: Not available</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.24337in</Height>
</TableRow>
</TableRows>
</Footer>
<Left>0.2in</Left>
<DataSetName>ReportData</DataSetName>
<Top>3.48958in</Top>
<Visibility>
<Hidden>=iif(CountRows()>0,false,true)</Hidden>
</Visibility>
<Width>8.6in</Width>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox15">
<rd:DefaultName>textbox15</rd:DefaultName>
<ZIndex>7</ZIndex>
<Style>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>Solid</Top>
<Left>Solid</Left>
<Right>None</Right>
</BorderStyle>
<PaddingLeft>4pt</PaddingLeft>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!DName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox10">
<rd:DefaultName>textbox10</rd:DefaultName>
<ZIndex>6</ZIndex>
<Style>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>Solid</Top>
<Left>Solid</Left>
<Right>None</Right>
</BorderStyle>
<PaddingLeft>4pt</PaddingLeft>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!DeviceName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Image Name="image8">
<Sizing>AutoSize</Sizing>
<MIMEType>image/png</MIMEType>
<ZIndex>5</ZIndex>
<Source>Database</Source>
<Style>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>Solid</Top>
<Left>Solid</Left>
<Right>None</Right>
</BorderStyle>
<PaddingLeft>4pt</PaddingLeft>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingTop>2pt</PaddingTop>
</Style>
<Value>=Fields!Image.Value</Value>
</Image>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox13">
<rd:DefaultName>textbox13</rd:DefaultName>
<ZIndex>4</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!EventName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Image Name="image4">
<Sizing>AutoSize</Sizing>
<MIMEType/>
<ZIndex>3</ZIndex>
<Source>External</Source>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>4pt</PaddingLeft>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingTop>2pt</PaddingTop>
</Style>
<Value>
=Switch(
Fields!Severity.Value =4,
"AlertSeverity_Information16x16.png",
Fields!Severity.Value =2,
"AlertSeverity_Warning16x16.png",
Fields!Severity.Value =1,
"AlertSeverity_CriticalError16x16.png",
true,
"AlertSeverity_Unknown16x16.png"
)
</Value>
</Image>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox4">
<rd:DefaultName>textbox4</rd:DefaultName>
<ZIndex>2</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!counter.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox5">
<rd:DefaultName>textbox5</rd:DefaultName>
<ZIndex>1</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!StartTime.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox6">
<rd:DefaultName>textbox6</rd:DefaultName>
<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!EndTime.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.24337in</Height>
</TableRow>
</TableRows>
</Details>
<Style>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
</Style>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox12">
<rd:DefaultName>textbox12</rd:DefaultName>
<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!DName.Value</SortExpression>
</UserSort>
<Value>=First(Fields!ManagedEntityTypeDefaultName.Value, "DeviceTypeDisplayName")</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ColSpan>2</ColSpan>
<ReportItems>
<Textbox Name="textbox9">
<rd:DefaultName>textbox9</rd:DefaultName>
<ZIndex>13</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>
</UserSort>
<Value>Object</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ColSpan>2</ColSpan>
<ReportItems>
<Textbox Name="textbox11">
<rd:DefaultName>textbox11</rd:DefaultName>
<ZIndex>12</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>
<Value>Name</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox1">
<rd:DefaultName>textbox1</rd:DefaultName>
<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>Count</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="lblPriority">
<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>
<UserSort>
<SortExpression>=Fields!StartTime.Value</SortExpression>
</UserSort>
<Value>Start Date</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="lblResolutionState">
<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>End Date</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.34072in</Height>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
</Header>
<TableColumns>
<TableColumn>
<Width>1.6in</Width>
</TableColumn>
<TableColumn>
<Width>1.75in</Width>
</TableColumn>
<TableColumn>
<Width>0.3in</Width>
</TableColumn>
<TableColumn>
<Width>2.3in</Width>
</TableColumn>
<TableColumn>
<Width>0.35in</Width>
</TableColumn>
<TableColumn>
<Width>0.6in</Width>
</TableColumn>
<TableColumn>
<Width>0.85in</Width>
</TableColumn>
<TableColumn>
<Width>0.85in</Width>
</TableColumn>
</TableColumns>
<Height>0.82746in</Height>
</Table>
</ReportItems>
<Height>6.05in</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_GetRawAggregatedAlertData_SP @StartDate, @EndDate, @DeviceType, @SeverityId, @AggregLevel, @TimeZoneMin</CommandText>
<QueryParameters>
<QueryParameter Name="@StartDate">
<Value>=Code.SelectedDateValue(Parameters!StartDate.Value,Parameters!StartDate_BaseType.Value,Parameters!StartDate_OffsetType.Value,Parameters!StartDate_OffsetValue.Value)</Value>
</QueryParameter>
<QueryParameter Name="@EndDate">
<Value>=Code.SelectedDateValue(Parameters!EndDate.Value,Parameters!EndDate_BaseType.Value,Parameters!EndDate_OffsetType.Value,Parameters!EndDate_OffsetValue.Value)</Value>
</QueryParameter>
<QueryParameter Name="@DeviceType">
<Value>=Parameters!DeviceType.Value</Value>
</QueryParameter>
<QueryParameter Name="@SeverityId">
<Value>=Parameters!Severity.Value</Value>
</QueryParameter>
<QueryParameter Name="@AggregLevel">
<Value>=Parameters!AgregLevel.Value</Value>
</QueryParameter>
<QueryParameter Name="@TimeZoneMin">
<Value>=Code.GetTimeZoneMinutesDiff(Parameters!TimeZoneName.Value)*(-1)</Value>
</QueryParameter>
</QueryParameters>
<DataSourceName>DataWarehouseMain</DataSourceName>
</Query>
<Fields>
<Field Name="DeviceName">
<rd:TypeName>System.String</rd:TypeName>
<DataField>DeviceName</DataField>
</Field>
<Field Name="EventName">
<rd:TypeName>System.String</rd:TypeName>
<DataField>EventName</DataField>
</Field>
<Field Name="Severity">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>Severity</DataField>
</Field>
<Field Name="Image">
<rd:TypeName>System.Byte[]</rd:TypeName>
<DataField>Image</DataField>
</Field>
<Field Name="StartTime">
<rd:TypeName>System.DateTime</rd:TypeName>
<DataField>StartTime</DataField>
</Field>
<Field Name="EndTime">
<rd:TypeName>System.DateTime</rd:TypeName>
<DataField>EndTime</DataField>
</Field>
<Field Name="counter">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>counter</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 specificDate() As String
Dim specificTime() As String
specificTime = Split(aSpecificDateTime.ToString()," ")
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
if (aOffsetType = "None")
specificDate = Split(specificDateTime.ToString()," ")
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
specificDate = Split(specificDateTime.ToString()," ")
end if
return CDate(specificDate(0) + " " + specificTime(1) + " " + specificTime(2))
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 utcLocalTimeDiff As String
Dim minutes As Integer
Dim minutesWithSign As Integer
utcLocalTimeDiff = System.TimeZone.CurrentTimeZone.GetUtcOffset(Now).ToString()
minutes = CInt(Mid(utcLocalTimeDiff,2,2))*60 + CInt(Mid(utcLocalTimeDiff,5,2))
minutesWithSign = CInt(Mid(utcLocalTimeDiff,1,1) + CStr(minutes))
return DateAdd("n",(minutesWithSign*(-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>