I am currently in a state of doubt whether I am doing the things in the right way. Basically, I have a task where data which is stored in a normalised db in MSSQL needs to be queried for so as to display them in different charts. These charts then needs to be converted in a custom PDF and are to be sent as an email attachment automatically.
What I am doing: I am currently querying the data using LINQ, modifying the data to make them in JSON structure in the server side. Then in the client side, I am using AJAX to consume the JSON data and displaying it using google charts. Then, I am using jsPDF to generate the PDF by clicking a button.
The solution I currently have works fine, however it is slightly manual, in the sense that I need to click a button to generate the PDF and send email. Do you recommend a better workflow to get the data, produce them as charts (even if these are done in server side) and send them as an email in one automatic process? I never used SSIS, SSRS and SSAS, so these might be good to look into.