Only some charts have no lines
-
I have a report that includes line charts. Some of the charts only show a very little of the line. I have checked the dataset and the data is there. What could be causing this problem? I have included the code below.
Any help is greatly appreciated.
/code = "sql"
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<Body>
<ReportItems>
<Tablix Name="Tablix2">
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>1.07639in</Width>
</TablixColumn>
<TablixColumn>
<Width>1.52431in</Width>
</TablixColumn>
<TablixColumn>
<Width>1in</Width>
</TablixColumn>
<TablixColumn>
<Width>1in</Width>
</TablixColumn>
</TablixColumns>
<TablixRows>
<TablixRow>
<Height>0.23958in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="Textbox9">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Furnace</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox9</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="Textbox11">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Pour Start Time</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox11</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="Textbox13">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Pour Duration</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox13</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="Textbox15">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Percent of Heat</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox15</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
<TablixRow>
<Height>0.26042in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Textbox Name="FURNACE">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!FURNACE.Value</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>FURNACE</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="POUR_START_TIME">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!POUR_START_TIME.Value</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>POUR_START_TIME</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="POUR_DURATION">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!POUR_DURATION.Value</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>POUR_DURATION</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
<TablixCell>
<CellContents>
<Textbox Name="PERCENT_OF_HEAT">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!PERCENT_OF_HEAT.Value</Value>
<Style>
<Format>0%</Format>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>PERCENT_OF_HEAT</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember />
<TablixMember />
<TablixMember />
<TablixMember />
</TablixMembers>
</TablixColumnHierarchy>
<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<TablixHeader>
<Size>1in</Size>
<CellContents>
<Textbox Name="Textbox119">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>HEAT NUMBER</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox119</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixHeader>
<TablixMembers>
<TablixMember />
</TablixMembers>
<KeepWithGroup>After</KeepWithGroup>
</TablixMember>
<TablixMember>
<Group Name="HEAT_NUMBER">
<GroupExpressions>
<GroupExpression>=Fields!HEAT_NUMBER.Value</GroupExpression>
</GroupExpressions>
</Group>
<SortExpressions>
<SortExpression>
<Value>=Fields!HEAT_NUMBER.Value</Value>
</SortExpression>
</SortExpressions>
<TablixHeader>
<Size>1in</Size>
<CellContents>
<Textbox Name="HEAT_NUMBER1">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!HEAT_NUMBER.Value</Value>
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>HEAT_NUMBER1</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixHeader>
<TablixMembers>
<TablixMember>
<Group Name="Details">
<GroupExpressions>
<GroupExpression>=Fields!HEAT_NUMBER.Value</GroupExpression>
</GroupExpressions>
</Group>
</TablixMember>
</TablixMembers>
</TablixMember>
</TablixMembers>
</TablixRowHierarchy>
<DataSetName>DataSet1SlagDetect</DataSetName>
<Top>0.24875in</Top>
<Left>1.30083in</Left>
<Height>0.5in</Height>
<Width>5.6007in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Tablix>
<Rectangle Name="Rectangle4">
<ReportItems>
<Tablix Name="Tablix10">
<TablixCorner>
<TablixCornerRows>
<TablixCornerRow>
<TablixCornerCell>
<CellContents>
<Textbox Name="Textbox152">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value />
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox152</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>White</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixCornerCell>
</TablixCornerRow>
</TablixCornerRows>
</TablixCorner>
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>6.58854in</Width>
</TablixColumn>
</TablixColumns>
<TablixRows>
<TablixRow>
<Height>4.16667in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Chart Name="Chart48">
<ChartCategoryHierarchy>
<ChartMembers>
<ChartMember>
<Group Name="Chart48_CategoryGroup">
<GroupExpressions>
<GroupExpression>=Fields!SAMPLE_TIME.Value</GroupExpression>
</GroupExpressions>
</Group>
<SortExpressions>
<SortExpression>
<Value>=Fields!SAMPLE_TIME.Value</Value>
</SortExpression>
</SortExpressions>
<Label>=Fields!SAMPLE_TIME.Value</Label>
</ChartMember>
</ChartMembers>
</ChartCategoryHierarchy>
<ChartSeriesHierarchy>
<ChartMembers>
<ChartMember>
<Group Name="Chart48_SeriesGroup">
<GroupExpressions>
<GroupExpression>=Fields!HEAT_NUMBER.Value</GroupExpression>
</GroupExpressions>
</Group>
<SortExpressions>
<SortExpression>
<Value>=Fields!HEAT_NUMBER.Value</Value>
</SortExpression>
</SortExpressions>
<Label>=Fields!HEAT_NUMBER.Value</Label>
</ChartMember>
</ChartMembers>
</ChartSeriesHierarchy>
<ChartData>
<ChartSeriesCollection>
<ChartSeries Name="FURNACE_ANGLE">
<ChartDataPoints>
<ChartDataPoint>
<ChartDataPointValues>
<Y>=Sum(Fields!FURNACE_ANGLE.Value)</Y>
</ChartDataPointValues>
<ChartDataLabel>
<Style />
</ChartDataLabel>
<Style>
<Border>
<Color>Red</Color>
</Border>
<Color>Red</Color>
</Style>
<ChartMarker>
<Style />
</ChartMarker>
<DataElementOutput>Output</DataElementOutput>
</ChartDataPoint>
</ChartDataPoints>
<Type>Line</Type>
<Style />
<ChartEmptyPoints>
<Style />
<ChartMarker>
<Style />
</ChartMarker>
<ChartDataLabel>
<Style />
</ChartDataLabel>
</ChartEmptyPoints>
<ValueAxisName>Primary</ValueAxisName>
<CategoryAxisName>Primary</CategoryAxisName>
<ChartSmartLabel>
<CalloutLineColor>Black</CalloutLineColor>
<MinMovingDistance>0pt</MinMovingDistance>
</ChartSmartLabel>
</ChartSeries>
</ChartSeriesCollection>
</ChartData>
<ChartAreas>
<ChartArea Name="Default">
<ChartCategoryAxes>
<ChartAxis Name="Primary">
<Style>
<FontSize>8pt</FontSize>
<Format>hh:mm:ss tt</Format>
</Style>
<ChartAxisTitle>
<Caption />
<Style>
<FontSize>8pt</FontSize>
</Style>
</ChartAxisTitle>
<ChartMajorGridLines>
<Enabled>False</Enabled>
<Style>
<Border>
<Color>Gainsboro</Color>
</Border>
</Style>
</ChartMajorGridLines>
<ChartMinorGridLines>
<Style>
<Border>
<Color>Gainsboro</Color>
<Style>Dotted</Style>
</Border>
</Style>
</ChartMinorGridLines>
<ChartMinorTickMarks>
<Length>0.5</Length>
<Interval>5</Interval>
</ChartMinorTickMarks>
<CrossAt>NaN</CrossAt>
<Minimum>NaN</Minimum>
<Maximum>NaN</Maximum>
<AllowLabelRotation>Rotate45</AllowLabelRotation>
<ChartAxisScaleBreak>
<Style />
</ChartAxisScaleBreak>
</ChartAxis>
<ChartAxis Name="Secondary">
<Style>
<FontSize>8pt</FontSize>
</Style>
<ChartAxisTitle>
<Caption>Axis Title</Caption>
<Style>
<FontSize>8pt</FontSize>
</Style>
</ChartAxisTitle>
<ChartMajorGridLines>
<Enabled>False</Enabled>
<Style>
<Border>
<Color>Gainsboro</Color>
</Border>
</Style>
</ChartMajorGridLines>
<ChartMinorGridLines>
<Style>
<Border>
<Color>Gainsboro</Color>
<Style>Dotted</Style>
</Border>
</Style>
</ChartMinorGridLines>
<ChartMinorTickMarks>
<Length>0.5</Length>
</ChartMinorTickMarks>
<CrossAt>NaN</CrossAt>
<Location>Opposite</Location>
<Minimum>NaN</Minimum>
<Maximum>NaN</Maximum>
<ChartAxisScaleBreak>
<Style />
</ChartAxisScaleBreak>
</ChartAxis>
</ChartCategoryAxes>
<ChartValueAxes>
<ChartAxis Name="Primary">
<Style>
<FontSize>8pt</FontSize>
</Style>
<ChartAxisTitle>
<Caption />
<Style>
<FontSize>8pt</FontSize>
</Style>
</ChartAxisTitle>
<Interval>10</Interval>
<ChartMajorGridLines>
<Style>
<Border>
<Color>Gainsboro</Color>
</Border>
</Style>
</ChartMajorGridLines>
<ChartMinorGridLines>
<Style>
<Border>
<Color>Gainsboro</Color>
<Style>Dotted</Style>
</Border>
</Style>
</ChartMinorGridLines>
<ChartMinorTickMarks>
<Length>0.5</Length>
</ChartMinorTickMarks>
<Reverse>true</Reverse>
<CrossAt>NaN</CrossAt>
<Minimum>40</Minimum>
<Maximum>105</Maximum>
<ChartAxisScaleBreak>
<Style />
</ChartAxisScaleBreak>
</ChartAxis>
<ChartAxis Name="Secondary">
<Style>
<FontSize>8pt</FontSize>
</Style>
<ChartAxisTitle>
<Caption>Axis Title</Caption>
<Style>
<FontSize>8pt</FontSize>
</Style>
</ChartAxisTitle>
<ChartMajorGridLines>
<Style>
<Border>
<Color>Gainsboro</Color>
</Border>
</Style>
</ChartMajorGridLines>
<ChartMinorGridLines>
<Style>
<Border>
<Color>Gainsboro</Color>
<Style>Dotted</Style>
</Border>
</Style>
</ChartMinorGridLines>
<ChartMinorTickMarks>
<Length>0.5</Length>
</ChartMinorTickMarks>
<CrossAt>NaN</CrossAt>
<Location>Opposite</Location>
<Minimum>NaN</Minimum>
<Maximum>NaN</Maximum>
<ChartAxisScaleBreak>
<Style />
</ChartAxisScaleBreak>
</ChartAxis>
</ChartValueAxes>
<Style>
<BackgroundColor>LightGrey</BackgroundColor>
<BackgroundGradientType>None</BackgroundGradientType>
</Style>
</ChartArea>
</ChartAreas>
<ChartLegends>
<ChartLegend Name="Default">
<Style>
<BackgroundGradientType>None</BackgroundGradientType>
<FontSize>8pt</FontSize>
</Style>
<Position>TopCenter</Position>
<DockOutsideChartArea>true</DockOutsideChartArea>
<ChartLegendTitle>
<Caption />
<Style>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
<TextAlign>Center</TextAlign>
</Style>
</ChartLegendTitle>
<HeaderSeparatorColor>Black</HeaderSeparatorColor>
<ColumnSeparatorColor>Black</ColumnSeparatorColor>
</ChartLegend>
</ChartLegends>
<ChartTitles>
<ChartTitle Name="Default">
<Caption>Furnace Movement</Caption>
<Style>
<BackgroundGradientType>None</BackgroundGradientType>
<FontWeight>Bold</FontWeight>
<TextAlign>General</TextAlign>
<VerticalAlign>Top</VerticalAlign>
</Style>
</ChartTitle>
</ChartTitles>
<Palette>BrightPastel</Palette>
<ChartBorderSkin>
<Style>
<BackgroundColor>Gray</BackgroundColor>
<BackgroundGradientType>None</BackgroundGradientType>
<Color>White</Color>
</Style>
</ChartBorderSkin>
<ChartNoDataMessage Name="NoDataMessage">
<Caption>No Data Available</Caption>
<Style>
<BackgroundGradientType>None</BackgroundGradientType>
<TextAlign>General</TextAlign>
<VerticalAlign>Top</VerticalAlign>
</Style>
</ChartNoDataMessage>
<DataSetName>DataSet1SlagDetect</DataSetName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<BackgroundGradientType>None</BackgroundGradientType>
</Style>
</Chart>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember>
<TablixHeader>
<Size>0.10417in</Size>
<CellContents>
<Textbox Name="HEAT_IDX">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value />
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>HEAT_IDX</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>White</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixHeader>
<TablixMembers>
<TablixMember />
</TablixMembers>
</TablixMember>
</TablixMembers>
</TablixColumnHierarchy>
<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<TablixHeader>
<Size>0.08854in</Size>
<CellContents>
<Textbox Name="HEAT_NUMBER2">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value />
<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>HEAT_NUMBER2</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>
<BackgroundColor>White</BackgroundColor>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</CellContents>
</TablixHeader>
<TablixMembers>
<TablixMember>
<Group Name="HEAT_IDX1">
<GroupExpressions>
<GroupExpression>=Fields!HEAT_IDX.Value</GroupExpression>
</GroupExpressions>
</Group>
<SortExpressions>
<SortExpression>
<Value>=Fields!HEAT_NUMBER.Value</Value>
</SortExpression>
</SortExpressions>
<TablixMembers>
<TablixMember />
</TablixMembers>
</TablixMember>
</TablixMembers>
</TablixMember>
</TablixMembers>
</TablixRowHierarchy>
<DataSetName>DataSet1SlagDetect</DataSetName>
<Height>4.27084in</Height>
<Width>6.67708in</Width>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Tablix>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Top>1.405in</Top>
<Left>0.67583in</Left>
<Height>4.44792in</Height>
<Width>6.67708in</Width>
<ZIndex>1</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>
</Style>
</Rectangle>
</ReportItems>
<Height>8.48833in</Height>
<Style />
</Body>
<Width>9.32167in</Width>
<Page>
<LeftMargin>1in</LeftMargin>
<RightMargin>1in</RightMargin>
<TopMargin>1in</TopMargin>
<BottomMargin>1in</BottomMargin>
<Style />
</Page>
<AutoRefresh>0</AutoRefresh>
<DataSources>
<DataSource Name="DataSource1SlagDetect">
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>Data Source=192.168.1.91;Initial Catalog=TSD_1BOP</ConnectString>
</ConnectionProperties>
<rd:SecurityType>DataBase</rd:SecurityType>
<rd:DataSourceID>b9d3e84d-8cc6-4751-a14e-95f6009e631f</rd:DataSourceID>
</DataSource>
</DataSources>
<DataSets>
<DataSet Name="DataSet1SlagDetect">
<Query>
<DataSourceName>DataSource1SlagDetect</DataSourceName>
<QueryParameters>
<QueryParameter Name="@StartDate">
<Value>=Parameters!StartDate.Value</Value>
</QueryParameter>
<QueryParameter Name="@EndDate">
<Value>=Parameters!EndDate.Value</Value>
</QueryParameter>
</QueryParameters>
<CommandText>SELECT HeatData.HEAT_IDX, HeatData.HEAT_NUMBER, HeatData.FURNACE_IDX, HeatData.TURN_DATE, HeatData.POUR_START_TIME, HeatData.POUR_DURATION,
MovementAlarms.HEAT_IDX AS Expr1, MovementAlarms.ALARM_DURATION, ChartData.HEAT_IDX AS Expr2, ChartData.SAMPLE_TIME,
ChartData.FURNACE_ANGLE
FROM HeatData INNER JOIN
MovementAlarms ON HeatData.HEAT_IDX = MovementAlarms.HEAT_IDX INNER JOIN
ChartData ON HeatData.HEAT_IDX = ChartData.HEAT_IDX
WHERE (HeatData.TURN_DATE >= @StartDate) AND (HeatData.TURN_DATE <= @EndDate)</CommandText>
</Query>
<Fields>
<Field Name="HEAT_IDX">
<DataField>HEAT_IDX</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="HEAT_NUMBER">
<DataField>HEAT_NUMBER</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="FURNACE_IDX">
<DataField>FURNACE_IDX</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="TURN_DATE">
<DataField>TURN_DATE</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
<Field Name="POUR_START_TIME">
<DataField>POUR_START_TIME</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
<Field Name="POUR_DURATION">
<DataField>POUR_DURATION</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Expr1">
<DataField>Expr1</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ALARM_DURATION">
<DataField>ALARM_DURATION</DataField>
<rd:TypeName>System.Double</rd:TypeName>
</Field>
<Field Name="Expr2">
<DataField>Expr2</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="FURNACE">
<Value>=Switch(Fields!FURNACE_IDX.Value = 15, "X",Fields!FURNACE_IDX.Value = 16, "C", Fields!FURNACE_IDX.Value = 17, "U")</Value>
</Field>
<Field Name="SAMPLE_TIME">
<DataField>SAMPLE_TIME</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
<Field Name="PERCENT_OF_HEAT">
<Value>=Fields!ALARM_DURATION.Value/(Minute(Fields!POUR_DURATION.Value)*60+Second(Fields!POUR_DURATION.Value))</Value>
</Field>
<Field Name="FURNACE_ANGLE">
<DataField>FURNACE_ANGLE</DataField>
<rd:TypeName>System.Double</rd:TypeName>
</Field>
<Field Name="POUR_DURATION_SECONDS">
<Value>=Minute(Fields!POUR_DURATION.Value)*60+Second(Fields!POUR_DURATION.Value)</Value>
</Field>
</Fields>
<Filters>
<Filter>
<FilterExpression>=Fields!PERCENT_OF_HEAT.Value</FilterExpression>
<Operator>GreaterThanOrEqual</Operator>
<FilterValues>
<FilterValue DataType="Float">0.04</FilterValue>
</FilterValues>
</Filter>
<Filter>
<FilterExpression>=Fields!ALARM_DURATION.Value</FilterExpression>
<Operator>LessThan</Operator>
<FilterValues>
<FilterValue>=Fields!POUR_DURATION_SECONDS.Value</FilterValue>
</FilterValues>
</Filter>
</Filters>
</DataSet>
</DataSets>
<ReportParameters>
<ReportParameter Name="StartDate">
<DataType>DateTime</DataType>
<Prompt>Start Date</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate">
<DataType>DateTime</DataType>
<Prompt>End Date</Prompt>
</ReportParameter>
</ReportParameters>
<rd:ReportUnitType>Inch</rd:ReportUnitType>
<rd:ReportID>d641d4cf-e60f-45ce-ba43-7cee58c67ede</rd:ReportID>
</Report>
/code
-
Please include the actual .rdl file instead of the pasted XML.
Or a screenshot would be nice as well.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
This is the URL for the screenshot of the rdl file
http://i62.tinypic.com/f9mxi1.jpg
This is the URL for the screenshot of the report
http://i60.tinypic.com/16av09k.jpg
Thank You
-
mballentine (10/8/2014)
This is the URL for the screenshot of the rdl filehttp://i62.tinypic.com/f9mxi1.jpg
This is the URL for the screenshot of the report
http://i60.tinypic.com/16av09k.jpg
Thank You
Cool links, thank you!
Guys, you will love these pictures to show up on your screen while in office!
:w00t::w00t::w00t:
Seriously, do you really expect anyone with right mind to try your URL's ?
-
Eugene Elutin (10/8/2014)
mballentine (10/8/2014)
This is the URL for the screenshot of the rdl filehttp://i62.tinypic.com/f9mxi1.jpg
This is the URL for the screenshot of the report
http://i60.tinypic.com/16av09k.jpg
Thank You
Cool links, thank you!
Guys, you will love these pictures to show up on your screen while in office!
:w00t::w00t::w00t:
Seriously, do you really expect anyone with right mind to try your URL's ?
I tried them and they are fine. Except for the annoying ads of the tinypic website.
@mballentine: you can add attachments to your forum post. This avoids using 3rd party websites like this one.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
mballentine (10/8/2014)
This is the URL for the screenshot of the rdl filehttp://i62.tinypic.com/f9mxi1.jpg
This is the URL for the screenshot of the report
http://i60.tinypic.com/16av09k.jpg
Thank You
There is some data displayed, in the bottom left corner.
Is it possible to give some sample data that is used to create the graph?
(sample_time, heat_number and furnace_angle)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
Thank you for your help.
I apologize for the 3rd party website.
I am new to forums and didn't know.
I have attached the data for the heat that is missing the line in the chart.
-
I'm not sure what you did, but I can make a line graph just fine.
See the following screenshot. I also added the .rdl file to the attachments.
I just imported the data from the Excel file straight into a table and made the graph on top of that.
I set the interval for the x-axis to 60 to display a bit more info on the axis.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
I don't know either. I just run the report and that is the only graph that doesn't come out correctly. Thanks anyhow.
-
Do you have any idea what would be causing the report to double the furnace angle values on only this one chart? I added a column to the report and it is doubling the furnace angle and only for this one heat. When I say "just this one heat" I mean in this particular report date range. This also occurs on select charts when a different date is selected. I am trying to figure out what the particular heats have in common.
-
I did check to make sure the data was not duplicated for whatever reason and it is not.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply