SSRS - How can I fix the number of groups in each page
Problem: I have a Report which displays 6-groups(5-Rows in each Group) of information. The report is having some filter which can be modified by user. When first time report get loads without any filter its page rendering in report viewer and Print page is perfect, But when filters been added in Report information its get unusual. Could anyone please suggest anything to fix number of rows/groups in each page? Solution: I will provide two methods to solve the issue (1) Try to prevent the text boxes from expanding I will assume that you are showing the report parameters (filters) as mentioned in the following link: Include Report Parameter Selection Values in Report Output for SQL Server Reporting Services Then, you should set CanGrow property to False from the Textbox properties pane as mentioned in folowwing article: Allow a Text Box to Grow or Shrink (Report Builder and SSRS) Also make sure that Allow height to increa...