PDF Report and Firebird database.

[Muhammad Shafiq]

Hi, All

Jam.py the great framework, I explored recently, as I was a Ms Access Developer. I have successfully installed and test. Also created some application for practice. Application builder is so nice and neat and definably 5* starts. 

Can someone share, how to setup firebird database with jam.py and also how to generate pdf reports.   

Thank you and regards

[Andrew Yushev]

Hi, Muhammad

There is docs on Jam.py site

https://jam-py.com/docs/index.html

https://jam-py.com/docs/intro/index.html

https://jam-py.com/docs/programming/reports/index.html

Regards

вт, 7 нояб. 2023 г. в 18:13, Muhammad Shafiq <shafiq....@gmail.com>:

--
You received this message because you are subscribed to the Google Groups "Jam.py Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jam-py+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jam-py/58593a82-2c19-4d13-b7ba-fa8808378546n%40googlegroups.com.

[Dean D. Babic]

Welcome!

https://firebirdsql.org/manual/ubusetup.html 

https://pypi.org/project/fdb/

apt-file list firebird2.5-examples

cp /usr/share/doc/firebird2.5-common-doc/examples/empbuild/employee.fdb.gz /var/lib/firebird/2.5/data/

cd /var/lib/firebird/2.5/data/

gunzip employee.fdb.gz
chown firebird: employee.fdb 

Enjoy

[Muhammad Shafiq]

Thank you and for PDF is there any separate library. Please bear with me... I am an Accountant :)

[Danijel Kaurin]

Hi Muhammad and welcome.

I'm also an MS Access developer and I started using the Jam.py framework about 2 years ago. I merged 3 Access apps into one and now have a big fully functional web solution where I solved every idea that I had. Jam app are fast and have great UI that we can upgrade devepding of our needs.

To create report in Jam.py, you need to create report object: https://jam-py.com/docs/programming/reports/creating_report.html

Next, you need to create report parameters or fields by which you can filter dataset: https://jam-py.com/docs/programming/reports/report_parameters.html

After that, you need to write code in Python in Server module: https://jam-py.com/docs/programming/reports/server_side_programming.html

You can send me your table structure and I can help you. You need to pass each dataset to the Office Lybre template with this part of code: report.print_band('detail', locals())
and add print_band name to your template and that's it. It is very simple.

Feel free to send me some project sample. On my start I also had a challenge to create a report but I learned that from Fabio's app.

Regards

Danijel Kaurin

--

You received this message because you are subscribed to the Google Groups "Jam.py Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jam-py+un...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/jam-py/a2375144-392e-4aa7-a230-f5fc0b640717n%40googlegroups.com.

[Muhammad Shafiq]

Thanks a lot for your help.  and sharing knowledge. Jam.py is best for data driven application and Accountants love data analysis, number crunching. Sure I will ask you questions as we both are from the Debit/Credit field................. Again bundle of thanks ...stay happy and have a nice day. Basically I am developing a payroll system in Jam.py which I have already developed in Ms Access. It has 6 Tables. Employees Master data, Payroll History, Payroll Body Table and line items. The VBA code is around 3000 words. I want to have same structure, process and workflow in Jam.py. I will share with you. 

Regards

[Dean D. Babic]

What is your main language tho?

Because I already did move one quite complex App from Access to here:

https://arabic.pythonanywhere.com/

The reason being is the RTL support.

What you see here is a development Jam version, which is better with RTL.

As an Accountant, you would be better off with looking at the Pivot table implemented here (Analytics):

https://northwind.pythonanywhere.com/

However, that Pivot tables are not supported on the development version.

In reality, the reports in Access are easy, since no need to code anything for simple stuff.

In Jam, as Danijel suggested, a code is needed even for a simple report.

D.

[Dean D. Babic]

Hi, 

no, there is no library for PDF. 

But, depending on the OS, the LibreOffice must be installed and LibreOffice Calc (similar to Excel) is used for creating reports.

The main issue with reports is that LO must be closed, not open, when Jam App runs a report.

So when doing report stuff, open it, change the file, save it into the reports folder, and close LO completely.

To use graphs with reports, pls see this:

https://groups.google.com/g/jam-py/c/rTokOWqyZHM/m/AoshqZ_sCgAJ

The report template is there for download, and the code which displays top 10 customers.

That thread touches on some restrictions with using graphics, ie. charts.

D.