twcadmin
asked on
Reporting Services - GroupExpression expression used in table ‘table4’ returned a data type that is not valid
I have a report in reporting services that returns the following error
"An error has occurred during report processing.
The GroupExpression expression used in table ‘table4’ returned a data type that is not valid."
In the old version of reporting services this was never a probllem but now i know data types are very important. What do I have to do to correct this?
Below you can find the report table itself of which there are standard varchar and int datatypes. One field named BenSign is an Image field
"An error has occurred during report processing.
The GroupExpression expression used in table ‘table4’ returned a data type that is not valid."
In the old version of reporting services this was never a probllem but now i know data types are very important. What do I have to do to correct this?
Below you can find the report table itself of which there are standard varchar and int datatypes. One field named BenSign is an Image field
<Table Name="table4">
<Height>1.5in</Height>
<Style />
<Details>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="BonType">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Tahoma</FontFamily>
<BorderStyle>
<Bottom>None</Bottom>
<Top>None</Top>
<Right>=iif(Fields!BenType.Value="Incentive","Solid","None")</Right>
<Left>=iif(Fields!BenType.Value="Incentive","Solid","None")</Left>
</BorderStyle>
<FontSize>9pt</FontSize>
<FontStyle>Italic</FontStyle>
<TextAlign>Right</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>7</ZIndex>
<rd:DefaultName>BonType</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!BonType.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="BonNum">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Tahoma</FontFamily>
<BorderStyle>
<Bottom>None</Bottom>
<Top>None</Top>
<Right>=iif(Fields!BenType.Value="Incentive","Solid","None")</Right>
<Left>=iif(Fields!BenType.Value="Incentive","Solid","None")</Left>
</BorderStyle>
<FontSize>9pt</FontSize>
<FontStyle>Italic</FontStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>6</ZIndex>
<rd:DefaultName>BonNum</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!BonNum.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="BonValue">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<Format>C</Format>
<FontFamily>Tahoma</FontFamily>
<BorderStyle>
<Bottom>None</Bottom>
<Top>None</Top>
<Right>=iif(Fields!BenType.Value="Incentive","Solid","None")</Right>
<Left>=iif(Fields!BenType.Value="Incentive","Solid","None")</Left>
</BorderStyle>
<FontSize>9pt</FontSize>
<FontStyle>Italic</FontStyle>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>5</ZIndex>
<rd:DefaultName>BonValue</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!BonValue.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox27">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BorderStyle>
<Bottom>None</Bottom>
<Top>None</Top>
<Right>=iif(Fields!BenType.Value="Incentive","Solid","None")</Right>
<Left>=iif(Fields!BenType.Value="Incentive","Solid","None")</Left>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>4</ZIndex>
<rd:DefaultName>textbox27</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox16">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BorderStyle>
<Bottom>None</Bottom>
<Top>None</Top>
<Right>=iif(Fields!BenType.Value="Incentive","Solid","None")</Right>
<Left>=iif(Fields!BenType.Value="Incentive","Solid","None")</Left>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<rd:DefaultName>textbox16</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox13">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Tahoma</FontFamily>
<BorderStyle>
<Bottom>None</Bottom>
<Top>None</Top>
<Right>=iif(Fields!BenType.Value="Incentive","Solid","None")</Right>
<Left>=iif(Fields!BenType.Value="Incentive","Solid","None")</Left>
</BorderStyle>
<FontSize>9pt</FontSize>
<FontStyle>Italic</FontStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>textbox13</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox28">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Tahoma</FontFamily>
<BorderStyle>
<Bottom>None</Bottom>
<Top>None</Top>
<Right>=iif(Fields!BenType.Value="Incentive","Solid","None")</Right>
<Left>=iif(Fields!BenType.Value="Incentive","Solid","None")</Left>
</BorderStyle>
<FontSize>9pt</FontSize>
<FontStyle>Italic</FontStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<rd:DefaultName>textbox28</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox17">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Tahoma</FontFamily>
<BorderStyle>
<Bottom>None</Bottom>
<Top>None</Top>
<Right>=iif(Fields!BenType.Value="Incentive","Solid","None")</Right>
<Left>=iif(Fields!BenType.Value="Incentive","Solid","None")</Left>
</BorderStyle>
<FontSize>9pt</FontSize>
<FontStyle>Italic</FontStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>textbox17</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Visibility>
<Hidden>=iif(Fields!BonType.Value="",True,False)</Hidden>
</Visibility>
</TableRow>
</TableRows>
</Details>
<DataSetName>qryMain</DataSetName>
<TableGroups>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ColSpan>8</ColSpan>
<ReportItems>
<Textbox Name="CCoach">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Tahoma</FontFamily>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>Solid</Top>
<Right>Solid</Right>
<Left>Solid</Left>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
</Style>
<ZIndex>32</ZIndex>
<rd:DefaultName>CCoach</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!CCoach.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox7">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Tahoma</FontFamily>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>Solid</Top>
<Right>Solid</Right>
<Left>Solid</Left>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>600</FontWeight>
</Style>
<ZIndex>31</ZIndex>
<rd:DefaultName>textbox7</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Benefit Type</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox8">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Tahoma</FontFamily>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>Solid</Top>
<Right>Solid</Right>
<Left>Solid</Left>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>600</FontWeight>
</Style>
<ZIndex>30</ZIndex>
<rd:DefaultName>textbox8</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Benefit Num</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox20">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Tahoma</FontFamily>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>Solid</Top>
<Right>Solid</Right>
<Left>Solid</Left>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>600</FontWeight>
</Style>
<ZIndex>29</ZIndex>
<rd:DefaultName>textbox20</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox9">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Tahoma</FontFamily>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>Solid</Top>
<Right>Solid</Right>
<Left>Solid</Left>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>600</FontWeight>
</Style>
<ZIndex>28</ZIndex>
<rd:DefaultName>textbox9</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Given On</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox12">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Tahoma</FontFamily>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>Solid</Top>
<Right>Solid</Right>
<Left>Solid</Left>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>600</FontWeight>
</Style>
<ZIndex>27</ZIndex>
<rd:DefaultName>textbox12</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>SSN</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox11">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Tahoma</FontFamily>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>Solid</Top>
<Right>Solid</Right>
<Left>Solid</Left>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>600</FontWeight>
</Style>
<ZIndex>26</ZIndex>
<rd:DefaultName>textbox11</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Given To</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox26">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Tahoma</FontFamily>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>Solid</Top>
<Right>Solid</Right>
<Left>Solid</Left>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>600</FontWeight>
</Style>
<ZIndex>25</ZIndex>
<rd:DefaultName>textbox26</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Pay Date</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox15">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Tahoma</FontFamily>
<BorderStyle>
<Bottom>Solid</Bottom>
<Top>Solid</Top>
<Right>Solid</Right>
<Left>Solid</Left>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
<FontWeight>600</FontWeight>
</Style>
<ZIndex>24</ZIndex>
<rd:DefaultName>textbox15</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Signature</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Grouping Name="table4_Group1">
<GroupExpressions>
<GroupExpression>=Fields!CCoach.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Footer>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BorderStyle>
<Top>Solid</Top>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>15</ZIndex>
<rd:DefaultName>textbox1</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BorderStyle>
<Top>Solid</Top>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>14</ZIndex>
<rd:DefaultName>textbox2</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox3">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BorderStyle>
<Top>Solid</Top>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>13</ZIndex>
<rd:DefaultName>textbox3</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox4">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BorderStyle>
<Top>Solid</Top>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>12</ZIndex>
<rd:DefaultName>textbox4</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox18">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BorderStyle>
<Top>Solid</Top>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>11</ZIndex>
<rd:DefaultName>textbox18</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox5">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BorderStyle>
<Top>Solid</Top>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>10</ZIndex>
<rd:DefaultName>textbox5</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox6">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BorderStyle>
<Top>Solid</Top>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>9</ZIndex>
<rd:DefaultName>textbox6</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox10">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BorderStyle>
<Top>Solid</Top>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>8</ZIndex>
<rd:DefaultName>textbox10</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Footer>
</TableGroup>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<Height>0.5in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="BenType">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Tahoma</FontFamily>
<BorderStyle>
<Bottom>=iif(Fields!BenType.Value="Incentive","None","Solid")</Bottom>
<Top>Solid</Top>
<Right>Solid</Right>
<Left>Solid</Left>
</BorderStyle>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>23</ZIndex>
<rd:DefaultName>BenType</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!BenType.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="BenNum">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Tahoma</FontFamily>
<BorderStyle>
<Bottom>=iif(Fields!BenType.Value="Incentive","None","Solid")</Bottom>
<Top>Solid</Top>
<Right>Solid</Right>
<Left>Solid</Left>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>22</ZIndex>
<rd:DefaultName>BenNum</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!BenNum.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox21">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Tahoma</FontFamily>
<BorderStyle>
<Bottom>=iif(Fields!BenType.Value="Incentive","None","Solid")</Bottom>
<Top>Solid</Top>
<Right>Solid</Right>
<Left>Solid</Left>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>21</ZIndex>
<rd:DefaultName>textbox21</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=IIF( Fields!BenType.Value="Transpass","$" & Fields!BonValue.Value,"")</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="GivenOn">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<Format>d</Format>
<FontFamily>Tahoma</FontFamily>
<BorderStyle>
<Bottom>=iif(Fields!BenType.Value="Incentive","None","Solid")</Bottom>
<Top>Solid</Top>
<Right>Solid</Right>
<Left>Solid</Left>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>20</ZIndex>
<rd:DefaultName>GivenOn</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=First(Fields!GivenOn.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="SSN">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<Format>d</Format>
<FontFamily>Tahoma</FontFamily>
<BorderStyle>
<Bottom>=iif(Fields!BenType.Value="Incentive","None","Solid")</Bottom>
<Top>Solid</Top>
<Right>Solid</Right>
<Left>Solid</Left>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>19</ZIndex>
<rd:DefaultName>SSN</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=IIF( Parameters!FullSSN.Value,First(Fields!SSN.Value),right(First(Fields!SSN.Value),4))</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="GivenTo">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<FontFamily>Tahoma</FontFamily>
<BorderStyle>
<Bottom>=iif(Fields!BenType.Value="Incentive","None","Solid")</Bottom>
<Top>Solid</Top>
<Right>Solid</Right>
<Left>Solid</Left>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>18</ZIndex>
<rd:DefaultName>GivenTo</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!GivenTo.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox33">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<Format>d</Format>
<FontFamily>Tahoma</FontFamily>
<BorderStyle>
<Bottom>=iif(Fields!BenType.Value="Incentive","None","Solid")</Bottom>
<Top>Solid</Top>
<Right>Solid</Right>
<Left>Solid</Left>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>17</ZIndex>
<CanGrow>true</CanGrow>
<Value>=Fields!PayDate.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Image Name="image1">
<ZIndex>16</ZIndex>
<MIMEType>image/bmp</MIMEType>
<Source>Database</Source>
<Style>
<BorderStyle>
<Bottom>=iif(Fields!BenType.Value="Incentive","None","Solid")</Bottom>
<Top>Solid</Top>
<Right>Solid</Right>
<Left>Solid</Left>
</BorderStyle>
</Style>
<Value>=Fields!BenSign.Value</Value>
<Sizing>Fit</Sizing>
</Image>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Grouping Name="table4_Group2">
<GroupExpressions>
<GroupExpression>=Fields!BenType.Value</GroupExpression>
<GroupExpression>=Fields!BenNum.Value</GroupExpression>
<GroupExpression>=Fields!GivenTo.Value</GroupExpression>
<GroupExpression>=Fields!BenSign.Value</GroupExpression>
<GroupExpression>=Fields!PayDate.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</TableGroup>
</TableGroups>
<Left>0.125in</Left>
<TableColumns>
<TableColumn>
<Width>1in</Width>
</TableColumn>
<TableColumn>
<Width>0.875in</Width>
</TableColumn>
<TableColumn>
<Width>0.625in</Width>
</TableColumn>
<TableColumn>
<Width>0.875in</Width>
</TableColumn>
<TableColumn>
<Width>0.75in</Width>
</TableColumn>
<TableColumn>
<Width>1.375in</Width>
</TableColumn>
<TableColumn>
<Width>0.875in</Width>
</TableColumn>
<TableColumn>
<Width>1.91667in</Width>
</TableColumn>
</TableColumns>
</Table>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you need more, then you need to drill down to a pacific detail data by using more groups in the table.