I keep running my head into a wall working on a project and I am hoping you guys can help me. I have created a database that contains the addresses of contacts. What I need to accomplish is generating paper reports of these addresses. So, for example, I may have 25 addresses on one report related by some other data point. I figured that I should easily be able to pull info from my database and fill a PDF template with it that I could then print out, but this has proven harder than expected.
So far, I’ve tried airtable and notion (I know, but I was temporarily having server issues and I need to get this project done) I’ve also tried baserow and nocodb, and yet I can’t seem to figure out how to generate printable reports from my data.
Does anyone else know of an option? I’ve seen a recommendation for creating a spreadsheet or word document as a template that you then copy/paste your data into, but that feels… inelegant? Would something like appsmith or budibase be capable of this? Or is there some other (preferably self-hosted) software to accomplish this? I appreciate any help you can give me.
Good answers here. Also Excel can do this. You can set a data connection to the database and then use a pivot table to display your desired data. It is not as solid as Power BI but it is a very quick solution.