I work at a school district and am helping to put together a project that will keep kids on track for graduation. We are able to flag a certain number of kids in our database who we can see are having trouble completing their requirements, and our hope is that if we notify them and their parents sooner rather than later we can get them to graduation.
We want to generate a custom document/report from the data we have in our SQL database, saved into something like a .PDF, printed and mailed home. We've worked with a graphic designer to produce something that is appealing and informative, with good use of color, graphics, type and images to indicate progress toward completion in certain areas (math, language, etc). Of course this is just a mockup.
The trouble I'm having is finding a way of populating multiple fields (name, student #, etc), together with images (driven by SQL database values), in a preset layout to be exported and printed for potentially thousands of students at a time.
I've looked at SSRS and understand it can be used for this sort of thing, but I've not seen an example of chart and document styling that has convinced me that it is going to live up to the mockup as designed.
I've also looked at Tableau and Windward but they appear to be more useful for data visualization than database driven document creation.
I'm hoping there are some experts here that can weigh in and point me in the right direction.
Question: Is there a single piece of software that can accomplish what I'm trying to do?
Thanks for your time.