[CLOSED] Field display

April 28, 2011, 10:35 AM

Enigma006

Hi

I am having problem with displaying (alignment) fields for 2 reports. I have 2 table requests in same fex. They are in this format

  
Present
F1     F3    F4
..     ..    ..
F1     F2    F3    F4
..     ..    ..    ..

Target
F1           F3    F4
..           ..    ..
F1     F2    F3    F4
..     ..    ..    ..

As of now I have fields as shown in present set. But I am trying to achieve like target set. I used WRAP, SQUEEZE, used a dummy field but couldn't get it correct. Can some one help me? I could get it right in a normal report but I need to fit these in a small frame which is typically in size of blackberry screen..:-p

Thanks
Appreciate your suggestions.

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

April 28, 2011, 11:34 AM

Francis Mariani

This is an HTML report? Try using ON TABLE HTMLCSS ON.

How about using the CAR file to provide us an example fex?

April 28, 2011, 11:37 AM

FrankDutch

is this HTML output
or PDF

can you post a example code based on the CAR database

April 28, 2011, 11:38 AM

FrankDutch

Francis...

what do they same about great minds?

April 28, 2011, 11:51 AM

Francis Mariani

The Netherlands is three minutes behind Canada!

April 28, 2011, 11:55 AM

Enigma006

this is html report. I am using HTMLCSS ON

April 28, 2011, 12:11 PM

Enigma006

  

TABLE FILE CAR
PRINT
	CAR
	MPG
	SEATS
WHERE RECORDLIMIT EQ 3;
END

TABLE FILE CAR
PRINT
	CAR
	COUNTRY
	MPG
	SEATS
WHERE RECORDLIMIT EQ 3;
END

I am trying to get MPG and SEATS align with each other which means on TOP of COUNTRY should be blank in 1st report request.

Thanks

April 28, 2011, 12:46 PM

Francis Mariani

For HTML reports, I like controlling things with CSS. Here's an example:

-* File fmfpenigma1.fex

SET PAGE=NOLEAD
-RUN

TABLE FILE CAR
PRINT
CAR
COMPUTE DUMMY/A12 = ''; AS ''
MPG
SEATS
WHERE RECORDLIMIT EQ 3;
ON TABLE HOLD AS H001 FORMAT HTMTABLE
ON TABLE SET STYLE *
TYPE=TITLE, CLASS=ColumnTitle, $
TYPE=REPORT, COLUMN=CAR    , CLASS=RepColCar    , $
TYPE=REPORT, COLUMN=DUMMY  , CLASS=RepColCountry, $
TYPE=REPORT, COLUMN=MPG    , CLASS=RepColMPG    , $
TYPE=REPORT, COLUMN=SEATS  , CLASS=RepColSeats  , $
ENDSTYLE
END
-RUN

TABLE FILE CAR
PRINT
CAR
COUNTRY
MPG
SEATS
WHERE RECORDLIMIT EQ 3;
ON TABLE HOLD AS H002 FORMAT HTMTABLE
ON TABLE SET STYLE *
TYPE=TITLE, CLASS=ColumnTitle, $
TYPE=REPORT, COLUMN=CAR    , CLASS=RepColCar    , $
TYPE=REPORT, COLUMN=COUNTRY, CLASS=RepColCountry, $
TYPE=REPORT, COLUMN=MPG    , CLASS=RepColMPG    , $
TYPE=REPORT, COLUMN=SEATS  , CLASS=RepColSeats  , $
ENDSTYLE
END
-RUN

-HTMLFORM BEGIN
<html>

<head>
<style type="text/css">
/* Reset global properties */
*
{
margin: 0; padding: 0; outline: 0;
}

html, body, div, p, table, td, form, img, h1, h2, h3, h4, h5, h6, input, select, textarea, fieldset, label
{
font-family: "Arial", sans-serif; font-size: 12px;
}

body
{
margin: 4px;
background-color: white;
color: black;
}

table
{
border-collapse: collapse;
}

td
{
/*font-family: Arial, sans-serif; font-size: 8pt;*/
vertical-align: top; padding-left: 2px; padding-right: 2px;
}

.ColumnTitle   { font-weight: bold; color: navy; }
.RepColCar     { width: 80px; }
.RepColCountry { width: 80px; }
.RepColMPG     { width: 40px; }
.RepColSeats   { width: 50px; }
</style>
</head>

<body>
!IBI.FIL.H001;
!IBI.FIL.H002;
</body>
</html>
-HTMLFORM END

You get responses with examples of easier techniques...

	*Frank*
	prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7