Blog Gallery Downloads Pune, India
+91-9175475419 info@softwellautomation.com

SQL Reporting Manual
Database Reporting Practical Manual

Official Philosophy: Open the software, open the Softwell Notebook, and perform the practical.

20 Practical Steps
Action Flow Manual
No Theory / Only Practical
Softwell Training Template

Softwell
Digital Practical
Notebook

[check] Open -> Click -> Select -> Download -> Test -> Complete

NO THEORY * ONLY PRACTICAL
P01

Softwell Digital Practical Manual

Practical 01 - Install SQL Server Express

Philosophy: Open the software, open the Softwell manual, and perform the practical.

SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01
Install SQL Server Express and SQL Server Management Studio on the engineering laptop.
v
02
STEP 02
Open SQL Server Management Studio and connect to the local SQL instance.
v
03
STEP 03
Confirm the server name, authentication mode and connection status.
v
04
STEP 04
Create a folder named D:\Softwell_Training\SQL_Reporting for scripts and exports.
v
05
STEP 05
Save a screenshot or note of the successful connection for the practical record.

Expected Result

SQL Server is installed, SSMS opens correctly, and the local SQL instance is ready for reporting work.

P02

Softwell Digital Practical Manual

Practical 02 - Create Training Database

Philosophy: Open the software, open the Softwell manual, and perform the practical.

SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01
In SSMS, right-click Databases and select New Database.
v
02
STEP 02
Database name: Softwell_Reports.
v
03
STEP 03
Keep default file locations unless your trainer gives a project server path.
v
04
STEP 04
Click OK and refresh the database list.
v
05
STEP 05
Expand Softwell_Reports and confirm Tables, Views and Programmability folders are visible.

Expected Result

Database Softwell_Reports is created and ready for table design.

P03

Softwell Digital Practical Manual

Practical 03 - Create Production Table

Philosophy: Open the software, open the Softwell manual, and perform the practical.

SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01
Open a new query window on Softwell_Reports.
v
02
STEP 02
Create table ProductionLog with columns ID, TimeStamp, MachineName, BatchNo, GoodCount, RejectCount and SpeedRPM.
v
03
STEP 03
Execute the CREATE TABLE query.
v
04
STEP 04
Refresh Tables and confirm dbo.ProductionLog exists.
v
05
STEP 05
Open Design view and verify data types are correct.

Expected Result

ProductionLog table is available with the required reporting columns.

P04

Softwell Digital Practical Manual

Practical 04 - Create Alarm History Table

Philosophy: Open the software, open the Softwell manual, and perform the practical.

SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01
Create table AlarmHistory with ID, TimeStamp, AlarmCode, AlarmText, Status and AcknowledgeUser.
v
02
STEP 02
Set ID as an identity primary key.
v
03
STEP 03
Execute the query and refresh Tables.
v
04
STEP 04
Insert one test alarm record manually using an INSERT query.
v
05
STEP 05
Run SELECT TOP 10 * FROM AlarmHistory to verify the record.

Expected Result

AlarmHistory table stores timestamped alarm records correctly.

P05

Softwell Digital Practical Manual

Practical 05 - Insert Manual Test Records

Philosophy: Open the software, open the Softwell manual, and perform the practical.

SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01
Prepare five INSERT statements for ProductionLog.
v
02
STEP 02
Use different machine names, batch numbers and count values.
v
03
STEP 03
Execute the script and confirm no SQL errors.
v
04
STEP 04
Run SELECT * FROM ProductionLog ORDER BY TimeStamp DESC.
v
05
STEP 05
Verify all manual records appear in the correct order.

Expected Result

Manual production records are inserted and visible in the report table.

P06

Softwell Digital Practical Manual

Practical 06 - Import CSV Data

Philosophy: Open the software, open the Softwell manual, and perform the practical.

SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01
Create a CSV file with production columns matching ProductionLog.
v
02
STEP 02
Use Import Flat File or BULK INSERT to load the CSV into SQL.
v
03
STEP 03
Map CSV columns to table columns carefully.
v
04
STEP 04
Run a SELECT query after import.
v
05
STEP 05
Compare row count in SQL against the CSV row count.

