[CLOSED] table fields title

November 08, 2017, 10:52 AM

Badr.A

Hello!
I'm looking to build a table that has all fields sorted vertically and grouping some fields under one title, how is it going to group some fields in one title?
the report has to look like one group of fields under one title followed by an other group of fields in a different title, but all groups are sorted above each other (vertically)

this is the code for my fields:
TABLE FILE CALL_CENTER/CALL_STATS
SUM
CALL_STATS.CALL_STATS.CRM_IN_PERSON_CALL WITHIN TABLE WITHIN CALL_STATS.CALL_STATS.Month AS 'In Person' OVER
CALL_STATS.CALL_STATS.CRM_EMAIL_REQUESTS WITHIN TABLE WITHIN CALL_STATS.CALL_STATS.Month AS 'Email' OVER
CALL_STATS.CALL_STATS.CRM_ONLINE_REQUESTS WITHIN TABLE WITHIN CALL_STATS.CALL_STATS.Month AS 'Online'
ACROSS CALL_STATS.CALL_STATS.Month

This message has been edited. Last edited by: Badr.A,

November 08, 2017, 11:32 AM

MartinY

Not sure to understand what you are requesting Badr

It's always a good idea to include a output sample format of what you are looking for.

As already mentioned, remember to ALWAYS use the tag code (last icon on the ribbon) when including code sample or output sample

</>

Sample of "Output sample format"

     Group 1      Group 2
     ------------ ------------
     abc  def ghj abc  def ghj
     ---  --- --- ---  --- ---
123    x    y   z   r    t   s
456    k    l   m   u    v   w

November 08, 2017, 11:37 AM

FP Mod Chuck

Hi Badr.A

In your example I see you have 3 fields grouped together with the OVER syntax but the labels must be displaying to the left of the data. Are these the 3 fields that you want a single title above them. I don't see a second group of fields in your example. Do you want a title for the Month field going across. Please clarify.

November 08, 2017, 11:43 AM

Badr.A

thank you Martin:
something like this:
<
Group 1 Title
--------------
Field 1
Field 2
Field 3

Group 2 Title
-------------
Field 4
Field 5
Field 6 />

my question how to make the group title

thank you!

quote:
Originally posted by MartinY:
Not sure to understand what you are requesting Badr

It's always a good idea to include a output sample format of what you are looking for.

As already mentioned, remember to ALWAYS use the tag code (last icon on the ribbon) when including code sample or output sample
</>

Sample of "Output sample format"
     Group 1      Group 2
     ------------ ------------
     abc  def ghj abc  def ghj
     ---  --- --- ---  --- ---
123    x    y   z   r    t   s
456    k    l   m   u    v   w

November 08, 2017, 12:01 PM

MartinY

Badr,

You need to use the code tag button on the ribbon.
The button look like the following, then place your code and sample between the two tags that will be added to you post:

</>

The resulting code tag will be as follow

[code]
TABLE FILE CAR
SUM SEATS OVER
    RETAIL_COST OVER
	DEALER_COST
BY COUNTRY NOPRINT
ON COUNTRY SUBHEAD
"<COUNTRY"
""
ON COUNTRY SUBFOOT
"this is the subfoot by country"
END

[/code]

November 08, 2017, 01:14 PM

Badr.A

Yes I want to give a title to these three fields, then I will add an other group fields with a title below them!

thank you

quote:
Originally posted by Chuck Wolff:
Hi Badr.A

In your example I see you have 3 fields grouped together with the OVER syntax but the labels must be displaying to the left of the data. Are these the 3 fields that you want a single title above them. I don't see a second group of fields in your example. Do you want a title for the Month field going across. Please clarify.

November 08, 2017, 02:08 PM

FP Mod Chuck

Badr.A

I am not aware of a way to display the data as you are wanting to stack them. You can put the two groupings side by side with the use of OVER and use the HEADING or SUBHEADING to display to column titles you want.

Something like this...


TABLE FILE CAR
SUM 
     CAR.BODY.DEALER_COST AS ''
     CAR.BODY.RETAIL_COST AS '' OVER 
     CAR.BODY.SALES AS ''
     CAR.BODY.SEATS AS ''
BY  LOWEST CAR.ORIGIN.COUNTRY
ON TABLE SUBHEAD
" <+0>Group 1<+0>Group 2<+0> <+0> "
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
TYPE=TABHEADING,
     HEADALIGN=BODY,
$
TYPE=TABHEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     COLSPAN=1,
     JUSTIFY=LEFT,
$
TYPE=TABHEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=2,
     COLSPAN=1,
     JUSTIFY=LEFT,
$
TYPE=TABHEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=3,
     COLSPAN=1,
     JUSTIFY=LEFT,
$
TYPE=TABHEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=4,
     COLSPAN=1,
     JUSTIFY=LEFT,
$
TYPE=TABHEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=5,
     COLSPAN=1,
     JUSTIFY=LEFT,
$
ENDSTYLE
END

November 08, 2017, 02:27 PM

MartinY

quote:

Not to hijack this thread

This is exactly what you're doing...

Not related to this thread, please open another one and delete that post from this one. You're creating confusion for future research.

November 08, 2017, 03:25 PM

Doug

Thank you Martin for :

quote:
RyanIPG13:
This is exactly what you're doing...

November 08, 2017, 04:27 PM

Badr.A

[QUOTE]Originally posted by Chuck Wolff:
Badr.A

I am not aware of a way to display the data as you are wanting to stack them. You can put the two groupings side by side with the use of OVER and use the HEADING or SUBHEADING to display to column titles you want.

thank you!