Possible to add SubTitels to a Report ?

Possible to add SubTitels to a Report ?

Postby ukoenig » Sun Oct 14, 2012 8: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 :

Image

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.
User avatar
ukoenig
 
Posts: 4043
Joined: Wed Dec 19, 2007 6:40 pm
Location: Germany

Re: Possible to add SubTitels to a Report ?

Postby Marcelo Via Giglio » Sun Oct 14, 2012 8:51 pm

Hello,

sorry, but did you try?

Code: Select all  Expand view
         
             ...........
             GROUP ON alias -> group;
             HEADER <cTITLE>;
             FOOTER <cfooter>
 


regards

Marcelo
Marcelo Via Giglio
 
Posts: 1050
Joined: Fri Oct 07, 2005 3:33 pm
Location: Cochabamba - Bolivia

Re: Possible to add SubTitels to a Report ?

Postby ukoenig » Sun Oct 14, 2012 9: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.
User avatar
ukoenig
 
Posts: 4043
Joined: Wed Dec 19, 2007 6:40 pm
Location: Germany

Re: Possible to add SubTitels to a Report ?

Postby Marcelo Via Giglio » Sun Oct 14, 2012 9: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
Marcelo Via Giglio
 
Posts: 1050
Joined: Fri Oct 07, 2005 3:33 pm
Location: Cochabamba - Bolivia

Re: Possible to add SubTitels to a Report ?

Postby ukoenig » 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.

Image

Names displayed included inside a group

Image

Best Regards
Uwe :lol:
Last edited by ukoenig on Sun Oct 14, 2012 10:43 pm, edited 1 time in total.
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.
User avatar
ukoenig
 
Posts: 4043
Joined: Wed Dec 19, 2007 6:40 pm
Location: Germany

Re: Possible to add SubTitels to a Report ?

Postby ADutheil » Sun Oct 14, 2012 10:43 pm

Hi Uwe,

Did you try this?

Code: Select all  Expand view
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: Select all  Expand view

oReport:bStartgroup := { || oReport:Say( nCol, "Subtitle Products  " +  oReport:aGroups[ 1 ]:cValue ) }


Group larger than column is not a problem.
Image

Uploaded with ImageShack.us
Regards,

André Dutheil
FWH 13.04 + HB 3.2 + MSVS 10
ADutheil
 
Posts: 368
Joined: Sun May 31, 2009 6:25 pm
Location: Salvador - Bahia - Brazil

Re: Possible to add SubTitels to a Report ?

Postby ukoenig » 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.
User avatar
ukoenig
 
Posts: 4043
Joined: Wed Dec 19, 2007 6:40 pm
Location: Germany

Re: Possible to add SubTitels to a Report ?

Postby FranciscoA » Tue Oct 16, 2012 3: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: Select all  Expand view
GROUP ON field->Seccion HEADER "GROUP HEADER"  FOOTER "  " FONT 5

Best Regards.
Francisco J. Alegría P.
Chinandega, Nicaragua.

Fwxh-MySql-TMySql
User avatar
FranciscoA
 
Posts: 2110
Joined: Fri Jul 18, 2008 1:24 am
Location: Chinandega, Nicaragua, C.A.

Re: Possible to add SubTitels to a Report ?

Postby ukoenig » Tue Oct 16, 2012 8: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 :lol:
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.
User avatar
ukoenig
 
Posts: 4043
Joined: Wed Dec 19, 2007 6:40 pm
Location: Germany


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 81 guests