Recent

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

dsyrios

  • Jr. Member
  • **
  • Posts: 55
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 1.8.4/FPC 3.0.4/ win7/32
Laz 2.0.0/FPC 3.0.4/ mint-mate 19.1

GAN

  • Full Member
  • ***
  • Posts: 230
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 1.8.4 FPC 3.0.4 Linux Mint Mate 17.2 x86_64 GTK-2
Zeos 7.1.3 - Sqlite 3.8.2

Foro Lazarus en español http://forum.lazarus.freepascal.org/index.php/board,73.0.html

paweld

  • Full Member
  • ***
  • Posts: 186
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
paweld

dsyrios

  • Jr. Member
  • **
  • Posts: 55
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 1.8.4/FPC 3.0.4/ win7/32
Laz 2.0.0/FPC 3.0.4/ mint-mate 19.1

paweld

  • Full Member
  • ***
  • Posts: 186
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
paweld

dsyrios

  • Jr. Member
  • **
  • Posts: 55
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 1.8.4/FPC 3.0.4/ win7/32
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