Sections and Breaks

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.

 Region Country Revenue 0001 XYZ 20000 0001 ABC 56600 0001 PQR 74000 0002 LMN 11100 0002 BCD 80000 0002 EFG 75000 0003 HIJ 65000 0003 KLM 49000 0003 NOP 50000 0001 QRS 30000

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

Assigned Tags

1 Comment
You must be Logged on to comment or reply to a post.

Good one for the beginners!!!