...
There are separate SQL scripts to generate each report once we have data in the reporting tables by running the above stored procedures mentioned. These SQL scripts can be found under C:\Ed-Fi-Starter-Kit\sample-reports folderReportGenerationScripts folder.
Whenever there is an update in the student data, we can generate updated reports by running the PowerShell script report.ps1 located under same folder. The script performs all the task to generate reports by executing the above stored procedures which inserts data into report tables, executes the SQL scripts present in C:\Ed-Fi-Starter-Kit\sample-reports folder ReportGenerationScripts folder and updates the XLSX files inside Reports folder in desktop. You can follow below steps to run PowerShell script.
...
Step 2. Run below command in powershell to navigate the sample-reports folderthe ReportGenerationScripts folder
| Code Block | ||
|---|---|---|
| ||
cd C:\Ed-Fi-Starter-Kit\sample-reportsReportGenerationScripts |
Step 3. Run below command in powershell to generate the updated reports
...