gb.report2 basics and sqlite3

Ask about the individual Gambas components here.
Post Reply
01McAc
Posts: 66
Joined: Sunday 24th January 2021 8:25pm

gb.report2 basics and sqlite3

Post by 01McAc » Monday 15th February 2021 4:30pm

Sorry to bother you with all the questions but...
I try to get my head around with the gb.report2 component but I do not find any ideas how the report designer in Gambas may work. How can I create a header/footer, a section with repeatable rows and the sum in the footer? Is it completely different to the MS-Access report engine? The Gambas report designer looks quite empty with just a few properties which do not point me into the right direction. Once I understand the basics of the reports I would like to connect a sqlite DB to a report.
Dr. Google didn't give me an answer and the software farm seems to be out of order at the moment.

User avatar
PJBlack
Posts: 132
Joined: Tuesday 09th June 2020 10:26pm
Location: Florstadt, Hessen, Germany

Re: gb.report2 basics and sqlite3

Post by PJBlack » Monday 15th February 2021 5:30pm

hope you like german ...

https://gambas-buch.de/doku.php?id=k22: ... []=report2
01McAc wrote:
Monday 15th February 2021 4:30pm
the software farm seems to be out of order at the moment.
same as gambaswiki.org

01McAc
Posts: 66
Joined: Sunday 24th January 2021 8:25pm

Re: gb.report2 basics and sqlite3

Post by 01McAc » Monday 15th February 2021 6:30pm

PJBlack wrote:
Monday 15th February 2021 5:30pm
hope you like german ...
Yes I noticed and read the site carefully but to be honest I haven't got a clue how to start. This is just a description of properties, probably helpful if you know what you are doing. It's just like having list of ingredients, but no instruction how to cook the meal. I'm looking for the recipe, literally;)

User avatar
cogier
Site Admin
Posts: 695
Joined: Wednesday 21st September 2016 2:22pm
Location: Guernsey, Channel Islands

Re: gb.report2 basics and sqlite3

Post by cogier » Tuesday 16th February 2021 11:47am

There is an example on the Farm called LorumReport that may help.

01McAc
Posts: 66
Joined: Sunday 24th January 2021 8:25pm

Re: gb.report2 basics and sqlite3

Post by 01McAc » Tuesday 16th February 2021 12:22pm

Thanks. Yes, looks stunning. A lot of code to get the text and images in shape.
I guess it's not possible to set a gridview or tableview in the report to populate data out from a database.

User avatar
cogier
Site Admin
Posts: 695
Joined: Wednesday 21st September 2016 2:22pm
Location: Guernsey, Channel Islands

Re: gb.report2 basics and sqlite3

Post by cogier » Tuesday 16th February 2021 1:36pm

I was looking at gb.report and then discovered this: -

Image

So I have stopped now!

01McAc
Posts: 66
Joined: Sunday 24th January 2021 8:25pm

Re: gb.report2 basics and sqlite3

Post by 01McAc » Tuesday 16th February 2021 2:30pm

I know but these are different components gb.report and gb.report2. The one you are referring to seems to be deprecated. gb.report2 is alive and complicated :shock: compared to the rest of Gambas

Post Reply