Expected Result

CSV production data is imported into SQL without missing rows.

P07

Softwell Digital Practical Manual

Practical 07 - Create Shift Report View

Philosophy: Open the software, open the Softwell manual, and perform the practical.

SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01
Create a SQL view named vw_ShiftProduction.
v
02
STEP 02
Group production by MachineName, BatchNo and shift date.
v
03
STEP 03
Calculate TotalGood, TotalReject and TotalProduction.
v
04
STEP 04
Execute the CREATE VIEW query.
v
05
STEP 05
Select from vw_ShiftProduction and verify grouped output.

Expected Result

Shift production view summarizes raw production data into report-ready rows.

P08

Softwell Digital Practical Manual

Practical 08 - Daily Summary Query

Philosophy: Open the software, open the Softwell manual, and perform the practical.

SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01
Write a query for today's production records.
v
02
STEP 02
Use SUM for GoodCount and RejectCount.
v
03
STEP 03
Calculate rejection percentage using a safe divide-by-zero expression.
v
04
STEP 04
Order the result by machine name.
v
05
STEP 05
Save the query as daily-summary.sql.

Expected Result

Daily summary query produces machine-wise production totals and rejection percentage.

P09

Softwell Digital Practical Manual

Practical 09 - Alarm History Report Query

Philosophy: Open the software, open the Softwell manual, and perform the practical.

SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01
Write a query for alarms between two timestamps.
v
02
STEP 02
Filter AlarmHistory by TimeStamp range.
v
03
STEP 03
Sort by TimeStamp descending.
v
04
STEP 04
Show AlarmCode, AlarmText, Status and AcknowledgeUser.
v
05
STEP 05
Save the query as alarm-history-report.sql.

Expected Result

Alarm report query lists filtered alarm history with acknowledgement details.

P10

Softwell Digital Practical Manual

Practical 10 - Energy Report Table

Philosophy: Open the software, open the Softwell manual, and perform the practical.

SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01
Create EnergyLog table with TimeStamp, MeterName, kWh and DemandKW.
v
02
STEP 02
Insert sample energy records for at least two meters.
v
03
STEP 03
Write a query to show total kWh per meter.
v
04
STEP 04
Add date filtering to the query.
v
05
STEP 05
Verify totals against sample data.

Expected Result

Energy report table and query calculate meter-wise consumption.

P11

Softwell Digital Practical Manual

Practical 11 - Stored Procedure Report

Philosophy: Open the software, open the Softwell manual, and perform the practical.

SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01
Create stored procedure sp_DailyProductionReport.
v
02
STEP 02
Add parameters @FromTime and @ToTime.
v
03
STEP 03
Use the parameters in the WHERE clause.
v
04
STEP 04
Execute the stored procedure with sample dates.
v
05
STEP 05
Confirm the output matches the daily summary query.

Expected Result

Stored procedure generates reusable production report output for any date range.

P12

Softwell Digital Practical Manual

Practical 12 - Batch Report

Philosophy: Open the software, open the Softwell manual, and perform the practical.

SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01
Write a query filtered by BatchNo.
v
02
STEP 02
Join production and alarm data by time window if sample data allows.
v
03
STEP 03
Show batch counts, rejects and related alarms.
v
04
STEP 04
Save the query as batch-report.sql.
v
05
STEP 05
Test with at least two batch numbers.

Expected Result

Batch report displays production and quality data for selected batches.

P13

Softwell Digital Practical Manual

Practical 13 - Export Report to CSV

Philosophy: Open the software, open the Softwell manual, and perform the practical.

SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01
Run the daily summary query in SSMS.
v
02
STEP 02
Use Save Results As or SQLCMD export method.
v
03
STEP 03
Save output as DailyProductionReport.csv.
v
04
STEP 04
Open the CSV in Excel and verify headings and rows.
v
05
STEP 05
Store the file in D:\Softwell_Training\SQL_Reporting\Exports.

