gb.report2 basics and sqlite3

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

gb.report2 basics and sqlite3

Post by 01McAc »

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: 184
Joined: Tuesday 9th June 2020 10:26pm
Location: Florstadt, Hessen, Germany

Re: gb.report2 basics and sqlite3

Post by PJBlack »

hope you like german ...

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

Re: gb.report2 basics and sqlite3

Post by 01McAc »

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: 1118
Joined: Wednesday 21st September 2016 2:22pm
Location: Guernsey, Channel Islands

Re: gb.report2 basics and sqlite3

Post by cogier »

There is an example on the Farm called LorumReport that may help.
01McAc
Posts: 75
Joined: Sunday 24th January 2021 8:25pm

Re: gb.report2 basics and sqlite3

Post by 01McAc »

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: 1118
Joined: Wednesday 21st September 2016 2:22pm
Location: Guernsey, Channel Islands

Re: gb.report2 basics and sqlite3

Post by cogier »

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

Image

So I have stopped now!
01McAc
Posts: 75
Joined: Sunday 24th January 2021 8:25pm

Re: gb.report2 basics and sqlite3

Post by 01McAc »

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