SQL Server Admin
T-SQL Articles

April 04, 2008

SSRS Report Design Layout Tricks




Here are 3 commonly used features while designing report layout using Sql server reporting services(SSRS) in SQL Server 2005

Tip 1: Add a Page Header to the report
Open a report. Choose the Layout view.Go to Report menu > Page Header/Page Footer > Click on it.Drag a TextBox from the tools menu to the Header/Footer and set the properties on it


Tip 2: Hide a Page Header on the First and Last Page of the report
Open a report. Choose the Layout view.Click the page header. In the Properties window, set the PrintonFirstPage and PrintonLastPage property to False.


Tip 3: Add a Page Break
Open a report. Choose the Layout view.Right click an item and choose properties. On the General tab, Page breaks, select Insert a page break before the list/after the list.


Did you like this post?
kick it on DotNetKicks.com
subscribe via rss subscribe via e-mail
print this post follow me on twitter


About The Author

Suprotim Agarwal, ASP.NET Architecture MVP works as an Architect Consultant and provides consultancy on how to design and develop Web applications.

Suprotim is also the founder and primary contributor to DevCurry, DotNetCurry and SQLServerCurry. He has also written an EBook 51 Recipes using jQuery with ASP.NET Controls.

Follow him on twitter @suprotimagarwal

 
  Feedback:

comments

1 Response to "SSRS Report Design Layout Tricks"
  1. Anonymous said...
    April 13, 2011 3:08 AM

    any idea on how to add my erport an epilog??
    thanks

 

Copyright © 2009-2012 All Rights Reserved for SQLServerCurry.com by Suprotim Agarwal | Terms and Conditions