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.

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

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: 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 Go to previous message
Littlefoot
Messages: 21807
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 07:14:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.