Hi All,

Is there a round about way we can have a DEFINE FIELD as part of the TITLE...

Something of this sort...

 DEFINE FILE CAR
CONTRYNAME/A20 = COUNTRY;
END

TABLE FILE CAR
PRINT
CAR AS <CONTRYNAME
BY COUNTRY NOPRINT
ON COUNTRY PAGE-BREAK
END  

I cant go for Subhead because, My Client wants this Exactly in the TITLE Area. Also While Using SUBHEAD OR HEADING, You can't bring the exact Grid Style as that of TITLE...



I need to fill on the Empty Boxes with DEFINE Field that changes on a BY FIELD.



Thanks is Advance...

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

Can't do that, I'm afraid.
Only way is to create as many TABLE's as there are Countries (in this case) and to put it in a compound document...

Hi Gamp,

Thanks for the reply.

Compound Report will be bit complicated to resolve this cosmetic kind of issue.

Also, I need this to be done all 3 formats PDF,EXCEL and HTML.

Am trying so many things... But nothing works out as solution...

Hi Ramkumar,

Is this resolved? If not, you may want to contact Information Builders' Customer Support Services and open a case for further assistance. You may call at 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry

Maybe something like this ??


TABLE FILE CAR
BY COUNTRY
ON TABLE HOLD AS COUNTRIES FORMAT ALPHA
ON TABLE SET HOLDLIST PRINTONLY
END
-RUN
-SET &ROWS = &LINES;

-REPEAT :LB_READ FOR &I FROM 1 TO &ROWS;
-READ COUNTRIES, &CNTRY&I.EVAL
-:LB_READ
-RUN


-REPEAT :LB_REPORT FOR &I FROM 1 TO &ROWS;
TABLE FILE CAR
ON TABLE SUBFOOT
" "
HEADING
"Country: &CNTRY&I.EVAL "
" "
SUM DEALER_COST
BY SEATS
ACROSS CAR AS ''
WHERE COUNTRY EQ '&CNTRY&I.EVAL' ;
ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE NOPAGE
END
-RUN
-:LB_REPORT