Individual records

In the individual sheets you have a huge amount of information available to be able to create reports tailored to your needs.

Using this feature is simple and you can use your own word or Excel to define the report you want, which you then upload to Kyrios so that it can be generated with your data.

Below are two examples of how you can create a report to display Parishioners' marriage data, one in word and another in Excel.

Example of how to create a Word report to present Parishioners' marriage data #

First, open Word, place static texts, that is, texts that are not generated by Kyrios, such as the Title, header, footer, tables and styles:

Now let's add the variables that will be filled by Kyrios. In this case, we will use the following (below there is a table with all the variables available for the Individual Sheets):

• {d[i].entity.name}
• {d[i].entity.mobilephone}
• {d[i].entity.phone}
• {d[i].entity.email}
• {d[i].entity.civil_status}
• {d[i].maritial_status}
• {d[i].wedding_date}

In the first row of the table we are going to put the variables as described above, as it is the first row, but in the second row we want Kyrios to know that it is to put all the other rows it has, so we have to add +1 to follow {d[i]., thus:

{d[i+1].entity.name}

This way, Kyrios will interpret what you put in the Word file to fill the table with all the records that are in Kyrios' filter.

So our report now looks like this (you can download this template here):

Now we are going to upload the file to Kyrios and we are also going to indicate where it should appear. Thus, you should open the Reporting module:

Then click on “Add Report” to add a new report and fill in the form, attaching the report file you just created in Word.

In the example, we fill in the form as follows:

• Name: Individual cards – with marriage date (WORD)
• Report Type: Detailed List
• Module: Individual sheets
• Export Type: PDF
• Report file: here you must attach your word file

After clicking on Save, you can access the individual records module and you should find your report already available (if not, refresh the page). These reports appear before Kyrios' predefined reports so that you can easily identify them:

As the data appearing in the report is the one that appears on the screen, it is advisable that before clicking on it, filter the data you want.

In this case, as we only want the Parishioners data that are active, we will select these filters:

Now with the data properly filtered, we can click to generate the report:

How, we configure to generate a PDF file, what will appear to us is the following:

Example of how to create an Excel report to display Parishioners' marriage data #

First, open Excel, place static texts, that is, texts that are not generated by Kyrios, such as the Title, header, footer, tables and styles:

Now let's add the variables that will be filled by Kyrios. In this case, we will use the following ones, which are the same as the ones used in the Word example above, plus the spouse's name (below there is a table with all the variables available for the Individual Sheets):

• {d[i].entity.name}
• {d[i].entity.mobilephone}
• {d[i].entity.phone}
• {d[i].entity.email}
• {d[i].entity.civil_status}
• {d[i].maritial_status}
• {d[i].wedding_date}
• {d[i].entity_spouse_description}

In the first row of the table we are going to put the variables as described above, as it is the first row, but in the second row we want Kyrios to know that it is to put all the other rows it has, so we have to add +1 to follow {d[i]., thus:

{d[i+1].entity.name}

This way, Kyrios will interpret what you put in the Excel file to fill the table with all the records that are in Kyrios' filter.

So our report now looks like this (you can download this template here):

Now we are going to upload the file to Kyrios and we are also going to indicate where it should appear. Thus, you should open the Reporting module:

Then click on “Add Report” to add a new report and fill in the form, attaching the report file you just created in Excel, saving in ODS (OpenDocument Spreadsheet) format.

In the example, we fill in the form as follows:

• Name: Individual cards - with marriage date (EXCEL)
• Report Type: Detailed List
• Module: Individual sheets
• Export Type: XLSX
• Report file: here you must attach your Excel file

In this example, we choose to indicate that we want to generate an Excel file, so we can open and filter the records.

After clicking on Save, you can access the individual records module and you should find your report already available (if not, refresh the page). These reports appear before Kyrios' predefined reports so that you can easily identify them:

As the data appearing in the report is the one that appears on the screen, it is advisable that before clicking on it, filter the data you want.

In this case, as we only want the Parishioners data that are active, we will select these filters:

Now with the data properly filtered, we can click to generate the report:

How, we configure to generate an Excel file, what will appear to us is the following:

Complete list of available variables for individual sheets #