esProc Desktop's Blog
Tag

reporting-tool

#reporting-tool

More content

Read more stories on Hashnode

Articles with this tag

Complement a certain average value to ensure that the total sum remains unchanged — From SQL to SPL #3

Feb 21, 20252 min read

Problem description & analysis: An invoice table in the SQL Server database has one amount for each project, and each project in the project table has...

Complement a certain average value to ensure that the total sum remains unchanged — From SQL to SPL #3

Track Production Operations Outcome Progression with Conditional NULLs - From SQL to SPL #2

Feb 20, 20253 min read

Problem description & analysis: A SQL Server database table describes the execution progress of multiple operations in a production process. When the...

Track Production Operations Outcome Progression with Conditional NULLs - From SQL to SPL #2

Do Ordered Grouping and Aggregation within Groups — From SQL to SPL #1

Feb 18, 20252 min read

Problem description & analysis: A certain database table describes the payment cycle for multiple projects (IDs), with one payment cycle consisting of...

Do Ordered Grouping and Aggregation within Groups — From SQL to SPL #1

ReportLite Practice: Zoned Cross-Report Involving Multi-Table Association

Apr 24, 20243 min read

When conducting data analysis, there will often be some data comparison tasks, which need to associate the data of multiple tables for display. For...