reporting services - SSRS hidden rows cause KeepWithGroup to not work -


i have report consists of single table 3 groups. last group has 6 rows in it's footer. each of these rows has keepwithgroup set before , of them can hidden conditionally. when of rows visible, footer rows kept on same page detail possible. however, when 1 of hidden conditions evaluates true row hidden correctly other rows moved next page though fit fine on current page.

if @ groups in advanced mode see this

(static)

(group1)

(static)

(group2)

(static)  (static)  (group3)    (static)    (static)      (static)       -- don't know why here        (group4)  -- detail    (static) 

(static)

(static)

(static)

(static)

(static)

(static)

all of static rows after detail have keepwithgroup set before, seems ignored when of them hidden.

i've tried setting hidden condition on table row , on static row in advanced mode both cause issue.

any ideas?

thanks,

bill

i have 2 ideas try:

  1. in setting advanced properties of grouping try change 'hidden' property expression evaluating if there data in parent grouping.

    =iif( fields!(parentitem).value != nothing, false, true) 
  2. is okay repeat 1 of groups on page break? forcing page breaks in experience helps keeping data more not. , tweaking options of 'keeptogether' true of 'static' members , maybe attempting change 'keepwithgroup' after instead.

i know avoid advanced mode of groupings unless there issue display sounds have fell unfortunately. while debugging may wish see if remove highest parent group if problem still persists see layout causing issues at. know groups shared dependent members across multiple heirarchies there can issues. attempt doing subreport know works called child of parent member while debugging. not final result kind disjointed imho, may see dependency problem lies.

i saw article posted had similar issues: http://blogs.msdn.com/b/robertbruckner/archive/2008/10/13/repeat-header-and-visible-fixed-header-table.aspx


Comments

Popular posts from this blog

c# - How Configure Devart dotConnect for SQLite Code First? -

java - Copying object fields -

c++ - Clear the memory after returning a vector in a function -