Easylib

Easylib Help

Campus ERP Reports

Entire Automation System for Libraries

E-Mail: info@easylibsoft.com

Website: https://easylib.net

Campus ERP Reports

Edulite Custom Reports

This section allows administrators to create and manage customized reports for the Campus ERP system. It enables institutions to generate reports based on specific requirements that may not be available in standard reports.

Using this feature, users can design reports by defining queries and output variables and make them available for administrative or academic analysis.

The module mainly includes:

  1. Student Reports
  2. Upload Custom Report
  3. Output Variables

Student Reports

This section provides reports related to student data stored in the Campus ERP system. These reports help administrators analyze student information for academic and administrative purposes.

Typical information available in Student Reports includes:

  1. Student registration details
  2. Department-wise student lists
  3. Year-wise student enrollment
  4. Course-wise student data
  5. Student contact information

These reports help institutions monitor student records, enrollment statistics, and academic distribution.

Purpose:

  1. Track student data across departments
  2. Generate lists for administrative work
  3. Support academic management and reporting

1?? Header Section

At the top you see:

  1. Institution Name: Easylib Group of Institutions (Kagina)
  2. System Info: Test instance of Easylib & EasyOne for the campus
  3. Navigation Links (Top Right):
  4. Home – Go to dashboard
  5. Menu Menu-2 ET
  6. Sahana Support
  7. New Support
  8. NTT Dashboard
  9. Logout
  10. Session Started: Shows login time (11:19:21)

This area is mainly for navigation and system status.

2?? Left Sidebar – Edulite Custom Reports

This panel is for managing report templates.

Options available:

  1. Student Reports (current page)
  2. Generate reports for individual students.
  3. Upload Custom Report
  4. Upload your own report template (usually HTML or report format).
  5. Output Variables
  6. Shows available data fields (like student name, marks, class) that can be used inside templates.

3?? Main Section – Generate Student Report

This is the working area where you create the report.

?? MemberId

  1. Field where you enter the Student ID / Member ID.
  2. The system uses this ID to fetch that student’s data.

Example:

MemberId: 10234

?? Template

Dropdown to choose a report template.

Templates may include:

  1. Student Profile
  2. Report Card
  3. ID Card
  4. Progress Report
  5. Fee Statement

The selected template defines how the report will look.

?? Buttons

?? Preview in Browser

  1. Generates the report and shows it in the browser for checking.

?? Generate PDF

  1. Generates the final downloadable PDF report.

4?? Typical Workflow

How this page is normally used:

  1. Enter Student Member ID
  2. Select Report Template
  3. Click Preview in Browser to check layout
  4. Click Generate PDF to download or print

Upload Custom Report

The Upload Custom Report option allows administrators to upload or register new custom reports created using SQL queries or report templates.

This feature is used when the institution requires reports that are not available in the standard EasyLib ERP reporting system.

Steps involved:

  1. Prepare the report query or report template.
  2. Go to Upload Custom Report.
  3. Enter the report details such as:
  4. Report Name
  5. Description
  6. Query or report definition
  7. Save the report.

Once uploaded, the report becomes available under the Custom Reports section and can be executed whenever needed.

Purpose:

  1. Create institution-specific reports
  2. Extend reporting capability of the ERP system
  3. Provide customized analytical data

1?? Upload Custom Report Screen

This page is used to manage report templates.

Top Table – Existing Reports

The table shows all the custom reports already created in the system.

Columns Explanation

Report Name

  1. The name of the report shown to users.
  2. Example:
  3. Bonafide certificate
  4. Character Certificate
  5. Conduct Certificate
  6. No Due Certificate

Template Name

  1. The actual template file uploaded.
  2. Usually:
  3. .htm / .html ? HTML report template
  4. .pdf ? fixed PDF
  5. .png ? image template

Example:

templ_character_certificate.htm

templ_conduct_certificate.htm

Module

  1. The system module where the report is used.
  2. Example modules:
  3. Admission
  4. Members
  5. ERP

Description

  1. Short explanation of the report.

Action

  1. Modify ? Edit the report details or template.

Bottom Section – Upload Template

This section allows you to add a new report template.

Fields:

Report Name

  1. Name of the report.

Example:

Transfer Certificate

Module

  1. Which module will use the report.

Example:

Admission

Template Name

  1. Upload the template file.

Supported formats usually:

.html

.htm

.pdf

Description

  1. Optional description.

After uploading, the report becomes available in Student Reports page for generation.

Output Variables

Output Variables define the data fields that will appear in the final report output.

These variables represent the columns displayed in the generated report.

Examples of output variables include:

  1. Student Name
  2. Student ID
  3. Department
  4. Course
  5. Admission Year
  6. Email ID
  7. Phone Number

When a custom report query is executed, the system maps these variables to the query results and displays them in the report.

Purpose:

  1. Define which data fields appear in the report
  2. Control report structure and format
  3. Customize report output according to institutional needs

2?? Output Variables Screen

This page defines dynamic data fields used inside templates.

These variables pull data from the database using SQL queries.

Table Columns Explanation

Output Variables

The variable name used in the template.

Example:

out_var_current_date

out_var_member_id

These variables will be used inside the HTML template like:

${out_var_current_date}

${out_var_member_id}

Queries

SQL query used to fetch the value.

Example 1:

SELECT CAST(GETDATE() AS date) as data

Meaning:

? Gets current system date.

Example 2:

select Fld_Member_Id as data

from Members

where Fld_Member_Id = ?

Meaning:

? Fetch student/member ID from Members table.

Input Variables

Variables passed into the query.

Example:

MemberId

This comes from the Student Reports screen where you type MemberId.

Purpose

Description of why the variable exists.

Used In

Which reports use this variable.

Action

  1. Modify ? edit query
  2. Delete ? remove variable

3?? How These Three Screens Work Together

Step 1 – Create Output Variables

Define data like:

Student Name

Course

Date

Fees

Member ID

Step 2 – Create HTML Template

Inside template you use variables:

Student Name : ${student_name}

Course : ${course}

Date : ${out_var_current_date}

Step 3 – Upload Template

Upload it using Upload Custom Report.

Step 4 – Generate Report

Go to Student Reports screen.

Enter:

MemberId

Template

Then click:

Preview in Browser

or

Generate PDF

4?? Real Example

Bonafide Certificate Template

This is to certify that

${student_name}

is a student of

${course}

during the academic year ${year}.

The variables will be replaced with real database data automatically.