Recent

Author Topic: LazReport - Help with more than one master-detail tables  (Read 7730 times)

dsyrios

  • Jr. Member
  • **
  • Posts: 57
LazReport - Help with more than one master-detail tables
« on: March 30, 2017, 05:52:08 pm »
Hi,
I need a help using LazReport
as I use one master table and two (or more) details tables.
I show the lazreport/samples and I didn't found something like this.
I want to group all 3 (or more) tables.
In the attachment there is a sample of a simple db
and two ready reports but only with 2 tables master-detail.

My goal is like the...   what_i_want.png
Thanks in advance, for any helping hint/suggestion.
ps
In the archive there is not sqlite3.dll, because of the attachments limitations

Laz 1.6.2/FPC 3.0.0/win32
Laz 2.0.2/FPC 3.0.4/ win10/64
Laz 2.0.0/FPC 3.0.4/ mint-mate 19.1

GAN

  • Sr. Member
  • ****
  • Posts: 370
Re: LazReport - Help with more than one master-detail tables
« Reply #1 on: March 31, 2017, 06:55:00 am »
Master-detail method is very limited, it is better to use groups. It's a little difficult but much better. This link is FastReport4 but you very useful. https://www.fast-report.com/documentation/UserMan/index.html?report_with_groups.htm

Best regards.
Lazarus 2.0.8 FPC 3.0.4 Linux Mint Mate 19.3
Zeos 7̶.̶2̶.̶6̶ 7.1.3a-stable - Sqlite 3.32.3 - LazReport

paweld

  • Hero Member
  • *****
  • Posts: 966
Re: LazReport - Help with more than one master-detail tables
« Reply #2 on: March 31, 2017, 10:38:24 am »
Something like this
Best regards / Pozdrawiam
paweld

dsyrios

  • Jr. Member
  • **
  • Posts: 57
Re: LazReport - Help with more than one master-detail tables
« Reply #3 on: March 31, 2017, 04:40:33 pm »
Thank you paweld,
but unfortunately, I can't open your md3.lrf
It gives: "Error while loading report"
If you got the goodness to send it again,
or describe the main idea for create something like that.
Best regards.

Laz 2.0.2/FPC 3.0.4/ win10/64
Laz 2.0.0/FPC 3.0.4/ mint-mate 19.1

paweld

  • Hero Member
  • *****
  • Posts: 966
Re: LazReport - Help with more than one master-detail tables
« Reply #4 on: March 31, 2017, 07:38:43 pm »
I use lazarus truk with fpc 3.0.2.
Try now - a report created with lazarus 1.6/fpc 3.0.0
Best regards / Pozdrawiam
paweld

dsyrios

  • Jr. Member
  • **
  • Posts: 57
Re: LazReport - Help with more than one master-detail tables
« Reply #5 on: March 31, 2017, 07:58:13 pm »
Thanks a lot, paweld !
That's what I wanted.
I appreciate the time you've spent.
Laz 2.0.2/FPC 3.0.4/ win10/64
Laz 2.0.0/FPC 3.0.4/ mint-mate 19.1

DelphiLand

  • Newbie
  • Posts: 3
Re: LazReport - Help with more than one master-detail tables
« Reply #6 on: July 21, 2018, 06:10:10 pm »
Hi,
I need a help using LazReport
as I use one master table and two (or more) details tables.
I show the lazreport/samples and I didn't found something like this.

Maybe have a look at http://www.festra.com/fp/sqlite07.htm

 

TinyPortal © 2005-2018