Hi all,

TABLE FILE CAR
HEADING
"All"
PRINT
MODEL
BY COUNTRY
BY CAR
ON COUNTRY SUBFOOT
"Type of Cars = END

I am using above piece of code to generate subfoot every time the value of country changes and it should show the Type of Cars in each country. But, every time it is showing me the value 1.
Please suggest,where i am going wrong.
Thanks in advance.

This message has been edited. Last edited by: Kerry,

WF 8.1.04,Windows 7,
DataBase: Oracle 11g,Output :Excel,PDF,HTML

Shankar,

Please put your fex between CODE tags (the right-most icon on the ribbon).

Here is the code,

quote:

CODE

TABLE FILE CAR
HEADING
"All"
PRINT
MODEL
BY COUNTRY
BY CAR
ON COUNTRY SUBFOOT
"Type of Cars = <CNT.CAR"
END
  

Thanks.

TABLE FILE CAR
HEADING
"All"
SUM CNT.CAR NOPRINT
BY COUNTRY
ON COUNTRY SUBFOOT
"Type of Cars = <CNT.CAR"
PRINT
MODEL
BY COUNTRY
BY CAR
END

In order for the SUBFOOT to display the correct COUNT, it must be placed next to the verb that calculates the COUNT.

Try this code instead.

DEFINE FILE CAR
CAR_COUNT/I1=1;
END
TABLE FILE CAR
HEADING
"All"
PRINT
MODEL
BY COUNTRY
BY CAR
ON COUNTRY SUBFOOT
"Type of Cars = END

WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit

Sorry it truncated.
DEFINE FILE CAR
CAR_COUNT/I1=1;
END
TABLE FILE CAR
HEADING
"All"
PRINT
MODEL
BY COUNTRY
BY CAR
ON COUNTRY SUBFOOT
"Type of Cars = END

WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit

The last line is
/*
"Type of Cars = /*

WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit

I am trying to print this
"Type of Cars =

WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit

Danny,
It is showing me the number of rows of CAR column.What I want is distinct number of Cars for a country.I tried "Type of Cars = Is there any way to calculate the distinct no. of cars in subfoot section?

Thanks.

WF 8.1.04,Windows 7,
DataBase: Oracle 11g,Output :Excel,PDF,HTML

Danny,
It is showing me the number of rows of CAR column.What I want is distinct number of Cars for a country.I tried the below code but it shows error:FOC406) THE FIELDNAME IS NOT RECOGNIZED: DST.CAR

quote:

Code

TABLE FILE CAR
HEADING
"All"
SUM CNT.CAR NOPRINT
BY COUNTRY
ON COUNTRY SUBFOOT
"Type of Cars = <CNT.DST.CAR"
PRINT
MODEL
BY COUNTRY
BY CAR
END  

Is there any way to calculate the distinct no. of cars in subfoot section?

Thanks.

Shankar,

If you run my fex you get:

  
1 PAGE     1
  
  All
  COUNTRY     CAR               MODEL                                           
  -------     ---               -----                                           
  ENGLAND     JAGUAR            V12XKE AUTO             
                                XJ12L AUTO              
              JENSEN            INTERCEPTOR III         
              TRIUMPH           TR7                     
  Type of Cars =     3
  FRANCE      PEUGEOT           504 4 DOOR              
  Type of Cars =     1
  ITALY       ALFA ROMEO        2000 4 DOOR BERLINA     
                                2000 GT VELOCE          
                                2000 SPIDER VELOCE      
              MASERATI          DORA 2 DOOR             
  Type of Cars =     2
  JAPAN       DATSUN            B210 2 DOOR AUTO        
              TOYOTA            COROLLA 4 DOOR DIX AUTO 
  Type of Cars =     2
  W GERMANY   AUDI              100 LS 2 DOOR AUTO      
              BMW               2002 2 DOOR             
                                2002 2 DOOR AUTO        
                                3.0 SI 4 DOOR           
                                3.0 SI 4 DOOR AUTO      
                                530I 4 DOOR             
                                530I 4 DOOR AUTO        
  Type of Cars =     2

See the number of cars...

Thanks Danny.I got the solution.

Regards.