BI备忘录

BI,SSIS,SSAS,SSRS
  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

SSRS2008中table固定行或列

Posted on 2010-04-14 12:24  安德鲁  阅读(543)  评论(0)    收藏  举报

SSRS2008中不能直接像05中那样直接设置fixed headder

参考 :http://blogs.msdn.com/robertbruckner/archive/2008/10/13/Repeat-Header-And-Visible-Fixed-Header-Table.aspx

 

摘抄如下:

  1. in the grouping pane, click on the small triangle and select "Advanced Mode" to show static members:
    Grouping pane in advanced mode
  2. verify that you have the properties grid turned on (in BI Development Studio use F4, in Report Builder go to the "View" tab and select "Properties")
  3. select the corresponding (static) item in the row group hierarchy
  4. in the properties grid:
    - set KeepWithGroup to After
    - set RepeatOnNewPage to true for repeating headers
    - set FixedData to true for keeping headers visible