OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » Change Font size in Tabular Form

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Change Font size in Tabular Form (Apex 3.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Change Font size in Tabular Form [message #320413]

Thu, 15 May 2008 01:27

benseer
Messages: 22
Registered: October 2005
Location: Bangalore

Junior Member

Hi,

How can I change the Font Size, color of particualr columns (or for entire column) in Tabular form.

Benseer

Report message to a moderator

Re: Change Font size in Tabular Form [message #321425 is a reply to message #320413]

Tue, 20 May 2008 04:21

dr.s.raghunathan
Messages: 540
Registered: February 2008

Senior Member

did you try in cell attributes giving fontsize=12

Report message to a moderator

Re: Change Font size in Tabular Form [message #321446 is a reply to message #321425]

Tue, 20 May 2008 05:17

benseer
Messages: 22
Registered: October 2005
Location: Bangalore

Junior Member

Hi Raghunath,

It worked fine, but is there anyway in a SQL Report where I can set ColumnHeader Name first letter as small letter ?

Report message to a moderator

Re: Change Font size in Tabular Form [message #321503 is a reply to message #321446]

Tue, 20 May 2008 09:05

dr.s.raghunathan
Messages: 540
Registered: February 2008

Senior Member

hope you require another type opposite to proper function
am i right.. yes it can be done.. wait for some more time...
i will test and tell

Report message to a moderator

Re: Change Font size in Tabular Form [message #322104 is a reply to message #321503]

Thu, 22 May 2008 09:09

benseer
Messages: 22
Registered: October 2005
Location: Bangalore

Junior Member

Hi Raghunath,

Any luck ?

I have tried Column,Custom & PL/SQL (Please check the below link) method to make it initSmall,but not satisfying the requirement Sad

http://www.oracle.com/technology/pub/articles/bobrowski-saas.html

Regards,
Benseer

Report message to a moderator

Re: Change Font size in Tabular Form [message #322181 is a reply to message #322104]

Thu, 22 May 2008 13:01

andrew again
Messages: 2577
Registered: March 2000

Senior Member

For a regular SQL report (in 3.0) in a reports region, just change from the Region Definition tab to the Report Attributes tab and replace each default column heading with whatever you want.

Report message to a moderator

initSmall for a column header [message #323076 is a reply to message #322181]

Tue, 27 May 2008 04:30

benseer
Messages: 22
Registered: October 2005
Location: Bangalore

Junior Member

Hi Andrew,

Strangly all method not working for me..

I have tried Column,Custom & PL/SQL method to make it initSmall. The header is a part of Tabular form built on a direct SQL query

like

Select empno "Emp ID", ebuy "eBuy",f_getPercent(sal) "Hike" from emp;

Here "eBuy" is diplaying as EBuy..

Report message to a moderator

Re: initSmall for a column header [message #323529 is a reply to message #323076]

Wed, 28 May 2008 12:23

andrew again
Messages: 2577
Registered: March 2000

Senior Member

Try changing the column heading to something like XYZ to see what happens. Make sure you save the change...

Report message to a moderator

Re: initSmall for a column header [message #333202 is a reply to message #323529]

Thu, 10 July 2008 16:52

gungalagunga
Messages: 3
Registered: July 2008

Junior Member

Create a hidden variable, say P10_Col_1.
Then in an onload after header process, assign Co1_1 a value, like:

begin

:P10_Col_1 := 'mY Nam3';

end;

In the report definition, set the "custom" heading to &P10_COL_1.

That should do it.

Report message to a moderator

Previous Topic:	Decrypt PDF file
Next Topic:	Formatting Queries to Print

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 07 16:45:58 CST 2025