Home » Developer & Programmer » Application Express & MOD_PLSQL » Change Font size in Tabular Form (Apex 3.1)
Change Font size in Tabular Form [message #320413] Thu, 15 May 2008 01:27 Go to next message
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
Re: Change Font size in Tabular Form [message #321425 is a reply to message #320413] Tue, 20 May 2008 04:21 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
did you try in cell attributes giving fontsize=12
Re: Change Font size in Tabular Form [message #321446 is a reply to message #321425] Tue, 20 May 2008 05:17 Go to previous messageGo to next message
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 ?
Re: Change Font size in Tabular Form [message #321503 is a reply to message #321446] Tue, 20 May 2008 09:05 Go to previous messageGo to next message
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
Re: Change Font size in Tabular Form [message #322104 is a reply to message #321503] Thu, 22 May 2008 09:09 Go to previous messageGo to next message
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

Re: Change Font size in Tabular Form [message #322181 is a reply to message #322104] Thu, 22 May 2008 13:01 Go to previous messageGo to next message
andrew again
Messages: 2574
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.
initSmall for a column header [message #323076 is a reply to message #322181] Tue, 27 May 2008 04:30 Go to previous messageGo to next message
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..
Re: initSmall for a column header [message #323529 is a reply to message #323076] Wed, 28 May 2008 12:23 Go to previous messageGo to next message
andrew again
Messages: 2574
Registered: March 2000
Senior Member
Try changing the column heading to something like XYZ to see what happens. Make sure you save the change...
Re: initSmall for a column header [message #333202 is a reply to message #323529] Thu, 10 July 2008 16:52 Go to previous message
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.
Previous Topic: Decrypt PDF file
Next Topic: Formatting Queries to Print
Goto Forum:
  


Current Time: Wed Jul 30 08:49:21 CDT 2014

Total time taken to generate the page: 0.07385 seconds