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

./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..
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: 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..?
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: 20895
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'
Previous Topic: Group, Sort, Distinct????
Next Topic: Exporting Db tables to file and Import from Report Builder
Goto Forum:
  


Current Time: Tue Dec 06 00:20:51 CST 2016

Total time taken to generate the page: 0.12335 seconds