VIPUL IT

  Open File Explorer and navigate to  C:\Windows\SoftwareDistribution\Download .   Ensure you have hidden files and folders visible in File Explorer settings.   Select all files and folders in the Download folder and delete them.   Note:   It's recommended to stop the Windows Update service before deleting files:   Open Command Prompt as an administrator.   Type  net stop wuauserv .   Type  net stop bits  (optional, but can help with cleanup).   Navigate to the  C:\Windows\SoftwareDistribution  folder and delete the contents, or rename the folder for easy rollback.   Type  net start wuauserv  to restart the service.   Type  net start bits  (optional, to restart the Bit Transfer Service).  

  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...

 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

 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')

  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

 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

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

  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

 Some times Numeric Keypad not working however num lock key is on. This problem arise because of mouse key on in Ease of Access Center. Here is the step of how to turn off mouse key in Ease of Access Center. Solution Go to Control Panel --> Ease of Access Center --> Make the keyboard easier to use where you find 'Turn Your Mouse Keys' check box under the title of 'Control the mouse with the keyboard'. please untick the check box and then click on apply and ok. Now check keypad will working.

 To Gate Data Order by Month Name You can Use the 'DATENAME' Function for extract Month Name from the Date Column and then use order by clause to sort the result by the month name. as per below example. Select column1, column2, DateName(MM, Date_Column) as MonthName  from Table1 order by month(Date_Column) In this example replace 'column1' and 'column2' with your actual column name and 'Date_Column' with actual column which has date value. Replace Table1 with actual Table. 'DateName'  function is use to extract Month Name from the date_column. Order By clause is use to sort the data ascending and descending order. In above example 'Month' function used for the sorting data by month name like January, February, March. 

  There are two function available in MS-SQL Server. 1) DATENAME                We can use DATENAME() function to get Month Name from Date in MS-SQL Server. Syntax                                       2)FORMAT                We can use FORMAT() function to get Month Name from Date in MS-SQL Server. Syntax              

  There are Two Method for Run Command With Admin Privileges. 1)Click on Start and type "CMD" in windows search where you find "Command Prompt" App. Right Click on "Command Prompt" and Select "Run As Administrator". Then Command Prompt Open with Admin Privileges where you can type command which run with Admin Privileges. 2)Press Win + R on Your Keyboard. In the Run Dialog box type your Command which you want to run with Admin Privileges then Press Ctrl + Shift + Enter and Programme run with Admin Privileges. 

 Sometimes in outlook mail searching not working in paricular one outlook ".pst" file other ".pst" file mail searching working fine. Solution Due to indexing problem and ".pst" file corruption you will not search mail.so that first you will try to rebuild indexing. if its not work then try to repair ".pst" file using scanpst.exe.  Step -1 - Rebuild Indexing. To rebuild indexing  go to file menu-->Option-->Search-->indexing option-->Advance and click on rebuild.                          If step -1 not working then try step-2 as per below. Step -2 - Repair ".pst" file using "SCANPST.EXE". To Repair ".pst" file first run scanpst.exe file from microsoft office folder located in c:\Program files. Browse and select your ".pst" file having searching issue then click on start then it will ask  for repair and click on repair. After repair it will take some time after that you can search mail.

 How do we sort months in Chart when create chart report  ? Some times we need to sorting chart when we create chart report. sorting option shows only alphabetic and numeric sorting. To sort chart by month use the following sorting expression. Right Click on the category field of the chart and select Category Group Properties. then go to the sorting tab. open the expression tab and use the following expression.                      =Month(cdate("1-" &Fields!mon.Value & "-2010")) Keep the order as A-Z and it should now order your Months Correctly.

- using sTRING_AGG function The STRING_AGG function is available from sql server 2017 onwards. The STRING_AGG is a string function which will simplify the concatenation of rows. The sysntax for using STRING_AGG function as per below. SELECT STRING_AGG( ISNULL (Narration, ' ' ), ',' ) As Narration         From PostedNarration You can use comma and space between rows for concatenate.

Open Report Properties and click on code.Copy and paste below function code in opened code windows and click ok.

  There are two things that need to be checked out in order to make sure that you really get multiple buttons on the Taskbar. The first thing is in Excel; follow these steps: 1)In File Menu click on options--> 2)then click on Advanced-->Under Display menu tick mark on "show all windows in the taskbar"

If you wish to reinstall or restore all the built-in Windows 10 apps, use this command: Get-AppXPackage -allusers | Foreach {Add-AppxPackage -DisableDevelopmentMode -Register "$($_.InstallLocation)\AppXManifest.xml"}

Problem Sometimes in windows 10,user face the desktop icon related problem.Sometime desktop icon hide and not showing in desktop,but you can access all icon through file Explorer. Solution Although it may sound banal, it’s quite possible you overlooked this. So, just to be sure, check if your Desktop icons are set to appear once again. Here’s how to do that: Right-click on the empty area on your desktop. Choose View and you should see the  Show Desktop icons option. Try checking and unchecking  Show Desktop icons  option a few times but remember to leave this option checked.

Remote Desktop Connection has Stopped Working whenever the user RDPs onto a machine it launches but after about 10 seconds mstsc.exe crashes with the error 'Remote Desktop Connection has Stopped Working. Reason 1)This Remote Desktop Issue related to outdated printer driver installed on your work station which redirected when you login on to remote desktop server.Due to outdated printer driver remote desktop has stopped working. 2)Another reason is outdated Audio driver installed in your Work Station. Solution You can try to fix it in two different ways.once you update all printer and audio driver of your work station.And other solution as under below. 1. d isable Printer redirect on RDP settings. 2. disable audio redirect on RDP settings.