Display a fixed number of rows per page for an SSRS report

-

 

Follow these steps to display a fixed number of records per page


  • First create Query and create dataset then insert table and add details in table.
  • Add a Parent Group to the existing top level row group. The recently                  created Tablix doesn’t have a row group, so right click on Details (under Row Groups section), click on “Add Group” and then Parent Group. You can refer to the below image.



  • Once you click on Parent Group, it will open a Tablix Group. In the Group By expression, enter =CEILING(RowNumber(Nothing)/25) where 25 is the number of records to be displayed per page. If you want to display 50 records then choose 50.In the expression I have used the Ceiling function (which returns the smallest integer greater than, or equal to, the specified numeric expression) and the RowNumber function (which performs a running count of rows within a specified scope). The “Nothing” keyword is used when you want to perform a running count of rows for the topmost group or data region. You may have to replace the “Nothing” keyword with the name of a specific data region or group. There is no need to check the Add group header and Add group footer checkboxes. You can refer to the below image.


  • Right click on the recently created group “Group1” and click on Group Properties.
  • Once you click on Group Properties, it will open a Group Property window. Please give a proper name to this group, because SSRS by default gives a group name which is not descriptive. It is important to give a useful name, so that it will make sense to the next person who is trying to understand the report definition.
  • Next, click on Page Breaks and then check “Between each instance of a group”. Don’t choose to break at the start or end of a group.
  • SSRS automatically creates sorting when a group is created and sorting will be the same as the Group By expression. When the “Page_Break_Group” group was created, sorting was also created. In our case this sorting expression will cause an error, so we have to remove it. To remove sorting go to the Sorting section and delete the sorting.
  • We don’t need the first column from the Tablix, this column was created automatically when we created the “Page_Break_Group” group. Lastly, delete the first column.
  • To delete the first column, right click on the first column then click on “Delete Columns”. We have to keep the group because it contains the Ceiling function, so choose the second radio button “Delete columns only” and then click “OK”.














 

Comments

Post a Comment

Popular posts from this blog

How to Reset Terminal license on Windows 2008, 2008 R2 and 2012

-
The RD Licensing grace period has expired and the service has not registered with a license server with installed licenses. A RD Licensing server is required for continuous operation. A Remote Desktop Session Host server can operate without a license server for 120 days after initial start up. The official solution is to Activate the RDS/TS CAL License server and point the Server to License server with User/Device License and will be resolve the problem, but if you want to reset the timer and again avail the 120 days grace time here is the solution: Solution: 1) First open the registry editor with "regedit" command in command prompt. 2)open the registry key from below path HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Control \ Terminal Server \ RCM \ GracePeriod 3)From GracePeriod delete the key " REG_BINARY".don't delete default registry. 4)then Restart the computer and check the grace period with "tlsbln" command from command ...
Read more

How to remove a static IP configuration for an absent network adapter or uninstall hidden network adapter

-
Image
In a scenario where you have physically removed hardware from a machine you can no longer see it in device manager.  This does not mean that it is gone.  Evidence of that is, if for example you had a network card that had a Static IP address set and you remove the card and add a new one then try to set the IP address to the same as the old NIC you will get an error message. The error might look something like “The IP address 192.168.30.100 you have entered for this network adapter is already assigned to another adapter (Microsoft Virtual machine Bus Network Adapter #3) which is no longer present in the computer.  If the same address is assigned to both adapters and they both become active, only one of them will use this address.  This may result in incorrect system configuration”.  In Windows Server 2008 R2 and Windows 7 it actually gives you an opportunity to “remove the static IP configuration for the absent adapter”. If you say Yes, this will eliminate the ...
Read more