Welcome to Spipp.net server Sign in | Join | Help

Kaisa's blog

On Reporting Services, Sharepoint, dotText and Larp

How to get at page break in a list control (RS 2000)

I'm currently making a report, showing a table with numbers and a text box with description, each related to an employee's data. I wanted to have each emloyee o a new page, but couldn't figure out how. A lot of how-tos on the web suggested to set up the correct dataset for the list, add the correct grouping and "Page break at start or Page break at end". The two first are ok, but where do I set the Page break at start / end?

The answer was found in yet another google.groups thread at microsoft.public.sqlserver.reportingsvcs: Adding group to list with page break

I answer you with the same answer given on another thread of this newsgroup:

"Because of bug the List Grouping / Sorting is missing the checkboxes to set
the PageBreakAtEnd and PageBreakAtStart properties. You will need to hand
edit the RDL to work around this problem. Be sure to backup the RDL before
you make these changes.
I have attached a simple sample report that shows rectangle and list
usage. Key are of the RDL to examine:     

<List Name="list1">        <Style />       

<Grouping Name="list1_Details_Group">         

<GroupExpressions>

   <GroupExpression>=Fields!Country.Value</GroupExpression>

</GroupExpressions>         

<PageBreakAtEnd>true</PageBreakAtEnd>  <<<<<<  Add this here       
</Grouping>"

This answer was posted by Bruce Johnson [MSFT] on 2/12/2004 12:41 PM PST

Regards,

Juanjo
***

I hand edited my RDL, and the page break occured as expected.
Published 12-06-2006 12:22 by kaisa
Filed Under:
New Comments to this post are disabled
SkinName:iroha_Blog2
Powered by Community Server, by Telligent Systems