Conditional Page break before the group

Question

Hello All,
I am migrating one report from crystal report to ssrs 2008. In crystal there are 3 groups.
Grp#1---- Conditional page break before
Grp#1 a header
Grp#1 b header------ Conditional Page break after
Grp#2 HEADER
Grp#3  header---- Conditional page break before.

i cannot implement it directly in the ssrs as it does not allow conditional page break.

Please let me know how to implement Conditional Page break before the group and Conditional Page break after the group .

Awaiting for your quicker answers.

Regards,
Shrinidhi

Answer 1

Hi Shrinidhi

Since you cant directly add conditional page breaks, you need to create Conditional Group which has page break start/end set

DummyGroup1  -- Exp =IIF(Condition,1,nothing) Page Break at start (No Page Headers and Footers added to table)
Grp#1
Grp#1 a header
Grp#1 b header
DummyGroup2  -- Exp =IIF(Condition,1,nothing) Page Break at start (No Page Headers and Footers added to table)
Grp#2 HEADER
DummyGroup3  -- Exp =IIF(Condition,1,nothing) Page Break at start (No Page Headers and Footers added to table)
Grp#3  header

This might help you..
Thanks

---

Smitha

Answer 2

     I have the same problem, but it's the condition that stumps me.  I want to insert the page break when the Upper level group is expanded and I want to omit the page break when the uppler level group is contracted.  For example I want to show totals for all the Corporate Entities on one page until they are expanded.  When the corporation detail is expanded I want a page break after each corp to appear.  How do you refer to the property that indicates if a group is expanded or not?  How do you set the page break to true or false based on whether the expanded property of the group is true or false?  I couold use that dummy group and set a page break based on that calculated field, but then I'm right back to "how do you reference that expansion property of a group?  Thanks.