none
VS 2019 does not allow headers(titles) on a report to scroll RRS feed

All replies

  • Hi CCCOttawa,

    Welcome to the MSDN forum.

    Which type of project did you create? Did you create a report service project? Also, l think you just want to find another solution to use the headers on the report to scroll if the VS2019. If l misunderstand your statement, please correct me and provide more detail information and steps.

    Our forum is about the use of VS IDE and editor. If your issue is unrelated to our forum, we can redirect your issue to the write forum for better help.

    l am looking forward to hearing from you.

    Best Regards,

    Perry


    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Thursday, August 8, 2019 7:16 AM
  • Hello Perry,

    I am creating a reporting services project \ report and users want to see titles when then scroll down the report but the VS 2019 on how to , it does not work.

    regards,

    Brigitte 

    Thursday, August 8, 2019 1:53 PM
  • Hi CCCOttawa,

    Thanks for your feedback.

    Since you are asking a question about the reporting service project, we have moved this to reporting service forum so that you could get better support.

    Thanks for your understanding.

    Best Regards,

    Perry


    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Friday, August 9, 2019 1:53 AM
  • Hi Brigitte,

    Are you trying to have fixed table headers when scrolling ?

    If so, we could try to set fixed data for the table. You could refer to this simple tutorial in MS DOC here:

    Keep Headers Visible When Scrolling Through a Report (Report Builder and SSRS)\

    Regards,

    Lukas


    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, August 9, 2019 6:36 AM
  • Hello Lukas,

    Thank you for that link for scrolling but I have already tried that and it is not working.  I also have the fixed data set to True and still not working.

    Brigitte

    Friday, August 9, 2019 12:54 PM
  • Hi Brigitte,

    So, is the feature described in the article is the feature you are desiring?

    This should work for SSRS design as we've tested it.

    If it is not working for you, could you share us your setting screenshot, or your rdl file, so we could do some debug?

    Or, you could go through the tutorial again with more simple test, to check how things going on?

    Regards,

    Lukas 


    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, August 12, 2019 2:26 AM
  • <report mustunderstand="df" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition" xmlns:cl="http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition" xmlns:df="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition/defaultfontfamily" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"><df:defaultfontfamily>Segoe UI</df:defaultfontfamily> <autorefresh>0</autorefresh> <datasets><dataset name="dst_ptr_WF"><shareddataset><shareddatasetreference>dst_WF</shareddatasetreference> </shareddataset> <fields><field name="firstname"><datafield>firstname</datafield> <rd:typename>System.String</rd:typename> </field> <field name="lastname"><datafield>lastname</datafield> <rd:typename>System.String</rd:typename> </field> <field name="ee_id"><datafield>ee_id</datafield> <rd:typename>System.String</rd:typename> </field> <field name="Description"><datafield>Description</datafield> <rd:typename>System.String</rd:typename> </field> <field name="AcctgCode"><datafield>AcctgCode</datafield> <rd:typename>System.String</rd:typename> </field> <field name="PosnStatus"><datafield>PosnStatus</datafield> <rd:typename>System.String</rd:typename> </field> </fields> </dataset> </datasets> <reportsections><reportsection><reportitems><tablix name="Tablix1"><tablixbody><tablixcolumns><tablixcolumn><width>2.5cm</width> </tablixcolumn> <tablixcolumn><width>4.21979cm</width> </tablixcolumn> <tablixcolumn><width>2.5cm</width> </tablixcolumn> <tablixcolumn><width>7.20958cm</width> </tablixcolumn> <tablixcolumn><width>2.5cm</width> </tablixcolumn> <tablixcolumn><width>2.5cm</width> </tablixcolumn> </tablixcolumns> <tablixrows><tablixrow><height>0.6cm</height> <tablixcells><tablixcell><cellcontents><textbox name="FirstName"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value>First Name</value> <style><FontWeight>Bold</FontWeight> <TextDecoration>Underline</TextDecoration> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="LastName"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value>Last Name</value> <style><FontWeight>Bold</FontWeight> <TextDecoration>Underline</TextDecoration> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="Textbox5"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value>Corps #</value> <style><FontWeight>Bold</FontWeight> <TextDecoration>Underline</TextDecoration> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox5</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="Textbox7"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value>Description</value> <style><FontFamily>Arial</FontFamily> <FontWeight>Bold</FontWeight> <TextDecoration>Underline</TextDecoration> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox7</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="Textbox9"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value>Section</value> <style><FontFamily>Arial</FontFamily> <FontWeight>Bold</FontWeight> <TextDecoration>Underline</TextDecoration> </style> </textrun> </textruns> <style></style></paragraph> <paragraph><textruns><textrun><value></value><style><FontFamily>Arial</FontFamily> <FontWeight>Bold</FontWeight> <TextDecoration>Underline</TextDecoration> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox9</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="Textbox11"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value>Posn Status</value> <style><FontFamily>Arial</FontFamily> <FontWeight>Bold</FontWeight> <TextDecoration>Underline</TextDecoration> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox11</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> </tablixcells> </tablixrow> <tablixrow><height>0.6cm</height> <tablixcells><tablixcell><cellcontents><textbox name="firstname"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value>=Fields!firstname.Value</value> <style></style></textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>firstname</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="lastname"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value>=Fields!lastname.Value</value> <style></style></textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>lastname</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="ee_id"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value>=Fields!ee_id.Value</value> <style></style></textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>ee_id</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="Description"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value>=Fields!Description.Value</value> <style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Description</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="AcctgCode"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value>=Fields!AcctgCode.Value</value> <style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>AcctgCode</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="PosnStatus"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value>=Fields!PosnStatus.Value</value> <style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>PosnStatus</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> </tablixcells> </tablixrow> <tablixrow><height>0.6cm</height> <tablixcells><tablixcell><cellcontents><textbox name="Textbox135"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value></value><style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox135</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="Textbox136"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value>="Employee Count"</value> <style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox136</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <topborder><color>Black</color> </topborder> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="Textbox137"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value>=COUNTDISTINCT(Fields!ee_id.Value)</value> <style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox137</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <topborder><color>Black</color> <style>Double</style> </topborder> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="Textbox138"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value></value><style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox138</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="Textbox139"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value></value><style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox139</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="Textbox140"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value></value><style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox140</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> </tablixcells> </tablixrow> <tablixrow><height>0.6cm</height> <tablixcells><tablixcell><cellcontents><textbox name="Textbox143"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value></value><style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox143</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="Textbox144"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value></value><style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox144</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <topborder><color>Black</color> </topborder> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="Textbox145"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value></value><style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox145</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <topborder><color>Black</color> <style>Double</style> </topborder> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="Textbox146"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value></value><style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox146</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="Textbox147"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value></value><style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox147</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="Textbox148"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value></value><style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox148</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> </tablixcells> </tablixrow> <tablixrow><height>0.6cm</height> <tablixcells><tablixcell><cellcontents><textbox name="Textbox118"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value></value><style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox118</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="Textbox119"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value></value><style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox119</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="Textbox120"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value></value><style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox120</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="Textbox121"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value></value><style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox121</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="Textbox122"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value></value><style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox122</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="Textbox123"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value></value><style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox123</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> </tablixcells> </tablixrow> <tablixrow><height>0.6cm</height> <tablixcells><tablixcell><cellcontents><textbox name="Textbox125"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value></value><style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox125</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="Textbox126"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value></value><style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox126</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="Textbox57"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value>=Count(Fields!ee_id.Value)</value> <style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox57</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="Textbox128"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value></value><style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox128</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="Textbox129"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value></value><style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox129</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> <tablixcell><cellcontents><textbox name="Textbox130"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value></value><style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox130</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixcell> </tablixcells> </tablixrow> </tablixrows> </tablixbody> <tablixcolumnhierarchy><tablixmembers><tablixmember><fixeddata>true</fixeddata> <keepwithgroup>After</keepwithgroup> <repeatonnewpage>true</repeatonnewpage> </tablixmember> <tablixmember><fixeddata>true</fixeddata> <keepwithgroup>After</keepwithgroup> <repeatonnewpage>true</repeatonnewpage> </tablixmember> <tablixmember><fixeddata>true</fixeddata> <keepwithgroup>After</keepwithgroup> <repeatonnewpage>true</repeatonnewpage> <keeptogether>true</keeptogether> </tablixmember> <tablixmember><fixeddata>true</fixeddata> <keepwithgroup>After</keepwithgroup> <repeatonnewpage>true</repeatonnewpage> <keeptogether>true</keeptogether> </tablixmember> <tablixmember><fixeddata>true</fixeddata> <keepwithgroup>After</keepwithgroup> <repeatonnewpage>true</repeatonnewpage> <keeptogether>true</keeptogether> </tablixmember> <tablixmember><fixeddata>true</fixeddata> <keepwithgroup>After</keepwithgroup> <repeatonnewpage>true</repeatonnewpage> <keeptogether>true</keeptogether> </tablixmember> </tablixmembers> </tablixcolumnhierarchy> <tablixrowhierarchy><tablixmembers><tablixmember><tablixheader><size>2.5cm</size> <cellcontents><textbox name="Section"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value>Section</value> <style><FontFamily>Arial</FontFamily> <FontWeight>Bold</FontWeight> <TextDecoration>Underline</TextDecoration> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixheader> <tablixmembers><tablixmember><fixeddata>true</fixeddata> <keepwithgroup>After</keepwithgroup> <repeatonnewpage>true</repeatonnewpage> </tablixmember> </tablixmembers> <fixeddata>true</fixeddata> <keepwithgroup>After</keepwithgroup> <repeatonnewpage>true</repeatonnewpage> </tablixmember> <tablixmember><group name="AcctgCode"><groupexpressions><groupexpression>=Fields!AcctgCode.Value</groupexpression> </groupexpressions> </group> <sortexpressions><sortexpression><value>=Fields!AcctgCode.Value</value> </sortexpression> </sortexpressions> <tablixheader><size>2.5cm</size> <cellcontents><textbox name="AcctgCode1"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value>=Fields!AcctgCode.Value</value> <style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>AcctgCode1</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixheader> <tablixmembers><tablixmember><group name="Details"></group><tablixmembers><tablixmember></tablixmember></tablixmembers> </tablixmember> <tablixmember></tablixmember><tablixmember></tablixmember></tablixmembers> </tablixmember> <tablixmember><tablixheader><size>2.5cm</size> <cellcontents><textbox name="Textbox117"><cangrow>true</cangrow> <keeptogether>true</keeptogether> <paragraphs><paragraph><textruns><textrun><value>Total</value> <style><FontFamily>Arial</FontFamily> </style> </textrun> </textruns> <style></style></paragraph> </paragraphs> <rd:defaultname>Textbox117</rd:defaultname> <style><Border> <Color>LightGrey</Color> <Style>Solid</style> <paddingleft>2pt</paddingleft> <paddingright>2pt</paddingright> <paddingtop>2pt</paddingtop> <paddingbottom>2pt</paddingbottom> </textbox> </cellcontents> </tablixheader> <tablixmembers><tablixmember></tablixmember><tablixmember></tablixmember></tablixmembers> </tablixmember> </tablixmembers> </tablixrowhierarchy> <repeatrowheaders>true</repeatrowheaders> <fixedcolumnheaders>true</fixedcolumnheaders> <fixedrowheaders>true</fixedrowheaders> <keeptogether>true</keeptogether> <datasetname>dst_ptr_WF</datasetname> <top>1.24037cm</top> <left>1.10807cm</left> <height>3.6cm</height> <width>23.92937cm</width> <style><Border> <Style>None</style> <cl:componentmetadata><cl:componentid>84ac6361-3dd6-4203-bc3b-ae0276f9d74b</cl:componentid> </cl:componentmetadata> </tablix> </reportitems> <height>2.38851in</height> <style></style><width>10.24268in</width> <page><pageheight>29.7cm</pageheight> <pagewidth>21cm</pagewidth> <leftmargin>2cm</leftmargin> <rightmargin>2cm</rightmargin> <topmargin>2cm</topmargin> <bottommargin>2cm</bottommargin> <columnspacing>0.13cm</columnspacing> <style></style></page> </reportsection> </reportsections> <reportparameterslayout><gridlayoutdefinition><numberofcolumns>4</numberofcolumns> <numberofrows>2</numberofrows> </gridlayoutdefinition> </reportparameterslayout> <rd:reportunittype>Cm</rd:reportunittype> <rd:reportid>100fbf11-d9f3-4e6e-b2fc-f3438e4d62e6</rd:reportid> </report>
    Monday, August 12, 2019 2:57 PM
  • I can't view this, as there are many definition errors.

    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, August 13, 2019 2:58 AM
  • Hi,

    I've made a simple sample, you could check if your setting is different than mine.

    Open advance group -> (static) property window -> fix data True.

    See,


    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, August 13, 2019 3:12 AM
  • Tuesday, August 13, 2019 12:30 PM
  • Hello ,

    The fixed data has been applied along with the instructions given earlier.  These have been done to all the headers.  Do I do one or the other meaning that I would just need to do the fixed data only and not to combine it with the other instructions given earlier?

    Brigitte  

    Tuesday, August 13, 2019 12:32 PM
  • Hello ,

    I finally got the scrolling to work but it is overlapping the text.  Is there a way for the text to be below the headers?  See screenshot

    Brigitte 

    Tuesday, August 13, 2019 12:48 PM
  • Hello,  

    Since we are on headers,  how would they be printing on every page?  is it by the instructions you gave earlier or a different set of instructions?

    Brigitte

    Tuesday, August 13, 2019 12:52 PM
  • Hi Brigitte,

    Those overlapping is inevitable, normally we could set background color for the header row (as I did in my pic), to make the table look more nicely.


    To repeat the header for every page you need to set RepeatOnNewPage to True, set KeepWithGroup to After one advanced Mode for static row.

    See.

    Regards,

    Lukas


    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, August 14, 2019 2:04 AM
  • Hello Lukas,

    I have tried to set set RepeatOnNewPage to True, set KeepWithGroup to After one advanced Mode for static row but I get an error message.

    regards,

    Brigitte

    Thursday, August 15, 2019 5:39 PM
  • Clear other setting first. We would only need this two to show the header on every page.

    I guess you may also choose repeat header on each page in tablix properties?

    If not, what is the error, please share the error message screenshot.

    Regards,

    Lukas


    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, August 16, 2019 3:10 AM
  • Hello Lukas,

    the error msg is in the image along with the setting:

    Friday, August 16, 2019 3:15 PM
  • Hello Lukas ,

    I have the scrolling setting in place.  Would I need to remove them before placing the header on every page settings?

    regards,

    Brigitte 

    Friday, August 16, 2019 3:16 PM
  • Are you trying to freeze multiple rows?

    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, August 23, 2019 9:48 AM