Recent

Author Topic: Anyone else using FortesReports?  (Read 14464 times)

patyi

  • Full Member
  • ***
  • Posts: 168
Re: Anyone else using FortesReports?
« Reply #15 on: August 12, 2014, 09:58:11 pm »
Hi all !

Sorry I just find request from perell about converting QuickReport to FortesReport.

Read my post from March 03, 2012, 03:39:26 pm :
http://forum.lazarus.freepascal.org/index.php/topic,16181.msg87679.html#msg87679

Try to use it.

patyi

  • Full Member
  • ***
  • Posts: 168
Re: Anyone else using FortesReports?
« Reply #16 on: August 12, 2014, 10:35:26 pm »
Hi hoyosfelix !

Sorry for late response, I'm extremely busy this months ...  O:-)
So if is no late for You here is a little advice for grouping in FortesReport.

 ... place RLReport1 on the empty form ...
1. Place RLGroup1 band to the RLReport1, set property RLGroup1.DataFields = 'REGION', stretch vertically a little bit,
2. Place another RLGroup2 band inside of previous RLGroup1 and set RLGroup2.DataFields = 'REGION;COUNTRY',
    also stretch vertically a bit,
3. Place another RLGroup3 band inside of previous RLGroup2 and set RLGroup3.DataFields = 'REGION;COUNTRY;STATE'
    note between field names the separator is semicolon !
4. Place for example one RLBand as type btHeader, RLBand as type btDetail on last RLGroup3 band, place some RLLabels,   
    RLDBText etc. components

You have now 3 nested RLGroup bands, with Header and Detali band on RLGroup3. Hierarhical order is RLGroup1,2,3.
Next you can put same RLLabel, RLDBText etc. components on RLGroup1, RLGroup2 bands to represent data.

Note : REGION, COUNTRY. STATE are data set fields associated with RLReport. DataSet must be sorted
           by REGION,COUNTRY,STATE

I hope I helped a little.  :D
« Last Edit: August 12, 2014, 10:41:14 pm by patyi »

patyi

  • Full Member
  • ***
  • Posts: 168
Re: Anyone else using FortesReports?
« Reply #17 on: August 12, 2014, 10:54:56 pm »
Here is one of grouped report screen shot from one of my projects.

Coloured bands are RLGroup bands. This is 4 RLGroup bands nested : purple, blue, green and white.
« Last Edit: August 12, 2014, 11:02:53 pm by patyi »

patyi

  • Full Member
  • ***
  • Posts: 168
Re: Anyone else using FortesReports?
« Reply #18 on: August 12, 2014, 11:01:38 pm »
and this is the fragment of preview from the working report ...

patyi

  • Full Member
  • ***
  • Posts: 168
Re: Anyone else using FortesReports?
« Reply #19 on: August 13, 2014, 07:59:33 am »
I decide to publish source code for this report. (zip is in attachment)
This is not an working example, just you can open it with Lazatus IDE and can analyze how I do it.
Fortes4Lazarus and ZeosDBO 7.x packages is required !
(Zeos is not necessary, not relevant to understanding the design, you can ignore it on load time if don't have it)

With hope that I show you the power of Fortes4Lazarus, regards Patyi.

hoyosfelix

  • Newbie
  • Posts: 3
Re: Anyone else using FortesReports?
« Reply #20 on: September 01, 2014, 09:08:25 pm »
Hi patyi

Thank you very much for your response.

I think your contribution is very important for FortesReport users.

Now I'm downloading the zip file to analyze it.

Regards.

hoyosfelix

pjm

  • Newbie
  • Posts: 1
Re: Anyone else using FortesReports?
« Reply #21 on: April 20, 2015, 05:06:28 pm »
Hi everyone

I am testing the waters with Lazarus and Fortes Report, having been using Delphi 2 (with Quick Report) for many years. Mostly looking promising, though I found (and fixed - hopefully correctly!) a problem that would not let FP compile and install into Lazarus. Thanks to Patyi for QR to FR conversion tool - I haven't tried it yet but I am hopeful it will save me a fair bit of work.

Peter

 

TinyPortal © 2005-2018