Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member

Hello Techies,

I am a newbie in writing documents so hopefully if I have made any mistake in my post I am sure you guys will always guide me through in improving. I have been regularly coming across situations where I have been asked if we should go with Breaks or the Sections also what are the differences among them.

So first I would like to show that how the data is different in a Break and in a Section. Lets say I have a sample data as below.

RegionCountryRevenue
0001XYZ20000
0001ABC56600
0001PQR74000
0002LMN11100
0002BCD80000
0002EFG75000
0003HIJ65000
0003KLM49000
0003NOP50000
0001QRS30000

Now First I will create a Break on Region and will try to show the Sum on the based on each Region on it. The formula that I will be using to demonstrate difference between Break and Section will be

=Sum([Revenue]) In Block

Now when I notice the sum on each Region Footer with above code in Break (i.e. 510700) it shows me the total of revenue in the entire Table as shown in Capture1.JPG.

Similarly when you see the sum of each Region Footer with the same code in Segment(i.e. 180600 for Region "0001", 166100 for region "0003" and 164000 for region "0003") it shows me the total of revenue broken by Region as shown in Capture2.JPG.

So based on above analysis we can say that when we deal with Breaks it treats the Table as Single block whereas when we go with Section it creates multiple Blocks.

Apart from that Section allows you to have a navigation and gets exported as bookmarks so gives you a great flexibility to navigate over a large report which you cannot do having Breaks.

Hope my document will help you in understanding Breaks and Sections to an extent.

regards

Niraj

1 Comment
Labels in this area