Expected Result

SQL report output exports cleanly to CSV for Excel use.

P14

Softwell Digital Practical Manual

Practical 14 - Excel Report Connection

Philosophy: Open the software, open the Softwell manual, and perform the practical.

SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01
Open Excel and use Get Data from SQL Server.
v
02
STEP 02
Connect to the local SQL instance and Softwell_Reports database.
v
03
STEP 03
Select vw_ShiftProduction or a report query.
v
04
STEP 04
Load the result into a worksheet.
v
05
STEP 05
Refresh the Excel connection and confirm updated SQL rows appear.

Expected Result

Excel is connected to SQL and can refresh reporting data.

P15

Softwell Digital Practical Manual

Practical 15 - PDF Report Preparation

Philosophy: Open the software, open the Softwell manual, and perform the practical.

SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01
Format the Excel report with title, date range and totals.
v
02
STEP 02
Set print area and page orientation.
v
03
STEP 03
Export the Excel sheet as PDF.
v
04
STEP 04
Open the PDF and verify layout, headings and totals.
v
05
STEP 05
Save as DailyProductionReport.pdf.

Expected Result

SQL report is converted into a readable PDF report.

P16

Softwell Digital Practical Manual

Practical 16 - Schedule Auto Report

Philosophy: Open the software, open the Softwell manual, and perform the practical.

SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01
Create a batch file or PowerShell script to run a saved SQL export.
v
02
STEP 02
Test the script manually from Command Prompt or PowerShell.
v
03
STEP 03
Open Windows Task Scheduler.
v
04
STEP 04
Create a daily task for the report script.
v
05
STEP 05
Run the task manually and confirm the export file is created.

Expected Result

Report export runs automatically through a scheduled task.

P17

Softwell Digital Practical Manual

Practical 17 - Database Backup

Philosophy: Open the software, open the Softwell manual, and perform the practical.

SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01
Right-click Softwell_Reports and choose Tasks > Back Up.
v
02
STEP 02
Select Full backup type.
v
03
STEP 03
Save backup as Softwell_Reports.bak.
v
04
STEP 04
Run the backup and confirm success.
v
05
STEP 05
Copy the backup file to the training backup folder.

Expected Result

Database backup file is created for reporting project safety.

P18

Softwell Digital Practical Manual

Practical 18 - Database Restore Test

Philosophy: Open the software, open the Softwell manual, and perform the practical.

SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01
Create a restore test database named Softwell_Reports_Test.
v
02
STEP 02
Restore from Softwell_Reports.bak.
v
03
STEP 03
Check Tables, Views and Stored Procedures after restore.
v
04
STEP 04
Run one report query from the restored database.
v
05
STEP 05
Confirm restored data matches the original database.

Expected Result

Backup file restores successfully and reports run from restored data.

P19

Softwell Digital Practical Manual

Practical 19 - User Permission Setup

Philosophy: Open the software, open the Softwell manual, and perform the practical.

SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01
Create a SQL login or database user for report reading.
v
02
STEP 02
Assign read-only permission to report tables and views.
v
03
STEP 03
Test login access from SSMS.
v
04
STEP 04
Confirm the user can SELECT report data.
v
05
STEP 05
Confirm the user cannot modify table structure.

Expected Result

Report user has safe read-only access for reporting.

P20

Softwell Digital Practical Manual

Practical 20 - Final SQL Reporting Project

Philosophy: Open the software, open the Softwell manual, and perform the practical.

SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01
Prepare production, alarm and energy tables.
v
02
STEP 02
Create required views and stored procedures.
v
03
STEP 03
Export one CSV report and one PDF report.
v
04
STEP 04
Schedule one automated report task.
v
05
STEP 05
Demonstrate backup, restore and read-only user access.

Expected Result

Complete SQL reporting workflow is ready with tables, queries, exports, automation and backup.

☎ Call 🟢 WhatsApp ✉ Enquire Now