Solved

Reporting Services - GroupExpression expression used in table ‘table4’ returned a data type that is not valid

Posted on 2010-08-25
2
2,711 Views
Last Modified: 2012-05-10
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
<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","$" &amp; 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>

Open in new window

0
Comment
Question by:twcadmin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 27

Accepted Solution

by:
planocz earned 500 total points
ID: 33527667
In your groupExpressions you have too many expressions. A group is based on one expression per group; this seems to work the best.
If you need more, then you need to drill down to a pacific detail data by using more groups in the table.
0
 
LVL 27

Expert Comment

by:planocz
ID: 33527668
In your groupExpressions you have too many expressions. A group is based on one expression per group; this seems to work the best.
If you need more, then you need to drill down to a pacific detail data by using more groups in the table.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

631 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question