Issue:
1. PDF, Rich Text Format and TIFF file could be downloaded with data
2. CSV file could be downloaded, but content is empty
Env:
.NET 8 => Telerik.Reporting.Services.AspNetCore, Version=18.0.24.305
Angular => "@progress/telerik-angular-report-viewer": "21.24.305"
Telerik ReportsControllerBase APIs:
http://localhost:48399/api/Report/clients/1b5bf213bf3/instances/cf20c6c6de6/documents
trdx:
<?xml version="1.0" encoding="utf-8"?>
<Report Width="29cm" Name="AdjustmentPiecesSummary" Zoom="1.5" SnapGridSize="0.1cm" xmlns="http://schemas.telerik.com/reporting/2021/2.0">
<Style>
<Font Name="Arial Unicode MS" />
</Style>
<DataSources>
<SqlDataSource QueryDesignerState="null" ParameterValues="{"@StartDateTime":"'2024-03-14 15:20:19.000'","@EndDateTime":"'2024-03-16 15:20:19.000'"}" ConnectionString="= Parameters.PFDSConnectionString.Value" ProviderName="System.Data.SqlClient" SelectCommand="[AdjustmentManager].[pr_AdjustmentManager_LoadPiecesSummary]" SelectCommandType="StoredProcedure" CommandTimeout="90" Name="pr_AdjustmentManager_LoadPiecesSummary ">
<Parameters>
<SqlDataSourceParameter DbType="DateTime" Name="@StartDateTime">
<Value>
<String>= Parameters.startDateTime.Value</String>
</Value>
</SqlDataSourceParameter>
<SqlDataSourceParameter DbType="DateTime" Name="@EndDateTime">
<Value>
<String>= Parameters.endDateTime.Value</String>
</Value>
</SqlDataSourceParameter>
</Parameters>
</SqlDataSource>
</DataSources>
<Items>
<PageHeaderSection Height="2.4cm" Name="pageHeaderSection1">
<Style>
<BorderStyle Default="Solid" />
<BorderColor Default="0, 204, 0" />
<BorderWidth Default="2pt" />
</Style>
<Items>
<TextBox Width="4.277in" Height="0.354in" Left="8.2cm" Top="0.5cm" Value="Adjustment Pieces Summary" Name="adjustmentPiecesSummaryTitle">
<Style Color="31, 73, 125" TextAlign="Center">
<Font Size="22pt" Bold="True" />
</Style>
</TextBox>
<PictureBox Image="iVBORw0KGgoAAAANSUhEUgAAACUAAAAlCAIAAABK/LdUAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOvAAADrwBlbxySQAAC0FJREFUWEe9lXlcU1cWxy8oiNa21ulmHVtb/bQ6TmuXkVqdjlpCUAZRCyqKKyjuBgKETUkgEPYA2UmALGTf94RdKAgiiyCCKIIoigubsth1mPtIikt1nD/mM7/P++fdd8753nPuueeBiZfpVt8tQ5WGZIrGFvoftG4IsLgdsLgFWd2Ci70J1gNsa9rZxsrR0RG79cv0n3i9t3vzizknDAE7jZ5+JvcdJnd/s/tui/teK2q/FYWArW5BhaiThd4kY0jRWePY+Jjd88V6Pu+XX34x15iD9Ae8DOiNBvQmg7uffuNh7W6c+jheFY7XhIVrDx01bttnWQ/Z+yxugYWoI0Weaabojs52e4gX6Dm8kdERehHzn/pNKC0arfMI0OxjmOkNrQ2DQ4M///zzvyb16NGjnt6eohprihF/0Pz9Lgtqtwm1z4oKNe+qqC+DBvZYf9CzvNGx0URz2hqd59816I2arUwLq+9u3/CD4drmWkFRAVlPTtOmMkw0U5Wxs/sqtIehGy/VE83RO03r/YwofzPqiNm3uNZqi/ZHPcWDZaQV5X6t8VqhQm9XB1Q3nYU5icol+zWHUXqvdQYPN4OHu9EDbfLw0KP9tNvi9ITzF89DR1gSXmmev3mTjwG1zYg6ZNxe13LOFvMZPcUrrCtbqdjxqczbV3G4rbO9vavjiC58pW49Wu0Tqopim3PlpQphkShZlxqgPojWbUDp0b66rblFueOPxn/77TdZhXSr0dtbh9picA/RH+67c9se9wk95t3rv79Zhlsk3LZKElDTUnfxyqXNqmN/U/hEqomtVy79+OOPMIkHDx/AI4TGQ8ND2irdHt2BNVq0u86TbMqESFgeZjHDS7/BU+u+0eDBsFDhJmzBp/SYl1uqeZcf8B5/L9Us7Lt3Z4s84lPxLk6h+MHDh4XnykNU8VukhzdJA/cpMBQzu+tGN3Tp7Ll2XB+6WoNep/XML+bB6LD+Jw0YpNG07n7a7R3XOmzBp2TnDT0YXieMeyU3aBU/qu/eXYI+911BQJqBOzA0eEpH+4t4z1Kx3zfCPSskO5fJtnwq37RZGVRWXwEdu29279QGfa1Gr9f4NlxqhCulDeVo/cZ1OrSb0YNiok6Gfyw7r7S+9g126Ez2iUyj9GpP92JemDs/9v7gAF6f97YgcLsYX1h7pvP6teb2i5mmvK/F+5eIfb6TBTa2XYD9qT5rcFPv8FT4kyxkVYWWVZyHMeDwSiJBRSRbs2DesjKFpdoKu+/2ndt2XpxWPJ0e/h4ruvXqFUahZiYnuKDUVN92cR43ZFNBwt3792xmNgkrdV9JDm0owBDNTIyS9L0iOMuSC4dRVXPNGo3fl2pPnJpgO7lbd277GnbDgq/RrHfXeiXokxAePGcfHt2RErOKnQIL6FdAnc+K6ey5TtSKXmVjrbU/TFIm4B1v6WhjWBU+UlKCPn9gcLC+rXmp6MAHQv+TsiSY6Mjo6DYldpl0i7fkUP/gAHSBzXVcF7FC5eGqdF+pct+pCUR4ww8erGBmgsw4v3wGPEhXdtpXzKTB4aEdAuo8xqkr3V09vTdzzZpNHNICVqgL+9jM3GOhMgZ0vD/Q/40wYi53v5cgemxsDCKPqpI+EvqtFO7r6EKmARTekLFc7vW5bMMX8vVrNT4I715//zJqFkgnHRdwIfszRsYqZsbo2Ji/gPUJO/mAMGcpjeBMxU2nhznRsM60YGdWcJyKDx1hMVz5p2flHvqOewoOJrgSpqa9zd+7hB94ob0VoU1MJBtzlkh8l4o2LxN7L5d6/87LooKU1GM8Huz+L2jZSykZxuqqCKW06XK7D5/lkI13yIxxzIxyzIqYRsG9yYypaETGysWrHfM5kTNYJzZwE2C1YX5BsuzZeQcX5B+d4iUYOO8X+H/I375IsPXjAl+E1z8w+FkWA5DIW1mc8UePdvH4uwX8RZTsZVnkvrt32zo7V7OpDuR4WHCQRZhLJabpFLZbTzaqnOk4J0ZYmJQDXyFygyDZJefYQg62o6sToU1MnNJxYMHfytvzbv6u+dydCG98/NFaSh4gUpaTmSSFBiuSwWL65XEdktMjhCLYTb19fUyj4QgvL1IsKDt/Dq5ArwuX2z9mJjlkxbxGO11YexauXLvRs4iDd2KEuHIIg0NDcAV2aYAsexbn8Cvsg69yAt/MP4DwkDrkSeaTciKlmj+n5CxOpvfe7qtsbPpTKm0WKTNeIodFhmZPqu5iyypGNkiPB+Q433wGbBa4yCkyOVFjplEjAwsYtvvwcGTkH7zEGcwTLsxjLqwjH3LDEB6cjWmawrK6Brjx3WyJA4GZrtRBB6JC55RAnU7MRmcy8w2m+paW9qtXy2rPRQlF72dkgOQkkEJaQiE3X0b+sfcHBlblZAMy3iWboDxTBlegmjsuz2PFTqdinWghzvTgdfmJ4N79fmyu4qN4QXM7MusKa87PJuQtTOA0trbB8yDItK8nMEEc3YGQPSc+8x1i5ixiJkggg8R0QEpfQaFVNzVBr19//ZWoUk5LI4E04rfMLFsxoShm3TTKacesyGlZEdOpERGyfFBgrXDEiUB4QQxfAwsLGXtzFCCauzaV19VzA2ZpqqrxovDnxrMc8HRAoIM4mlM85aMUWphA3H3jpi2upLTsjTQyICXPTk9TlNuTGxoe/pZNBRkEkBELyKdfyyZYa6rBhbaOd6JlIES0+LS44xoy9Tu6upeTxCCCvzaFX9+CtDXcREPrpQJLcapUnaXUacor4Fbg5myfmAbzOyk0QMxwSMw4KRDC00FoExMFJSUz0lNASgJIIcK8V9HJ/QMDAHb2LooWYOQgWHaMqfrpp5+g6ZnzFxYRJCBcuPA0P02i77nZawvxpCCpurFpF1MwM54B8BSHOMrOHN79fmSMQd24dftLCrxjqTBpQEpyTE1OV6vgOtIvJbWNr4erwQn57FCF0Hxm0n6isr7ZNVEGQiUAK/zkNO8gRcRSmcxnqkqqa5VF5UlCtWda/txYDohhg1MsF3xOEEcEW8HmOz4+fpgndojPAvEZgJgOEtL/SqbcuHULfkJ4MKeDTD3AKMFJxQdRitKahkmvie4bvcEc3duRMoCFYCnAipxDBS5h/GnhfIDjw4KDCK5jVP7nJG6+sRgybF4wWqJc5xLHBLEUgM8GhCwnIoWhN9q+Ijyoy9e6l+LVkAefxdHywqo62zpsvLrmSxF5Otc46Vs4qXOIZBpWPB0rmhUuXBBTsD5VSFdb4GW1GUNBaqJUPys2F0SzQAwDnKKDWIY3lTt1g+08KFVZzRs4WFUEOQ8np8itIyPICLYJtnhLe4elslZdXKkpqTxzrqGz+/pUTjZdv9l7iKWYEQWzzwMRHBDJBtGcpaS8ix1X7BZP8mAqFFXJ7DDkICHSOVixJVVWUn0e9oXd4sWC/0KesfTLeDEIFQGsAITyQBgX4HgL8HxLVa3daFKPeVCwVzOVxa+GqZDCIlTl66Hy71MkIlPZ1a5u29CaEtwfvGFNre0ZEtPqeJlziAJgZAAjBhgRCBbCw14YKzJW1titf9dTPCg40gTmioUxEKlEkJPU6RjFApzkuzjRfrIYx5RH5ciD6bLtqWLXWPFbYYjBY2PkgVSFa7y0og4ZPc/oWZ5NsEe801TOIU9S4bkqAUb11IN8nazE1HNSOSdMeZShhmdpj/W0ns+Dgh3FNZSvJipcsLbQT8d95pncypxQ5eZUpLdtf8fn6oU8m+CvWFt2NiBbueyUbDZW4QDv6JP5YVSOGOUcrOKrWGkIS11R1/hMx/5RL+HZBKc2/NH/cL6Jqysh8nQYuuIIRR7FVqUU6MXm8roLrXAw2k1fpv+K9z/U/5c3MfFvTwpVXelwKEwAAAAASUVORK5CYII=" Width="1.4cm" Height="0.8cm" Left="0.8cm" Top="0.2cm" Sizing="ScaleProportional" MimeType="image/png" Name="pictureBox1" />
<TextBox Width="1.652cm" Height="0.4cm" Left="23.641cm" Top="0.1cm" Value="Created At:" Name="textBox114">
<Style Color="31, 73, 125">
<Font Size="8pt" />
</Style>
</TextBox>
<TextBox Width="3.501cm" Height="0.4cm" Left="25.293cm" Top="0.1cm" Value="= Now()" Format="{0:MM'/'dd'/'yyyy HH:mm:ss}" Name="textBox115">
<Style Color="31, 73, 125">
<Font Size="8pt" />
</Style>
</TextBox>
<TextBox Width="1.101cm" Height="0.4cm" Left="24.192cm" Top="1.761cm" Value="Page:" Name="textBox116">
<Style Color="31, 73, 125">
<Font Size="8pt" />
</Style>
</TextBox>
<TextBox Width="2.7cm" Height="0.4cm" Left="25.293cm" Top="1.761cm" Value="=PageNumber + ' / ' + PageCount" Name="textBox117">
<Style Color="31, 73, 125">
<Font Size="8pt" />
</Style>
</TextBox>
<TextBox Width="3.6cm" Height="0.4cm" Left="7.8cm" Top="1.761cm" Value="= Parameters.startDateTime.Value" Format="{0:MM'/'dd'/'yyyy HH:mm:ss}" Name="textBox11">
<Style TextAlign="Left" VerticalAlign="Middle" />
</TextBox>
<TextBox Width="2cm" Height="0.4cm" Left="5.799cm" Top="1.761cm" Value="Start Date:" Name="textBox10">
<Style TextAlign="Left" VerticalAlign="Middle">
<Font Bold="True" />
</Style>
</TextBox>
<TextBox Width="3.6cm" Height="0.4cm" Left="18cm" Top="1.722cm" Value="= Parameters.endDateTime.Value" Format="{0:MM'/'dd'/'yyyy HH:mm:ss}" Name="textBox9">
<Style TextAlign="Left" VerticalAlign="Middle" />
</TextBox>
<TextBox Width="2cm" Height="0.4cm" Left="16cm" Top="1.722cm" Value="End Date:" Name="textBox8">
<Style TextAlign="Left" VerticalAlign="Middle">
<Font Bold="True" />
</Style>
</TextBox>
</Items>
</PageHeaderSection>
<DetailSection Height="0cm" Name="detailSection1">
<Style Visible="False" />
</DetailSection>
</Items>
<PageSettings PaperKind="A4" Landscape="True" ContinuousPaper="False">
<Margins>
<MarginsU Left="0.5cm" Right="0.5cm" Top="1cm" Bottom="1cm" />
</Margins>
</PageSettings>
<StyleSheet>
<StyleRule>
<Style>
<Padding Left="2pt" Right="2pt" />
</Style>
<Selectors>
<TypeSelector Type="TextItemBase" />
<TypeSelector Type="HtmlTextBox" />
</Selectors>
</StyleRule>
<StyleRule>
<Style Color="Black">
<Font Name="Arial Unicode MS" Size="9pt" />
<BorderStyle Default="Solid" />
<BorderColor Default="Black" />
<BorderWidth Default="1px" />
</Style>
<Selectors>
<StyleSelector Type="Table" StyleName="Normal.TableNormal" />
</Selectors>
</StyleRule>
<StyleRule>
<Style>
<Font Name="Arial Unicode MS" Size="9pt" />
<BorderStyle Default="Solid" />
<BorderColor Default="Black" />
<BorderWidth Default="1px" />
</Style>
<Selectors>
<DescendantSelector>
<Selectors>
<TypeSelector Type="Table" />
<StyleSelector Type="ReportItem" StyleName="Normal.TableBody" />
</Selectors>
</DescendantSelector>
</Selectors>
</StyleRule>
<StyleRule>
<Style VerticalAlign="Middle">
<Font Name="Arial Unicode MS" Size="10pt" />
<BorderStyle Default="Solid" />
<BorderColor Default="Black" />
<BorderWidth Default="1px" />
</Style>
<Selectors>
<DescendantSelector>
<Selectors>
<TypeSelector Type="Table" />
<StyleSelector Type="ReportItem" StyleName="Normal.TableHeader" />
</Selectors>
</DescendantSelector>
</Selectors>
</StyleRule>
<StyleRule>
<Style Color="0, 63, 89">
<Font Name="Arial Unicode MS" Size="9pt" />
<BorderStyle Default="Solid" />
<BorderColor Default="187, 220, 235" />
<BorderWidth Default="1px" />
</Style>
<Selectors>
<StyleSelector Type="Table" StyleName="BlueOpal.TableNormal" />
</Selectors>
</StyleRule>
<StyleRule>
<Style Color="0, 63, 89">
<Font Name="Arial Unicode MS" Size="9pt" />
<BorderStyle Default="Solid" />
<BorderColor Default="187, 220, 235" />
<BorderWidth Default="1px" />
</Style>
<Selectors>
<DescendantSelector>
<Selectors>
<TypeSelector Type="Table" />
<StyleSelector Type="ReportItem" StyleName="BlueOpal.TableBody" />
</Selectors>
</DescendantSelector>
</Selectors>
</StyleRule>
<StyleRule>
<Style BackgroundColor="233, 244, 249" Color="0, 63, 89" VerticalAlign="Middle">
<Font Name="Arial Unicode MS" Size="10pt" />
<BorderStyle Default="Solid" />
<BorderColor Default="187, 220, 235" />
<BorderWidth Default="1px" />
</Style>
<Selectors>
<DescendantSelector>
<Selectors>
<TypeSelector Type="Table" />
<StyleSelector Type="ReportItem" StyleName="BlueOpal.TableHeader" />
</Selectors>
</DescendantSelector>
</Selectors>
</StyleRule>
</StyleSheet>
<Groups>
<Group Name="group3">
<GroupHeader>
<GroupHeaderSection PageBreak="Before" Height="1.2cm" Name="PiecesSection">
<Items>
<Table DataSourceName="pr_AdjustmentManager_LoadPiecesSummary " Width="28.565cm" Height="1.2cm" Left="0cm" Top="0cm" RowHeadersPrintOnEveryPage="True" ColumnHeadersPrintOnEveryPage="True" Name="piecesTable" StyleName="Normal.TableNormal">
<Body>
<Cells>
<TableCell RowIndex="0" ColumnIndex="0" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.859cm" Height="0.5cm" Left="0cm" Top="0cm" Value="= Fields.SerialNumber" Format="" Name="textBox3" StyleName="BlueOpal.TableBody">
<Style Color="Black" TextAlign="Center" VerticalAlign="Middle">
<BorderColor Default="DimGray" />
</Style>
</TextBox>
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="1" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="1.972cm" Height="0.5cm" Left="0cm" Top="0cm" Value="= Fields.OrderNumber" Format="" Name="textBox2" StyleName="BlueOpal.TableBody">
<Style Color="Black" TextAlign="Center" VerticalAlign="Middle">
<BorderColor Default="DimGray" />
</Style>
</TextBox>
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="2" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="4.576cm" Height="0.5cm" Left="0cm" Top="0cm" Value="= Fields.PieceNum" Format="" Name="textBox1" StyleName="BlueOpal.TableBody">
<Style Color="Black" TextAlign="Center" VerticalAlign="Middle">
<BorderColor Default="DimGray" />
</Style>
</TextBox>
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="3" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="1.248cm" Height="0.5cm" Left="0cm" Top="0cm" Value="= Fields.WetScale2" Format="" Name="textBox28" StyleName="BlueOpal.TableBody">
<Style Color="Black" TextAlign="Center" VerticalAlign="Middle">
<BorderColor Default="DimGray" />
</Style>
</TextBox>
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="4" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="1.53cm" Height="0.5cm" Left="0cm" Top="0cm" Value="= Fields.WetUptakePiece" Format="" Name="textBox12" StyleName="BlueOpal.TableBody">
<Style Color="Black" TextAlign="Center" VerticalAlign="Middle">
<BorderColor Default="DimGray" />
</Style>
</TextBox>
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="5" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="1.306cm" Height="0.5cm" Left="0cm" Top="0cm" Value="= Fields.WetUptakePercent" Format="" Name="textBox5" StyleName="BlueOpal.TableBody">
<Style Color="Black" TextAlign="Center" VerticalAlign="Middle">
<BorderColor Default="DimGray" />
</Style>
</TextBox>
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="6" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="2.259cm" Height="0.5cm" Left="0cm" Top="0cm" Value="= Fields.WetScale2BeforeAdjustment" Format="" Name="textBox29" StyleName="BlueOpal.TableBody">
<Style Color="Black" TextAlign="Center" VerticalAlign="Middle">
<BorderColor Default="DimGray" />
</Style>
</TextBox>
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="7" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.894in" Height="0.5cm" Left="0cm" Top="0cm" Value="= Fields.AmountWCRemoveAdd" Format="" Name="textBox30" StyleName="BlueOpal.TableBody">
<Style Color="Black" TextAlign="Center" VerticalAlign="Middle">
<BorderColor Default="DimGray" />
</Style>
</TextBox>
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="8" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.773in" Height="0.5cm" Left="0cm" Top="0cm" Value="= Fields.WetScale2AfterRework" Format="" Name="textBox13" StyleName="BlueOpal.TableBody">
<Style Color="Black" TextAlign="Center" VerticalAlign="Middle">
<BorderColor Default="DimGray" />
</Style>
</TextBox>
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="9" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.764in" Height="0.5cm" Left="0cm" Top="0cm" Value="= Fields.WetUptakeAfterRework" Format="" Name="textBox14" StyleName="BlueOpal.TableBody">
<Style Color="Black" TextAlign="Center" VerticalAlign="Middle">
<BorderColor Default="DimGray" />
</Style>
</TextBox>
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="10" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.768in" Height="0.5cm" Left="0cm" Top="0cm" Value="= Fields.WetUptakePercentAfterRework" Format="" Name="textBox16" StyleName="BlueOpal.TableBody">
<Style Color="Black" TextAlign="Center" VerticalAlign="Middle">
<BorderColor Default="DimGray" />
</Style>
</TextBox>
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="11" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.584in" Height="0.5cm" Left="0cm" Top="0cm" Value="= Fields.PieceStatus" Format="" Name="textBox18" StyleName="BlueOpal.TableBody">
<Style Color="Black" TextAlign="Center" VerticalAlign="Middle">
<BorderColor Default="DimGray" />
</Style>
</TextBox>
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="12" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.573in" Height="0.5cm" Left="0cm" Top="0cm" Value="= Fields.ProductName" Format="" Name="textBox24" StyleName="BlueOpal.TableBody">
<Style Color="Black" TextAlign="Center" VerticalAlign="Middle">
<BorderColor Default="DimGray" />
</Style>
</TextBox>
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="13" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.708in" Height="0.5cm" Left="0in" Top="0in" Value="= Fields.PieceDateTime" Format="{0:MM'/'dd'/'yyyy HH:mm:ss}" Name="textBox32" StyleName="BlueOpal.TableBody">
<Style Color="Black" TextAlign="Center" VerticalAlign="Middle">
<BorderColor Default="DimGray" />
</Style>
</TextBox>
</ReportItem>
</TableCell>
<TableCell RowIndex="0" ColumnIndex="14" RowSpan="1" ColumnSpan="1">
<ReportItem>
<TextBox Width="0.769in" Height="0.5cm" Left="0in" Top="0in" Value="= Fields.UpdateDateTime" Format="{0:MM'/'dd'/'yyyy HH:mm:ss}" Name="textBox31" StyleName="BlueOpal.TableBody">
<Style Color="Black" TextAlign="Center" VerticalAlign="Middle">
<BorderColor Default="DimGray" />
</Style>
</TextBox>
</ReportItem>
</TableCell>
</Cells>
<Columns>
<Column Width="0.859cm" />
<Column Width="1.972cm" />
<Column Width="4.576cm" />
<Column Width="1.248cm" />
<Column Width="1.53cm" />
<Column Width="1.306cm" />
<Column Width="2.259cm" />
<Column Width="0.894in" />
<Column Width="0.773in" />
<Column Width="0.764in" />
<Column Width="0.768in" />
<Column Width="0.584in" />
<Column Width="0.573in" />
<Column Width="0.708in" />
<Column Width="0.769in" />
</Columns>
<Rows>
<Row Height="0.5cm" />
</Rows>
</Body>
<Corner />
<Style>
<BorderColor Default="DimGray" />
</Style>
<RowGroups>
<TableGroup Name="detail">
<Groupings>
<Grouping />
</Groupings>
</TableGroup>
</RowGroups>
<ColumnGroups>
<TableGroup Name="actionOrdinal">
<ReportItem>
<TextBox Width="0.859cm" Height="0.7cm" Left="11.04cm" Top="1cm" Value="Seq" Name="numberSequenceColumn" StyleName="BlueOpal.TableHeader">
<Style BackgroundColor="224, 224, 224" Color="Black" TextAlign="Center">
<BorderColor Default="DimGray" />
</Style>
</TextBox>
</ReportItem>
<ChildGroups>
<TableGroup Name="group6" />
</ChildGroups>
</TableGroup>
<TableGroup Name="group">
<ReportItem>
<TextBox Width="1.972cm" Height="0.7cm" Left="0in" Top="0in" Value="Order Num" Name="textBox22" StyleName="BlueOpal.TableHeader">
<Style BackgroundColor="224, 224, 224" Color="Black" TextAlign="Center">
<BorderColor Default="DimGray" />
</Style>
</TextBox>
</ReportItem>
<ChildGroups>
<TableGroup Name="solutionActionType_Localized" />
</ChildGroups>
</TableGroup>
<TableGroup Name="group1">
<ReportItem>
<TextBox Width="4.576cm" Height="0.7cm" Left="0in" Top="0in" Value="Piece Num" Name="textBox26" StyleName="BlueOpal.TableHeader">
<Style BackgroundColor="224, 224, 224" Color="Black" TextAlign="Center">
<BorderColor Default="DimGray" />
</Style>
</TextBox>
</ReportItem>
<ChildGroups>
<TableGroup Name="name" />
</ChildGroups>
</TableGroup>
<TableGroup Name="group8">
<ReportItem>
<TextBox Width="1.248cm" Height="0.7cm" Left="0in" Top="0in" Value="Wet Scale2" Name="textBox15" StyleName="BlueOpal.TableHeader">
<Style BackgroundColor="224, 224, 224" Color="Black">
<BorderColor Default="DimGray" />
</Style>
</TextBox>
</ReportItem>
</TableGroup>
<TableGroup Name="weightTarget">
<ReportItem>
<TextBox Width="1.53cm" Height="0.7cm" Left="0in" Top="0in" Value="Wet Uptake Piece" Name="textBox6" StyleName="Normal.TableBody">
<Style BackgroundColor="224, 224, 224" Color="Black" TextAlign="Left" VerticalAlign="Middle">
<Font Name="Arial Unicode MS" Size="10pt" Bold="False" />
<BorderStyle Default="Solid" Bottom="Solid" Right="Solid" />
<BorderColor Default="DimGray" Bottom="DimGray" Right="DimGray" />
</Style>
</TextBox>
</ReportItem>
</TableGroup>
<TableGroup Name="group9">
<ReportItem>
<TextBox Width="1.306cm" Height="0.7cm" Left="0in" Top="0in" Value="%Wet Update Nom" Name="textBox27" StyleName="Normal.TableBody">
<Style BackgroundColor="224, 224, 224" Color="Black" TextAlign="Left" VerticalAlign="Middle">
<Font Name="Arial Unicode MS" Size="10pt" Bold="False" />
<BorderStyle Default="Solid" Bottom="Solid" Right="Solid" />
<BorderColor Default="DimGray" Bottom="DimGray" Right="DimGray" />
</Style>
</TextBox>
</ReportItem>
</TableGroup>
<TableGroup Name="group28">
<ReportItem>
<TextBox Width="2.259cm" Height="0.7cm" Left="0in" Top="0in" Value="Start Weight Before Adjustment" Name="textBox4" StyleName="Normal.TableBody">
<Style BackgroundColor="224, 224, 224" Color="Black" TextAlign="Left" VerticalAlign="Middle">
<Font Name="Arial Unicode MS" Size="10pt" Bold="False" />
<BorderStyle Default="Solid" Bottom="Solid" Right="Solid" />
<BorderColor Default="DimGray" Bottom="DimGray" Right="DimGray" />
</Style>
</TextBox>
</ReportItem>
</TableGroup>
<TableGroup Name="group4">
<ReportItem>
<TextBox Width="0.894in" Height="0.7cm" Left="0in" Top="0in" Value="Amount WC Remove/Add" Name="textBox7">
<Style BackgroundColor="224, 224, 224" VerticalAlign="Middle" LineWidth="1pt">
<Font Size="10pt" Bold="False" />
<BorderStyle Default="Solid" />
<BorderColor Default="DimGray" />
<BorderWidth Default="1px" />
</Style>
</TextBox>
</ReportItem>
</TableGroup>
<TableGroup Name="group2">
<ReportItem>
<TextBox Width="0.773in" Height="0.7cm" Left="0in" Top="0in" Value="Final Weight After Adjustment" Name="textBox17">
<Style BackgroundColor="224, 224, 224" VerticalAlign="Middle" LineWidth="1pt">
<Font Size="10pt" Bold="False" />
<BorderStyle Default="Solid" />
<BorderColor Default="DimGray" />
<BorderWidth Default="1px" />
</Style>
</TextBox>
</ReportItem>
</TableGroup>
<TableGroup Name="group5">
<ReportItem>
<TextBox Width="0.764in" Height="0.7cm" Left="0in" Top="0in" Value="Wet Uptake After Adjustment" Name="textBox19">
<Style BackgroundColor="224, 224, 224" VerticalAlign="Middle" LineWidth="1pt">
<Font Size="10pt" Bold="False" />
<BorderStyle Default="Solid" />
<BorderColor Default="DimGray" />
<BorderWidth Default="1px" />
</Style>
</TextBox>
</ReportItem>
</TableGroup>
<TableGroup Name="group7">
<ReportItem>
<TextBox Width="0.768in" Height="0.7cm" Left="0in" Top="0in" Value="%Wet Uptake After Adjustment" Name="textBox21">
<Style BackgroundColor="224, 224, 224" VerticalAlign="Middle" LineWidth="1pt">
<Font Size="10pt" Bold="False" />
<BorderStyle Default="Solid" />
<BorderColor Default="DimGray" />
<BorderWidth Default="1px" />
</Style>
</TextBox>
</ReportItem>
</TableGroup>
<TableGroup Name="group11">
<ReportItem>
<TextBox Width="0.584in" Height="0.7cm" Left="0in" Top="0in" Value="Piece Status" Name="textBox25" StyleName="">
<Style BackgroundColor="224, 224, 224" VerticalAlign="Middle">
<Font Size="10pt" />
<BorderStyle Default="Solid" />
<BorderColor Default="DimGray" />
<BorderWidth Default="1px" />
</Style>
</TextBox>
</ReportItem>
</TableGroup>
<TableGroup Name="group10">
<ReportItem>
<TextBox Width="0.573in" Height="0.7cm" Left="0in" Top="0in" Value="Product Name" Name="textBox20" StyleName="">
<Style BackgroundColor="224, 224, 224" VerticalAlign="Middle">
<Font Size="10pt" />
<BorderStyle Default="Solid" />
<BorderColor Default="DimGray" />
<BorderWidth Default="1px" />
</Style>
</TextBox>
</ReportItem>
</TableGroup>
<TableGroup Name="group12">
<ReportItem>
<TextBox Width="0.708in" Height="0.7cm" Left="0in" Top="0in" Value="Piece Datetime" Name="textBox23" StyleName="">
<Style BackgroundColor="224, 224, 224" VerticalAlign="Middle">
<Font Size="10pt" />
<BorderStyle Default="Solid" />
<BorderColor Default="DimGray" />
<BorderWidth Default="1px" />
</Style>
</TextBox>
</ReportItem>
</TableGroup>
<TableGroup Name="group13">
<ReportItem>
<TextBox Width="0.769in" Height="0.7cm" Left="0in" Top="0in" Value="Adjusted Timestamp" Name="textBox34" StyleName="">
<Style BackgroundColor="224, 224, 224" TextAlign="Left" VerticalAlign="Middle">
<Font Size="10pt" />
<BorderStyle Default="Solid" />
<BorderColor Default="DimGray" />
<BorderWidth Default="1px" />
</Style>
</TextBox>
</ReportItem>
</TableGroup>
</ColumnGroups>
</Table>
</Items>
</GroupHeaderSection>
</GroupHeader>
<GroupFooter>
<GroupFooterSection Height="0cm" Name="groupFooterSection2" />
</GroupFooter>
</Group>
</Groups>
<ReportParameters>
<ReportParameter Name="startDateTime" Type="DateTime">
<Value>
<String>2024-04-05 13:11:34</String>
</Value>
</ReportParameter>
<ReportParameter Name="cultureId">
<Value>
<String>en-US</String>
</Value>
</ReportParameter>
<ReportParameter Name="endDateTime" Type="DateTime">
<Value>
<String>2024-04-07 13:11:34</String>
</Value>
</ReportParameter>
<ReportParameter Name="PFDSConnectionString">
<Value>
<String></String>
</Value>
</ReportParameter>
<ReportParameter Name="line" />
</ReportParameters>
<Bindings>
<Binding Path="Culture" Expression="= Parameters.cultureId.Value" />
</Bindings>
</Report>1 Answer, 1 is accepted
0
Hi Jim,
Thank you for the update. Also, thank you for the snippet and screenshot.
As you correctly noted, by default, CSV rendering includes all the text boxes in the output, using their Name properties as headers (more on that in the CSV rendering considerations). It also adds the headers of the table (which are considered static text) as separate columns. For instance, when rendering a table like the one below:
It will result in a CSV like this:
If you wish to hide the columns containing static text (as shown in the screenshot above, these are columns one and three), you can enable the device information setting NoStaticText by setting it to true (the default is false). You can do this either directly in the report definition (more on that here) or through the extensions element in your report engine configuration.
To modify the column headers in the CSV output, you need to change the Name property of the corresponding text box, as you correctly noted.
Please let me know if I missed anything or if any other questions arise.
Regards,
Ivet
Progress Telerik
Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.
How can I resolve it??
Thanks!
<?xml version="1.0" encoding="utf-8"?> <Report Width="29cm" Name="AdjustmentPiecesSummary" Zoom="1.5" SnapGridSize="0.1cm" xmlns="http://schemas.telerik.com/reporting/2021/2.0"> <Style> <Font Name="Arial Unicode MS" /> </Style> <DataSources> <SqlDataSource QueryDesignerState="null" ParameterValues="{"@StartDateTime":"'2024-03-14 15:20:19.000'","@EndDateTime":"'2024-03-16 15:20:19.000'"}" ConnectionString="= Parameters.PFDSConnectionString.Value" ProviderName="System.Data.SqlClient" SelectCommand="[AdjustmentManager].[pr_AdjustmentManager_LoadPiecesSummary]" SelectCommandType="StoredProcedure" CommandTimeout="90" Name="pr_AdjustmentManager_LoadPiecesSummary "> <Parameters> <SqlDataSourceParameter DbType="DateTime" Name="@StartDateTime"> <Value> <String>= Parameters.startDateTime.Value</String> </Value> </SqlDataSourceParameter> <SqlDataSourceParameter DbType="DateTime" Name="@EndDateTime"> <Value> <String>= Parameters.endDateTime.Value</String> </Value> </SqlDataSourceParameter> </Parameters> </SqlDataSource> </DataSources> <Items> <PageHeaderSection Height="2.4cm" Name="pageHeaderSection1"> <Style> <BorderStyle Default="Solid" /> <BorderColor Default="0, 204, 0" /> <BorderWidth Default="2pt" /> </Style> <Items> <TextBox Width="4.277in" Height="0.354in" Left="8.2cm" Top="0.5cm" Value="Adjustment Pieces Summary" Name="adjustmentPiecesSummaryTitle"> <Style Color="31, 73, 125" TextAlign="Center"> <Font Size="22pt" Bold="True" /> </Style> </TextBox> <PictureBox Image="iVBORw0KGgoAAAANSUhEUgAAACUAAAAlCAIAAABK/LdUAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOvAAADrwBlbxySQAAC0FJREFUWEe9lXlcU1cWxy8oiNa21ulmHVtb/bQ6TmuXkVqdjlpCUAZRCyqKKyjuBgKETUkgEPYA2UmALGTf94RdKAgiiyCCKIIoigubsth1mPtIikt1nD/mM7/P++fdd8753nPuueeBiZfpVt8tQ5WGZIrGFvoftG4IsLgdsLgFWd2Ci70J1gNsa9rZxsrR0RG79cv0n3i9t3vzizknDAE7jZ5+JvcdJnd/s/tui/teK2q/FYWArW5BhaiThd4kY0jRWePY+Jjd88V6Pu+XX34x15iD9Ae8DOiNBvQmg7uffuNh7W6c+jheFY7XhIVrDx01bttnWQ/Z+yxugYWoI0Weaabojs52e4gX6Dm8kdERehHzn/pNKC0arfMI0OxjmOkNrQ2DQ4M///zzvyb16NGjnt6eohprihF/0Pz9Lgtqtwm1z4oKNe+qqC+DBvZYf9CzvNGx0URz2hqd59816I2arUwLq+9u3/CD4drmWkFRAVlPTtOmMkw0U5Wxs/sqtIehGy/VE83RO03r/YwofzPqiNm3uNZqi/ZHPcWDZaQV5X6t8VqhQm9XB1Q3nYU5icol+zWHUXqvdQYPN4OHu9EDbfLw0KP9tNvi9ITzF89DR1gSXmmev3mTjwG1zYg6ZNxe13LOFvMZPcUrrCtbqdjxqczbV3G4rbO9vavjiC58pW49Wu0Tqopim3PlpQphkShZlxqgPojWbUDp0b66rblFueOPxn/77TdZhXSr0dtbh9picA/RH+67c9se9wk95t3rv79Zhlsk3LZKElDTUnfxyqXNqmN/U/hEqomtVy79+OOPMIkHDx/AI4TGQ8ND2irdHt2BNVq0u86TbMqESFgeZjHDS7/BU+u+0eDBsFDhJmzBp/SYl1uqeZcf8B5/L9Us7Lt3Z4s84lPxLk6h+MHDh4XnykNU8VukhzdJA/cpMBQzu+tGN3Tp7Ll2XB+6WoNep/XML+bB6LD+Jw0YpNG07n7a7R3XOmzBp2TnDT0YXieMeyU3aBU/qu/eXYI+911BQJqBOzA0eEpH+4t4z1Kx3zfCPSskO5fJtnwq37RZGVRWXwEdu29279QGfa1Gr9f4NlxqhCulDeVo/cZ1OrSb0YNiok6Gfyw7r7S+9g126Ez2iUyj9GpP92JemDs/9v7gAF6f97YgcLsYX1h7pvP6teb2i5mmvK/F+5eIfb6TBTa2XYD9qT5rcFPv8FT4kyxkVYWWVZyHMeDwSiJBRSRbs2DesjKFpdoKu+/2ndt2XpxWPJ0e/h4ruvXqFUahZiYnuKDUVN92cR43ZFNBwt3792xmNgkrdV9JDm0owBDNTIyS9L0iOMuSC4dRVXPNGo3fl2pPnJpgO7lbd277GnbDgq/RrHfXeiXokxAePGcfHt2RErOKnQIL6FdAnc+K6ey5TtSKXmVjrbU/TFIm4B1v6WhjWBU+UlKCPn9gcLC+rXmp6MAHQv+TsiSY6Mjo6DYldpl0i7fkUP/gAHSBzXVcF7FC5eGqdF+pct+pCUR4ww8erGBmgsw4v3wGPEhXdtpXzKTB4aEdAuo8xqkr3V09vTdzzZpNHNICVqgL+9jM3GOhMgZ0vD/Q/40wYi53v5cgemxsDCKPqpI+EvqtFO7r6EKmARTekLFc7vW5bMMX8vVrNT4I715//zJqFkgnHRdwIfszRsYqZsbo2Ji/gPUJO/mAMGcpjeBMxU2nhznRsM60YGdWcJyKDx1hMVz5p2flHvqOewoOJrgSpqa9zd+7hB94ob0VoU1MJBtzlkh8l4o2LxN7L5d6/87LooKU1GM8Huz+L2jZSykZxuqqCKW06XK7D5/lkI13yIxxzIxyzIqYRsG9yYypaETGysWrHfM5kTNYJzZwE2C1YX5BsuzZeQcX5B+d4iUYOO8X+H/I375IsPXjAl+E1z8w+FkWA5DIW1mc8UePdvH4uwX8RZTsZVnkvrt32zo7V7OpDuR4WHCQRZhLJabpFLZbTzaqnOk4J0ZYmJQDXyFygyDZJefYQg62o6sToU1MnNJxYMHfytvzbv6u+dydCG98/NFaSh4gUpaTmSSFBiuSwWL65XEdktMjhCLYTb19fUyj4QgvL1IsKDt/Dq5ArwuX2z9mJjlkxbxGO11YexauXLvRs4iDd2KEuHIIg0NDcAV2aYAsexbn8Cvsg69yAt/MP4DwkDrkSeaTciKlmj+n5CxOpvfe7qtsbPpTKm0WKTNeIodFhmZPqu5iyypGNkiPB+Q433wGbBa4yCkyOVFjplEjAwsYtvvwcGTkH7zEGcwTLsxjLqwjH3LDEB6cjWmawrK6Brjx3WyJA4GZrtRBB6JC55RAnU7MRmcy8w2m+paW9qtXy2rPRQlF72dkgOQkkEJaQiE3X0b+sfcHBlblZAMy3iWboDxTBlegmjsuz2PFTqdinWghzvTgdfmJ4N79fmyu4qN4QXM7MusKa87PJuQtTOA0trbB8yDItK8nMEEc3YGQPSc+8x1i5ixiJkggg8R0QEpfQaFVNzVBr19//ZWoUk5LI4E04rfMLFsxoShm3TTKacesyGlZEdOpERGyfFBgrXDEiUB4QQxfAwsLGXtzFCCauzaV19VzA2ZpqqrxovDnxrMc8HRAoIM4mlM85aMUWphA3H3jpi2upLTsjTQyICXPTk9TlNuTGxoe/pZNBRkEkBELyKdfyyZYa6rBhbaOd6JlIES0+LS44xoy9Tu6upeTxCCCvzaFX9+CtDXcREPrpQJLcapUnaXUacor4Fbg5myfmAbzOyk0QMxwSMw4KRDC00FoExMFJSUz0lNASgJIIcK8V9HJ/QMDAHb2LooWYOQgWHaMqfrpp5+g6ZnzFxYRJCBcuPA0P02i77nZawvxpCCpurFpF1MwM54B8BSHOMrOHN79fmSMQd24dftLCrxjqTBpQEpyTE1OV6vgOtIvJbWNr4erwQn57FCF0Hxm0n6isr7ZNVEGQiUAK/zkNO8gRcRSmcxnqkqqa5VF5UlCtWda/txYDohhg1MsF3xOEEcEW8HmOz4+fpgndojPAvEZgJgOEtL/SqbcuHULfkJ4MKeDTD3AKMFJxQdRitKahkmvie4bvcEc3duRMoCFYCnAipxDBS5h/GnhfIDjw4KDCK5jVP7nJG6+sRgybF4wWqJc5xLHBLEUgM8GhCwnIoWhN9q+Ijyoy9e6l+LVkAefxdHywqo62zpsvLrmSxF5Otc46Vs4qXOIZBpWPB0rmhUuXBBTsD5VSFdb4GW1GUNBaqJUPys2F0SzQAwDnKKDWIY3lTt1g+08KFVZzRs4WFUEOQ8np8itIyPICLYJtnhLe4elslZdXKkpqTxzrqGz+/pUTjZdv9l7iKWYEQWzzwMRHBDJBtGcpaS8ix1X7BZP8mAqFFXJ7DDkICHSOVixJVVWUn0e9oXd4sWC/0KesfTLeDEIFQGsAITyQBgX4HgL8HxLVa3daFKPeVCwVzOVxa+GqZDCIlTl66Hy71MkIlPZ1a5u29CaEtwfvGFNre0ZEtPqeJlziAJgZAAjBhgRCBbCw14YKzJW1titf9dTPCg40gTmioUxEKlEkJPU6RjFApzkuzjRfrIYx5RH5ciD6bLtqWLXWPFbYYjBY2PkgVSFa7y0og4ZPc/oWZ5NsEe801TOIU9S4bkqAUb11IN8nazE1HNSOSdMeZShhmdpj/W0ns+Dgh3FNZSvJipcsLbQT8d95pncypxQ5eZUpLdtf8fn6oU8m+CvWFt2NiBbueyUbDZW4QDv6JP5YVSOGOUcrOKrWGkIS11R1/hMx/5RL+HZBKc2/NH/cL6Jqysh8nQYuuIIRR7FVqUU6MXm8roLrXAw2k1fpv+K9z/U/5c3MfFvTwpVXelwKEwAAAAASUVORK5CYII=" Width="1.4cm" Height="0.8cm" Left="0.8cm" Top="0.2cm" Sizing="ScaleProportional" MimeType="image/png" Name="pictureBox1" /> <TextBox Width="1.652cm" Height="0.4cm" Left="23.641cm" Top="0.1cm" Value="Created At:" Name="textBox114"> <Style Color="31, 73, 125"> <Font Size="8pt" /> </Style> </TextBox> <TextBox Width="3.501cm" Height="0.4cm" Left="25.293cm" Top="0.1cm" Value="= Now()" Format="{0:MM'/'dd'/'yyyy HH:mm:ss}" Name="textBox115"> <Style Color="31, 73, 125"> <Font Size="8pt" /> </Style> </TextBox> <TextBox Width="1.101cm" Height="0.4cm" Left="24.192cm" Top="1.761cm" Value="Page:" Name="textBox116"> <Style Color="31, 73, 125"> <Font Size="8pt" /> </Style> </TextBox> <TextBox Width="2.7cm" Height="0.4cm" Left="25.293cm" Top="1.761cm" Value="=PageNumber + ' / ' + PageCount" Name="textBox117"> <Style Color="31, 73, 125"> <Font Size="8pt" /> </Style> </TextBox> <TextBox Width="3.6cm" Height="0.4cm" Left="7.8cm" Top="1.761cm" Value="= Parameters.startDateTime.Value" Format="{0:MM'/'dd'/'yyyy HH:mm:ss}" Name="textBox11"> <Style TextAlign="Left" VerticalAlign="Middle" /> </TextBox> <TextBox Width="2cm" Height="0.4cm" Left="5.799cm" Top="1.761cm" Value="Start Date:" Name="textBox10"> <Style TextAlign="Left" VerticalAlign="Middle"> <Font Bold="True" /> </Style> </TextBox> <TextBox Width="3.6cm" Height="0.4cm" Left="18cm" Top="1.722cm" Value="= Parameters.endDateTime.Value" Format="{0:MM'/'dd'/'yyyy HH:mm:ss}" Name="textBox9"> <Style TextAlign="Left" VerticalAlign="Middle" /> </TextBox> <TextBox Width="2cm" Height="0.4cm" Left="16cm" Top="1.722cm" Value="End Date:" Name="textBox8"> <Style TextAlign="Left" VerticalAlign="Middle"> <Font Bold="True" /> </Style> </TextBox> </Items> </PageHeaderSection> <DetailSection Height="1.2cm" Name="detailSection1"> <Style Visible="True" /> <Items> <Table DataSourceName="pr_AdjustmentManager_LoadPiecesSummary " Width="28.565cm" Height="1.2cm" Left="0cm" Top="0cm" RowHeadersPrintOnEveryPage="True" ColumnHeadersPrintOnEveryPage="True" Name="piecesTable" StyleName="Normal.TableNormal"> <ColumnGroups> <TableGroup Name="actionOrdinal"> <ReportItem> <TextBox Width="0.859cm" Height="0.7cm" Left="0cm" Top="0cm" Value="Seq" Name="numberSequenceColumn" StyleName="BlueOpal.TableHeader"> <Style BackgroundColor="224, 224, 224" Color="Black" TextAlign="Center"> <BorderColor Default="DimGray" /> </Style> </TextBox> </ReportItem> </TableGroup> <TableGroup Name="group"> <ReportItem> <TextBox Width="1.972cm" Height="0.7cm" Left="0cm" Top="0in" Value="Order Num" Name="textBox22" StyleName="BlueOpal.TableHeader"> <Style BackgroundColor="224, 224, 224" Color="Black" TextAlign="Center"> <BorderColor Default="DimGray" /> </Style> </TextBox> </ReportItem> </TableGroup> <TableGroup Name="group1"> <ReportItem> <TextBox Width="4.576cm" Height="0.7cm" Left="0cm" Top="0in" Value="Piece Num" Name="textBox26" StyleName="BlueOpal.TableHeader"> <Style BackgroundColor="224, 224, 224" Color="Black" TextAlign="Center"> <BorderColor Default="DimGray" /> </Style> </TextBox> </ReportItem> </TableGroup> <TableGroup Name="group8"> <ReportItem> <TextBox Width="1.248cm" Height="0.7cm" Left="0in" Top="0in" Value="Wet Scale2" Name="textBox15" StyleName="BlueOpal.TableHeader"> <Style BackgroundColor="224, 224, 224" Color="Black"> <BorderColor Default="DimGray" /> </Style> </TextBox> </ReportItem> </TableGroup> <TableGroup Name="weightTarget"> <ReportItem> <TextBox Width="1.53cm" Height="0.7cm" Left="0in" Top="0in" Value="Wet Uptake Piece" Name="textBox6" StyleName="BlueOpal.TableHeader"> <Style BackgroundColor="224, 224, 224" Color="Black" TextAlign="Left" VerticalAlign="Middle"> <Font Name="Arial Unicode MS" Size="10pt" Bold="False" /> <BorderStyle Default="Solid" Bottom="Solid" Right="Solid" /> <BorderColor Default="DimGray" Bottom="DimGray" Right="DimGray" /> </Style> </TextBox> </ReportItem> </TableGroup> <TableGroup Name="group9"> <ReportItem> <TextBox Width="1.306cm" Height="0.7cm" Left="0in" Top="0in" Value="%Wet Update Nom" Name="textBox27" StyleName="BlueOpal.TableHeader"> <Style BackgroundColor="224, 224, 224" Color="Black" TextAlign="Left" VerticalAlign="Middle"> <Font Name="Arial Unicode MS" Size="10pt" Bold="False" /> <BorderStyle Default="Solid" Bottom="Solid" Right="Solid" /> <BorderColor Default="DimGray" Bottom="DimGray" Right="DimGray" /> </Style> </TextBox> </ReportItem> </TableGroup> <TableGroup Name="group28"> <ReportItem> <TextBox Width="2.259cm" Height="0.7cm" Left="0in" Top="0in" Value="Start Weight Before Adjustment" Name="textBox4" StyleName="BlueOpal.TableHeader"> <Style BackgroundColor="224, 224, 224" Color="Black" TextAlign="Left" VerticalAlign="Middle"> <Font Name="Arial Unicode MS" Size="10pt" Bold="False" /> <BorderStyle Default="Solid" Bottom="Solid" Right="Solid" /> <BorderColor Default="DimGray" Bottom="DimGray" Right="DimGray" /> </Style> </TextBox> </ReportItem> </TableGroup> <TableGroup Name="group4"> <ReportItem> <TextBox Width="0.894in" Height="0.7cm" Left="0in" Top="0in" Value="Amount WC Remove/Add" Name="textBox7" StyleName="BlueOpal.TableHeader"> <Style BackgroundColor="224, 224, 224" VerticalAlign="Middle" LineWidth="1pt"> <Font Size="10pt" Bold="False" /> <BorderStyle Default="Solid" /> <BorderColor Default="DimGray" /> <BorderWidth Default="1px" /> </Style> </TextBox> </ReportItem> </TableGroup> <TableGroup Name="group2"> <ReportItem> <TextBox Width="0.773in" Height="0.7cm" Left="0in" Top="0in" Value="Final Weight After Adjustment" Name="textBox17" StyleName="BlueOpal.TableHeader"> <Style BackgroundColor="224, 224, 224" VerticalAlign="Middle" LineWidth="1pt"> <Font Size="10pt" Bold="False" /> <BorderStyle Default="Solid" /> <BorderColor Default="DimGray" /> <BorderWidth Default="1px" /> </Style> </TextBox> </ReportItem> </TableGroup> <TableGroup Name="group5"> <ReportItem> <TextBox Width="0.764in" Height="0.7cm" Left="0in" Top="0in" Value="Wet Uptake After Adjustment" Name="textBox19" StyleName="BlueOpal.TableHeader"> <Style BackgroundColor="224, 224, 224" VerticalAlign="Middle" LineWidth="1pt"> <Font Size="10pt" Bold="False" /> <BorderStyle Default="Solid" /> <BorderColor Default="DimGray" /> <BorderWidth Default="1px" /> </Style> </TextBox> </ReportItem> </TableGroup> <TableGroup Name="group7"> <ReportItem> <TextBox Width="0.768in" Height="0.7cm" Left="0in" Top="0in" Value="%Wet Uptake After Adjustment" Name="textBox21" StyleName="BlueOpal.TableHeader"> <Style BackgroundColor="224, 224, 224" VerticalAlign="Middle" LineWidth="1pt"> <Font Size="10pt" Bold="False" /> <BorderStyle Default="Solid" /> <BorderColor Default="DimGray" /> <BorderWidth Default="1px" /> </Style> </TextBox> </ReportItem> </TableGroup> <TableGroup Name="group11"> <ReportItem> <TextBox Width="0.584in" Height="0.7cm" Left="0in" Top="0in" Value="Piece Status" Name="textBox25" StyleName="BlueOpal.TableHeader"> <Style BackgroundColor="224, 224, 224" VerticalAlign="Middle"> <Font Size="10pt" /> <BorderStyle Default="Solid" /> <BorderColor Default="DimGray" /> <BorderWidth Default="1px" /> </Style> </TextBox> </ReportItem> </TableGroup> <TableGroup Name="group10"> <ReportItem> <TextBox Width="0.573in" Height="0.7cm" Left="0in" Top="0in" Value="Product Name" Name="textBox20" StyleName="BlueOpal.TableHeader"> <Style BackgroundColor="224, 224, 224" VerticalAlign="Middle"> <Font Size="10pt" /> <BorderStyle Default="Solid" /> <BorderColor Default="DimGray" /> <BorderWidth Default="1px" /> </Style> </TextBox> </ReportItem> </TableGroup> <TableGroup Name="group12"> <ReportItem> <TextBox Width="0.708in" Height="0.7cm" Left="0in" Top="0in" Value="Piece Datetime" Name="textBox23" StyleName="BlueOpal.TableHeader"> <Style BackgroundColor="224, 224, 224" VerticalAlign="Middle"> <Font Size="10pt" /> <BorderStyle Default="Solid" /> <BorderColor Default="DimGray" /> <BorderWidth Default="1px" /> </Style> </TextBox> </ReportItem> </TableGroup> <TableGroup Name="group13"> <ReportItem> <TextBox Width="0.769in" Height="0.7cm" Left="0in" Top="0in" Value="Adjusted Timestamp" Name="textBox34" StyleName="BlueOpal.TableHeader"> <Style BackgroundColor="224, 224, 224" TextAlign="Left" VerticalAlign="Middle"> <Font Size="10pt" /> <BorderStyle Default="Solid" /> <BorderColor Default="DimGray" /> <BorderWidth Default="1px" /> </Style> </TextBox> </ReportItem> </TableGroup> </ColumnGroups> <Body> <Cells> <TableCell RowIndex="0" ColumnIndex="0" RowSpan="1" ColumnSpan="1"> <ReportItem> <TextBox Width="0.859cm" Height="0.5cm" Left="0cm" Top="0cm" Value="= Fields.SerialNumber" Format="" Name="textBox3" StyleName="BlueOpal.TableBody"> <Style Color="Black" TextAlign="Center" VerticalAlign="Middle"> <BorderColor Default="DimGray" /> </Style> </TextBox> </ReportItem> </TableCell> <TableCell RowIndex="0" ColumnIndex="1" RowSpan="1" ColumnSpan="1"> <ReportItem> <TextBox Width="1.972cm" Height="0.5cm" Left="0cm" Top="0cm" Value="= Fields.OrderNumber" Format="" Name="textBox2" StyleName="BlueOpal.TableBody"> <Style Color="Black" TextAlign="Center" VerticalAlign="Middle"> <BorderColor Default="DimGray" /> </Style> </TextBox> </ReportItem> </TableCell> <TableCell RowIndex="0" ColumnIndex="2" RowSpan="1" ColumnSpan="1"> <ReportItem> <TextBox Width="4.576cm" Height="0.5cm" Left="0cm" Top="0cm" Value="= Fields.PieceNum" Format="" Name="textBox1" StyleName="BlueOpal.TableBody"> <Style Color="Black" TextAlign="Center" VerticalAlign="Middle"> <BorderColor Default="DimGray" /> </Style> </TextBox> </ReportItem> </TableCell> <TableCell RowIndex="0" ColumnIndex="3" RowSpan="1" ColumnSpan="1"> <ReportItem> <TextBox Width="1.248cm" Height="0.5cm" Left="0cm" Top="0cm" Value="= Fields.WetScale2" Format="" Name="textBox28" StyleName="BlueOpal.TableBody"> <Style Color="Black" TextAlign="Center" VerticalAlign="Middle"> <BorderColor Default="DimGray" /> </Style> </TextBox> </ReportItem> </TableCell> <TableCell RowIndex="0" ColumnIndex="4" RowSpan="1" ColumnSpan="1"> <ReportItem> <TextBox Width="1.53cm" Height="0.5cm" Left="0cm" Top="0cm" Value="= Fields.WetUptakePiece" Format="" Name="textBox12" StyleName="BlueOpal.TableBody"> <Style Color="Black" TextAlign="Center" VerticalAlign="Middle"> <BorderColor Default="DimGray" /> </Style> </TextBox> </ReportItem> </TableCell> <TableCell RowIndex="0" ColumnIndex="5" RowSpan="1" ColumnSpan="1"> <ReportItem> <TextBox Width="1.306cm" Height="0.5cm" Left="0cm" Top="0cm" Value="= Fields.WetUptakePercent" Format="" Name="textBox5" StyleName="BlueOpal.TableBody"> <Style Color="Black" TextAlign="Center" VerticalAlign="Middle"> <BorderColor Default="DimGray" /> </Style> </TextBox> </ReportItem> </TableCell> <TableCell RowIndex="0" ColumnIndex="6" RowSpan="1" ColumnSpan="1"> <ReportItem> <TextBox Width="2.259cm" Height="0.5cm" Left="0cm" Top="0cm" Value="= Fields.WetScale2BeforeAdjustment" Format="" Name="textBox29" StyleName="BlueOpal.TableBody"> <Style Color="Black" TextAlign="Center" VerticalAlign="Middle"> <BorderColor Default="DimGray" /> </Style> </TextBox> </ReportItem> </TableCell> <TableCell RowIndex="0" ColumnIndex="7" RowSpan="1" ColumnSpan="1"> <ReportItem> <TextBox Width="0.894in" Height="0.5cm" Left="0cm" Top="0cm" Value="= Fields.AmountWCRemoveAdd" Format="" Name="textBox30" StyleName="BlueOpal.TableBody"> <Style Color="Black" TextAlign="Center" VerticalAlign="Middle"> <BorderColor Default="DimGray" /> </Style> </TextBox> </ReportItem> </TableCell> <TableCell RowIndex="0" ColumnIndex="8" RowSpan="1" ColumnSpan="1"> <ReportItem> <TextBox Width="0.773in" Height="0.5cm" Left="0cm" Top="0cm" Value="= Fields.WetScale2AfterRework" Format="" Name="textBox13" StyleName="BlueOpal.TableBody"> <Style Color="Black" TextAlign="Center" VerticalAlign="Middle"> <BorderColor Default="DimGray" /> </Style> </TextBox> </ReportItem> </TableCell> <TableCell RowIndex="0" ColumnIndex="9" RowSpan="1" ColumnSpan="1"> <ReportItem> <TextBox Width="0.764in" Height="0.5cm" Left="0cm" Top="0cm" Value="= Fields.WetUptakeAfterRework" Format="" Name="textBox14" StyleName="BlueOpal.TableBody"> <Style Color="Black" TextAlign="Center" VerticalAlign="Middle"> <BorderColor Default="DimGray" /> </Style> </TextBox> </ReportItem> </TableCell> <TableCell RowIndex="0" ColumnIndex="10" RowSpan="1" ColumnSpan="1"> <ReportItem> <TextBox Width="0.768in" Height="0.5cm" Left="0cm" Top="0cm" Value="= Fields.WetUptakePercentAfterRework" Format="" Name="textBox16" StyleName="BlueOpal.TableBody"> <Style Color="Black" TextAlign="Center" VerticalAlign="Middle"> <BorderColor Default="DimGray" /> </Style> </TextBox> </ReportItem> </TableCell> <TableCell RowIndex="0" ColumnIndex="11" RowSpan="1" ColumnSpan="1"> <ReportItem> <TextBox Width="0.584in" Height="0.5cm" Left="0cm" Top="0cm" Value="= Fields.PieceStatus" Format="" Name="textBox18" StyleName="BlueOpal.TableBody"> <Style Color="Black" TextAlign="Center" VerticalAlign="Middle"> <BorderColor Default="DimGray" /> </Style> </TextBox> </ReportItem> </TableCell> <TableCell RowIndex="0" ColumnIndex="12" RowSpan="1" ColumnSpan="1"> <ReportItem> <TextBox Width="0.573in" Height="0.5cm" Left="0cm" Top="0cm" Value="= Fields.ProductName" Format="" Name="textBox24" StyleName="BlueOpal.TableBody"> <Style Color="Black" TextAlign="Center" VerticalAlign="Middle"> <BorderColor Default="DimGray" /> </Style> </TextBox> </ReportItem> </TableCell> <TableCell RowIndex="0" ColumnIndex="13" RowSpan="1" ColumnSpan="1"> <ReportItem> <TextBox Width="0.708in" Height="0.5cm" Left="0in" Top="0in" Value="= Fields.PieceDateTime" Format="{0:MM'/'dd'/'yyyy HH:mm:ss}" Name="textBox32" StyleName="BlueOpal.TableBody"> <Style Color="Black" TextAlign="Center" VerticalAlign="Middle"> <BorderColor Default="DimGray" /> </Style> </TextBox> </ReportItem> </TableCell> <TableCell RowIndex="0" ColumnIndex="14" RowSpan="1" ColumnSpan="1"> <ReportItem> <TextBox Width="0.769in" Height="0.5cm" Left="0in" Top="0in" Value="= Fields.UpdateDateTime" Format="{0:MM'/'dd'/'yyyy HH:mm:ss}" Name="textBox31" StyleName="BlueOpal.TableBody"> <Style Color="Black" TextAlign="Center" VerticalAlign="Middle"> <BorderColor Default="DimGray" /> </Style> </TextBox> </ReportItem> </TableCell> </Cells> <Columns> <Column Width="0.859cm" /> <Column Width="1.972cm" /> <Column Width="4.576cm" /> <Column Width="1.248cm" /> <Column Width="1.53cm" /> <Column Width="1.306cm" /> <Column Width="2.259cm" /> <Column Width="0.894in" /> <Column Width="0.773in" /> <Column Width="0.764in" /> <Column Width="0.768in" /> <Column Width="0.584in" /> <Column Width="0.573in" /> <Column Width="0.708in" /> <Column Width="0.769in" /> </Columns> <Rows> <Row Height="0.5cm" /> </Rows> </Body> <Corner /> <Style> <BorderColor Default="DimGray" /> </Style> <RowGroups> <TableGroup Name="detail"> <Groupings> <Grouping /> </Groupings> </TableGroup> </RowGroups> </Table> </Items> </DetailSection> </Items> <PageSettings PaperKind="A4" Landscape="True" ContinuousPaper="False"> <Margins> <MarginsU Left="0.5cm" Right="0.5cm" Top="1cm" Bottom="1cm" /> </Margins> </PageSettings> <StyleSheet> <StyleRule> <Style> <Padding Left="2pt" Right="2pt" /> </Style> <Selectors> <TypeSelector Type="TextItemBase" /> <TypeSelector Type="HtmlTextBox" /> </Selectors> </StyleRule> <StyleRule> <Style Color="Black"> <Font Name="Arial Unicode MS" Size="9pt" /> <BorderStyle Default="Solid" /> <BorderColor Default="Black" /> <BorderWidth Default="1px" /> </Style> <Selectors> <StyleSelector Type="Table" StyleName="Normal.TableNormal" /> </Selectors> </StyleRule> <StyleRule> <Style> <Font Name="Arial Unicode MS" Size="9pt" /> <BorderStyle Default="Solid" /> <BorderColor Default="Black" /> <BorderWidth Default="1px" /> </Style> <Selectors> <DescendantSelector> <Selectors> <TypeSelector Type="Table" /> <StyleSelector Type="ReportItem" StyleName="Normal.TableBody" /> </Selectors> </DescendantSelector> </Selectors> </StyleRule> <StyleRule> <Style VerticalAlign="Middle"> <Font Name="Arial Unicode MS" Size="10pt" /> <BorderStyle Default="Solid" /> <BorderColor Default="Black" /> <BorderWidth Default="1px" /> </Style> <Selectors> <DescendantSelector> <Selectors> <TypeSelector Type="Table" /> <StyleSelector Type="ReportItem" StyleName="Normal.TableHeader" /> </Selectors> </DescendantSelector> </Selectors> </StyleRule> <StyleRule> <Style Color="0, 63, 89"> <Font Name="Arial Unicode MS" Size="9pt" /> <BorderStyle Default="Solid" /> <BorderColor Default="187, 220, 235" /> <BorderWidth Default="1px" /> </Style> <Selectors> <StyleSelector Type="Table" StyleName="BlueOpal.TableNormal" /> </Selectors> </StyleRule> <StyleRule> <Style Color="0, 63, 89"> <Font Name="Arial Unicode MS" Size="9pt" /> <BorderStyle Default="Solid" /> <BorderColor Default="187, 220, 235" /> <BorderWidth Default="1px" /> </Style> <Selectors> <DescendantSelector> <Selectors> <TypeSelector Type="Table" /> <StyleSelector Type="ReportItem" StyleName="BlueOpal.TableBody" /> </Selectors> </DescendantSelector> </Selectors> </StyleRule> <StyleRule> <Style BackgroundColor="233, 244, 249" Color="0, 63, 89" VerticalAlign="Middle"> <Font Name="Arial Unicode MS" Size="10pt" /> <BorderStyle Default="Solid" /> <BorderColor Default="187, 220, 235" /> <BorderWidth Default="1px" /> </Style> <Selectors> <DescendantSelector> <Selectors> <TypeSelector Type="Table" /> <StyleSelector Type="ReportItem" StyleName="BlueOpal.TableHeader" /> </Selectors> </DescendantSelector> </Selectors> </StyleRule> </StyleSheet> <ReportParameters> <ReportParameter Name="startDateTime" Type="DateTime"> <Value> <String>2024-04-05 13:11:34</String> </Value> </ReportParameter> <ReportParameter Name="cultureId"> <Value> <String>en-US</String> </Value> </ReportParameter> <ReportParameter Name="endDateTime" Type="DateTime"> <Value> <String>2024-04-07 13:11:34</String> </Value> </ReportParameter> <ReportParameter Name="PFDSConnectionString"> <Value> <String></String> </Value> </ReportParameter> <ReportParameter Name="line" /> </ReportParameters> <Bindings> <Binding Path="Culture" Expression="= Parameters.cultureId.Value" /> </Bindings> </Report>