OraFAQ Forum: Reports & Discoverer » How to print only selected columns?

Home » Developer & Programmer » Reports & Discoverer » How to print only selected columns?

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

How to print only selected columns? [message #177486]

Wed, 14 June 2006 23:54

manyal
Messages: 84
Registered: March 2005

Member

Dear Friends,

I am using report 6i to generate reports my problem is this suppose one report file generate report like below.

Employee no Name Desg Date of Birth

but some time i do need only 2 or 3 columns of the above report not all and i don't want to build separate report in this circumstance then what i should do????

Manyal

Report message to a moderator

Re: How to print only selected columns? [message #177505 is a reply to message #177486]

Thu, 15 June 2006 02:43

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You could create a parameter which would "select" version you'd like to run at the moment.

Write a Forma Trigger for all columns (and their headings), for example

BEGIN
  IF :p_what_to_print = 1 THEN
     RETURN (TRUE);
  END IF;
  RETURN (FALSE);
END;

Also, you might set Horizontal Elasticity to "Variable" (instead of "Fixed") to make the output look nicer.

Report message to a moderator

Re: How to print only selected columns? [message #177511 is a reply to message #177505]

Thu, 15 June 2006 04:09

manyal
Messages: 84
Registered: March 2005

Member

Dear Little foot,

Great!!!!!!!!!!!!!
it works!!!!!
Thanks u Very Much

Manyal

Report message to a moderator

Previous Topic:	error "REP-1202: ORACLE logon not specified"
Next Topic:	generate report as per my reqirement in report 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 22:46:00 CST 2024