Members   Search   Help    Register    Login   Home
Home » Developer & Programmer » Reports & Discoverer » Dont wants to show certain matrix columns (oracle 10g,reports builder 6i)
Dont wants to show certain matrix columns [message #430022] Sat, 07 November 2009 00:20 Go to next message
seyed456
Messages: 213
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.

./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..

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 Go to previous messageGo to next message
javed.khan
Messages: 205
Registered: November 2006
Location: Mumbai
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 Go to previous message
Littlefoot
Messages: 9230
Registered: June 2005
Location: Croatia, Europe
Senior Member
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:Drill down report in Oracle discoverer
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 28 18:42:10 CST 2009

Total time taken to generate the page: 0.31552 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.