14
submitted 3 years ago* (last edited 3 years ago) by Ceedling@compuverse.uk to c/selfhosted@lemmy.world

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.

Edit: Sorry everyone, I guess I didn't make it very clear. First off, I've been using the programs above to make my dB's. So for instance, my nocodb is set up to use mysql. I didn't generate the dB on my own, and admittedly, I've never interacted with a db directly using SQL markup before.I was hoping my goal could be accomplished with a low/no-code option as my coding skills are rudimentary right now.

As someone asked, for a printable-report, yes PDF is an option. As would a word document or spreadsheet, for that matter, just so long as I can get it into a nice, print-friendly format.

I do appreciate all the suggestions so far, and will look into them. Thanks!

you are viewing a single comment's thread
view the rest of the comments
[-] PanteraAtrox@lemmy.dbzer0.com 1 points 3 years ago

what do you mean by 'database' ? like ms access or sql?

PowerBI can pull data from sql database, .mdb or .xls files and generate all manner of reports.

this post was submitted on 15 Jul 2023
14 points (88.9% liked)

Selfhosted

60482 readers
679 users here now

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.

Rules:

Detailed Rules Post

  1. Be civil.

  2. No spam.

  3. Posts are to be related to self-hosting.

  4. Don't duplicate the full text of your blog or readme if you're providing a link.

  5. Submission headline should match the article title.

  6. No trolling.

  7. Promotion posts require active participation, with an account that is at least 30 days old. F/LOSS without a paywall has exceptions, with requirements. See the rules link for details.

  8. AI-related discussions and AI-involved promotional posts have additional requirements for tagging, as noted in Rule 7 and the AI & Promotional Post Expanded Rules post.

Resources:

Any issues on the community? Report it using the report flag.

Questions? DM the mods!

founded 3 years ago
MODERATORS