I am looking for some ideas about the free reporting tools that could be used to integrate with SQL Server database. I have found few of them like: https://sealreport.org/ The most important features I am looking for are:
- authentication customization - to integrate with JWT tokens from central system
- scheduled reporting - possibility to schedule report generation and email send including report as attachment
- possibility to export report data to excel file
- if possible - row level security features - to authorize somehow whether current user is authorize to see specific rows
- the reporting will be embedded in an iframe in the main portal for the customers
Could recommend something from your perspective?