Dear SirNeed your help hereI want to generate report as mention formatI have no code for this type of reports Meja Thermal Power Plant Safety Information SystemTuesday 2162022 BACK Emp Id007221NameD P ChakrabortyDepartmentITMonth062022 MONTH WISE SUMMARYMONTHNUMBER OF PEPTALKS CONDUCTEDNEAR MISS REPORTEDSAFETY DEVIATION OBSERVED amp REPORTEDTOOL amp TACKLES CHECKING CONDUCTEDApril2022 May2022 June20224322July2022 Aug2022 Sept2022 Oct2022 Nov2022

You need to use Pivot function to calculate the totalRefer below linkCalculate Row Total and Column Total using dynamic Pivot query in SQL Server

Query to return Pivoted result in SQL Server

indradeo

Dear Sir,

Need your help here,

I want to generate report as mention format.

I have no code for this type of reports.

Meja Thermal Power Plant Safety Information System

Tuesday 21/6/2022 BACK

Emp. Id:-

007221

Name:-

D P Chakraborty

Department:-

Month:-

06/2022

MONTH WISE SUMMARY

MONTH

NUMBER OF PEP-TALKS CONDUCTED

NEAR MISS REPORTED

SAFETY DEVIATION OBSERVED & REPORTED

TOOL & TACKLES CHECKING CONDUCTED

April-2022

May-2022

June-2022

July-2022

Aug-2022

Sept.-2022

Oct-2022

Nov.-2022

Dec.-2022

Jan-2023

Feb.-2023

Mar.-2023

dharmend...

0 3

You need to use Pivot function to calculate the total.

Refer below link.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html