OraFAQ Forum: Reports & Discoverer » Dont wants to show certain matrix columns

Home » Developer & Programmer » Reports & Discoverer » Dont wants to show certain matrix columns (oracle 10g,reports builder 6i)

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

Dont wants to show certain matrix columns [message #430022]

Sat, 07 November 2009 00:20

seyed456
Messages: 220
Registered: May 2008
Location: south india .

Senior Member

Hello all,

Herewith am attaching the image which displays you the outlets and description of the products.

/forum/fa/6977/0/

In that i dont wants to show certain product 1.5L in the report.

What i have tried so far ?..

When i was trying to use format trigger option for the particular column 1.5L , it was immediately selecting the other columns since i have written group by description in my query.

Can you please tell me how not to display that certain column in my report.

Thanks in advance..
Seyed..

Attachment: Dont wants to show 1.5L.jpg
(Size: 171.76KB, Downloaded 1529 times)

Report message to a moderator

Re: Dont wants to show certain matrix columns [message #430024 is a reply to message #430022]

Sat, 07 November 2009 00:58

javed.khan
Messages: 340
Registered: November 2006
Location: Banglore

Senior Member

Quote:

it was immediately selecting the other columns

I think if the column you are not selecting all it will go for the immediate next column...why you dont want the report to do so..?

Report message to a moderator

Re: Dont wants to show certain matrix columns [message #430033 is a reply to message #430022]

Sat, 07 November 2009 01:55

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

Senior Member
Account Moderator

If it is only that "1.5 Litre", put it into the WHERE clause, such as

SELECT ...
FROM your_table
WHERE some_conditions
  AND this_column <> '1.5 Litre'

Report message to a moderator

Previous Topic:	Group, Sort, Distinct????
Next Topic:	Exporting Db tables to file and Import from Report Builder

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 01:49:12 CST 2024