Posts

Showing posts from March, 2025

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

Image
  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 “No...

How to Create Bootable Pendrive using CMD(Disk Part Utility)

 Open Command Prompt and type Command as per below 1.     DISKPART  - This starts the utility 2.     LIST DISK  - This shows the disk number of your USB flash drive. In the image below the USB flash drive shows as Disk 2 3.     SELECT DISK X  (Replace  X  with your USB flash drive number, we are using  2  in this example) 4.     CLEAN  - This wipes the drive 5.     CREATE PARTITION PRIMARY   size=32000     - Creates a partition 6.     SELECT PARTITION 1  - Selects partition 1 7.     ACTIVE  - Marks the current partition as active 8.     FORMAT FS=FAT32 QUICK  - This formats the partition 9.     ASSIGN  - Assigns a drive letter   10.   EXIT