Wednesday, April 3, 2019

SSRS : Setting up a A4 page in Reporting Services

สรุป วิธีการตั้งค่าหน้ากระดาษเพื่อเวลา print แล้วไม่ขึ้นหน้าใหม่เป็น Blank 

1. Report => Report properties => Paper size A4 => width 21 cm
2. เอาขนาด  width ลบ ออก ด้วย margin ซ้ายขวา  21 - 1.5- 1.5 = 18
3. เอาค่าที่ได้ไปใส่ใน Body(คลิกพื้นที่ขาวด้านข้างทางขวา จะโชว์ Body properties) => width

Hi,

I'm always a bit rusty when i start building reports in Reporting Services after a while. One thing i always has to figure out is how to set up the page size, body and margins. In a article on Microsoft you can find more information about this subjct. You can set the properties in the properties window or you can set the properties with report properties window (Menu -> Report -> Report properties). The relation between page, body, header and footer looks conceptual like the diagam below.


Below you can see how i manually set the page size of the report with A4 paper settings.


And don't forget to set the body properties:


The formula of setting the PageSize Width, bodysize and margins is this: Page Width = Body Width+ Left margin + Right Margin. In my case 21= 19+1+1.

In case of the height of the report you need to set the pagesize. In case of A4 : 29,7cm. In case of the body height you can set whatever you wan't. By setting the PageSize Height property the height of A4 is maintained and when the body height is larger than the pageSize (minus top margin and bottom margin) more pages are displayed/printed.

It's also possible to set the properties with the report properties window. Below you can see an example in inches.



We end up with the follow values for the proprties:








No comments:

Post a Comment