FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Possible to add SubTitels to a Report ?
Posts: 4043
Joined: Wed Dec 19, 2007 06:40 PM
Possible to add SubTitels to a Report ?
Posted: Sun Oct 14, 2012 08:09 PM
Hello,

is it possible, to split a table and add Subtitles inside a report ?
All products are sorted to a defined group.
I need a new Title as soon a Group-changes

sample :



Structure :
Group ( Main-index )
Name
Price

1. Title ( Group 1 )
name-price
name-price
name-price
2. Title ( Group 2 )
name-price
name-price
name-price

Best Regards
Uwe :-)
Since 1995 ( the first release of FW 1.9 )

i work with FW.

If you have any questions about special functions, maybe i can help.
Posts: 1088
Joined: Fri Oct 07, 2005 03:33 PM
Re: Possible to add SubTitels to a Report ?
Posted: Sun Oct 14, 2012 08:51 PM
Hello,

sorry, but did you try?

Code (fw): Select all Collapse
           
             ...........
             GROUP ON alias -> group;
             HEADER <cTITLE>;
             FOOTER <cfooter>


regards

Marcelo
Posts: 4043
Joined: Wed Dec 19, 2007 06:40 PM
Re: Possible to add SubTitels to a Report ?
Posted: Sun Oct 14, 2012 09:13 PM

Marcelo,

Thanks for the response.
I tested GROUP, but the usage doesn't make it possible
to split the table with a new Subtitle ( Group-text ).

Best Regards
Uwe :roll:

Since 1995 ( the first release of FW 1.9 )

i work with FW.

If you have any questions about special functions, maybe i can help.
Posts: 1088
Joined: Fri Oct 07, 2005 03:33 PM
Re: Possible to add SubTitels to a Report ?
Posted: Sun Oct 14, 2012 09:17 PM

Hola,

can you explain a little more about your problem, because in your first sample I don't see any strange data out of classic grouping task

regards

Marcelo

Posts: 4043
Joined: Wed Dec 19, 2007 06:40 PM
Re: Possible to add SubTitels to a Report ?
Posted: Sun Oct 14, 2012 10:40 PM
Marcelo,

group is working, but with some restrictions.
The group is a long text.
The 1. selected Column will have the same length even it is very short.
That is the reason, I asked for a free title line not included incide a cell.
I only need the text, no total-info.



Names displayed included inside a group



Best Regards
Uwe :-)
Since 1995 ( the first release of FW 1.9 )

i work with FW.

If you have any questions about special functions, maybe i can help.
Posts: 368
Joined: Sun May 31, 2009 06:25 PM
Re: Possible to add SubTitels to a Report ?
Posted: Sun Oct 14, 2012 10:43 PM
Hi Uwe,

Did you try this?

Code (fw): Select all Collapse
GROUP ON mytable->GROUP_FIELD HEADER "Subtitle Products  " + oReport:aGroups[ 1 ]:cValue


You posted your last message while I was posting mine. You might try the startgroup method.
Code (fw): Select all Collapse
oReport:bStartgroup := { || oReport:Say( nCol, "Subtitle Products  " +  oReport:aGroups[ 1 ]:cValue ) }


Group larger than column is not a problem.


Uploaded with ImageShack.us
Regards,



André Dutheil

FWH 13.04 + HB 3.2 + MSVS 10
Posts: 4043
Joined: Wed Dec 19, 2007 06:40 PM
Re: Possible to add SubTitels to a Report ?
Posted: Sun Oct 14, 2012 11:13 PM

André,

that comes much closer to the result I'm looking for.
Just one little thing : I getting the Text > Total on each group at the bottom
Is there a way to disable this ( Your screenshot doesn't show text < Total > ) ?

Best Regards
Uwe :?:

Since 1995 ( the first release of FW 1.9 )

i work with FW.

If you have any questions about special functions, maybe i can help.
Posts: 2170
Joined: Fri Jul 18, 2008 01:24 AM
Re: Possible to add SubTitels to a Report ?
Posted: Tue Oct 16, 2012 03:01 AM
ukoenig wrote:André,

that comes much closer to the result I'm looking for.
Just one little thing : I getting the Text > Total on each group at the bottom
Is there a way to disable this ( Your screenshot doesn't show text < Total > ) ?

Best Regards
Uwe :-)


Please try this.
Code (fw): Select all Collapse
GROUP ON field->Seccion HEADER "GROUP HEADER"  FOOTER "  " FONT 5

Best Regards.
Francisco J. Alegría P.

Chinandega, Nicaragua.



Fwxh-MySql-TMySql
Posts: 4043
Joined: Wed Dec 19, 2007 06:40 PM
Re: Possible to add SubTitels to a Report ?
Posted: Tue Oct 16, 2012 08:53 AM
Francisco,
Yes added a empty FOOTER

// shows a extra Group-title belongs to a defined Group-field
// --------------------------------------------------------------------
GROUP ON (30)->GROUP HEADER (30)->GRPTITLE FOOTER " "
oReport:bStartgroup := { || oReport:Say( 1, (30)->GRPTITLE ) }

Best Regards
Uwe :-)
Since 1995 ( the first release of FW 1.9 )

i work with FW.

If you have any questions about special functions, maybe i can help.

Continue the discussion