Lazarus

Programming => Databases => Topic started by: Pe3s on November 24, 2022, 09:04:47 pm

Title: [SOLVED] Database print , report
Post by: Pe3s on November 24, 2022, 09:04:47 pm

Hello, greetings to all users, mojen question
is it possible to print from the database , create reports ?

Title: Re: Database print , report
Post by: Zvoni on November 24, 2022, 09:39:03 pm

Don‘t understand the question….

A database is a source of information.
Grab that information, use it to fill your report-template (whichever one, lazreport, Word-document, whatever), print

Title: Re: Database print , report
Post by: Pe3s on November 25, 2022, 07:20:50 pm

What do i need to do to make the report only show the selected row in the table?

Title: Re: Database print , report
Post by: dseligo on November 25, 2022, 07:34:43 pm

Quote from: Pe3s on November 25, 2022, 07:20:50 pm

What do i need to do to make the report only show the selected row in the table?

What report do you use?

Title: Re: Database print , report
Post by: Pe3s on November 25, 2022, 08:16:28 pm

LazReport

Title: Re: Database print , report
Post by: dseligo on November 25, 2022, 09:24:57 pm

You can just move your memos linked to query from 'Master Data' band to the 'Report title' band and delete 'Master Data' band. LazReport will then show you current record.

Although, in this case I would rather manually fill variables (or memos) from program.

You can also use OnGetValue event of the report to fill memos.

You have plenty of ways to do it.

Title: Re: Database print , report
Post by: JanRoza on November 25, 2022, 09:54:33 pm

Take a look in the Examples folder of the lazreport package, there are a number of example projects to show how to use it.

Title: Re: Database print , report
Post by: Pe3s on November 26, 2022, 10:59:09 am

I looked at the examples of LazReport and I have a question to press the variable you need to use OnGetValue ?

Title: Re: Database print , report
Post by: Pe3s on November 26, 2022, 05:21:46 pm

Thank you :)