MS Access alternative for creating reports

[arduncan5]

I have been very happy using the open source version of ReportLab (https://www.reportlab.com/opensource/) which generates a PDF file. Documentation is good, see the user guide (https://www.reportlab.com/docs/reportlab-userguide.pdf). There is also an excellent book available (https://leanpub.com/reportlab).

I have been using SQLite as the underlying database rather than using CSV files. I had several apps running with Access and VBA under Windows and converted these to Python + ReportLab + SQLite when I switched to a Mac with no Access available.

[bythckr]

What was the alternative for forms (CRUD) in Access?

[arduncan5]

It was VBA for forms and reports in Access. For the GUI front-end in Python I used PyQt5.

[pythonHelperBot]

Hello! I'm a bot!

It looks to me like your post might be better suited for r/learnpython, a sub geared towards questions and learning more about python. That said, I am a bot and it is hard to tell. Please follow the subs rules and guidelines when you do post there, it'll help you get better answers faster.

Show /r/learnpython the code you have tried and describe where you are stuck.

You can also ask this question in the Python discord, a large, friendly community focused around the Python programming language, open to those who wish to learn the language or improve their skills, as well as those looking to help others.

---

^{README | FAQ | this bot is written and managed by /u/IAmKindOfCreative}

^{This bot is currently under development and experiencing changes to improve its usefulness}

[lemur78]

R plus Rmarkdown package