Solved

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

Posted on 2010-08-25
2
2,297 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
  • 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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

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…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This video discusses moving either the default database or any database to a new volume.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

744 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now