Posts

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...
Post a Comment
Read more

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
Read more

How to Create Function For Getting Financial Year From Date.

-
 For Creating Function For Getting Financial Year From Date Copy Below Query and Paste in SQL Server Management Studio and execute.after successful close SQL Server Management Studio and reopen.You will find function under Database→Programmability→Functions. CREATE FUNCTION [dbo].[FinYear] (@input Datetime) returns varchar(20) as  begin DECLARE @FinYear VARCHAR(20) select @FinYear=(CASE      WHEN (MONTH(@input)) <= 3      THEN CONVERT(VARCHAR(4), YEAR(@input) - 1) + '-' + CONVERT(VARCHAR(4), YEAR(@input) % 100)     ELSE CONVERT(VARCHAR(4), YEAR(@input)) + '-' + CONVERT(VARCHAR(4), (YEAR(@input) % 100) + 1) end) RETURN @FinYear end USE ABOVE FUNCTION IN QUERY TYPE SELECT COMMAND AS PER BELOW                                                  select dbo.FinYear('01-Apr-2020')
Read more

How to bypass the internet requirement during Windows 11 setup

-
  You can run the OOBE BypassNRO command to bypass the internet requirements. To bypass the internet requirement. 1. Begin the Windows 11 setup process 2. When you reach the “Let’s connect you to a network” screen with the grayed-out Next button, press Shift + F10 to launch a command prompt 3. In the command prompt, run the following command:  oobe\BypassNR O  This will execute the OOBE BypassNRO command, bypassing the network requirement during Windows 11 setup
Read more

Line Break Between Combining Two Fields in SSRS or Report Builder

-
 For adding Line Break Between Combining Two Fields in SSRS or Report Builder try Below conditional Concatenation in Expression.         = Fields!Addr1.Value & VbCRLF &  Fields!Addr2.Value
Read more

GST Accounting Period does not exist for the given date error in Microsoft Dynamics NAV when run statistic in purchase order.

-
 above Particular error comes when Posting Date and Document Date are Blank in purchase order. enter any date then run statistic its work.
Read more

HOW TO CONVERT INSTALL.ESD TO INSTALL.WIM ON WINDOWS

-
  You can use the built-in DISM.exe command line tool to convert an ESD file to the WIM format. Open the command prompt as Administrator and go to the folder containing the ESD file.                                       cd c:\esd The install.esd file can contain several editions of Windows. Each Windows edition in the image file has an assigned index number (1,2,3,4,…). List the available Windows editions in your install.esd image file using the DISM.                         DISM /Get-WimInfo /WimFile:install.esd In this case, the install.esd file contains seven different Windows 11editions, indexed from 1 to 7. In this example, we will extract the  Windows 11 Pro  edition with index  6. dism /export-image /SourceImageFile:install.esd /SourceIndex:6 /DestinationImageFile:install.wim /Compress:max /CheckIntegrity
Read more