Page Break stops working after adding condition in Hide property

SQL Server Reporting Services

Digant Desai


Hi,

I have a report which has 3 tables kept inside rectangle.I have PageBreakAtBegin Set to True for the last 2 tables.Hide Property for rectangle is False.Everything is working fine.

Moment,I place condition in Hide Property,no matter it's True or False,page break stops wroking.I can see all the tables in the single Excel file or report

Any help will be appriciated

-Thanks,

Digs

Top

Re: Page Break stops working after adding condition in Hide property

Priyank Pandey


http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=2000542&SiteID=1



Top

Re: Page Break stops working after adding condition in Hide property

Digant Desai

I don't think so that both will not work simultaneously...Any other solution..idea.. from any one is appriciated...

-Thanks,

Digs



Top

Re: Page Break stops working after adding condition in Hide property

Digant Desai

Do Microsoft agreee with this that "This is the Bug" I Even can't set Pagebreak in groups as I want page header at the end of table only and not after certain amount of rows..

-Digs


Top

Re: Page Break stops working after adding condition in Hide property

Priyank Pandey

Hi,

I read this somewhere in microsoft site only that both are not supported. But couldnt find it.

Just try one thing. below code create a report with a blank textbox and rec. and will not give a page break because a condition is there in visibility tab (condition is 1=2 which can never be true). Just remove that condition and report will start giving page break.

Code Snippet

< xml version="1.0" encoding="utf-8" >

<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

<BottomMargin>1in</BottomMargin>

<RightMargin>1in</RightMargin>

<rd:DrawGrid>true</rd:DrawGrid>

<InteractiveWidth>8.5in</InteractiveWidth>

<rd:SnapToGrid>true</rd:SnapToGrid>

<Body>

<ReportItems>

<Textbox Name="textbox1">

<Left>2.125in</Left>

<Top>0.375in</Top>

<rd:DefaultName>textbox1</rd:DefaultName>

<ZIndex>1</ZIndex>

<Width>0.875in</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.5in</Height>

<Value />

</Textbox>

<Rectangle Name="rectangle1">

<Left>1.75in</Left>

<PageBreakAtStart>true</PageBreakAtStart>

<Top>1.25in</Top>

<Visibility>

<Hidden>=1=2</Hidden>

</Visibility>

<Width>1.625in</Width>

<Style>

<BackgroundColor>Red</BackgroundColor>

</Style>

</Rectangle>

</ReportItems>

<Height>1.625in</Height>

</Body>

<rd:ReportID>bd19dfbc-abba-440c-8491-0246f73d85ce</rd:ReportID>

<LeftMargin>1in</LeftMargin>

<Width>6.5in</Width>

<InteractiveHeight>11in</InteractiveHeight>

<Language>en-US</Language>

<TopMargin>1in</TopMargin>

</Report>




Top

Re: Page Break stops working after adding condition in Hide property

ChandraD

Use nested rectangles. Here's what I found.

http://p2p.wrox.com/topic.asp TOPIC_ID=33706

Wish I could take credit too...


Top