OraFAQ Forum: Reports & Discoverer » Matrix Report

Home » Developer & Programmer » Reports & Discoverer » Matrix Report (Oracle dev 10g R2,Windows)

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

Matrix Report [message #487051]

Wed, 22 December 2010 04:14

mahmud732
Messages: 82
Registered: October 2009
Location: Dhaka

Member

Dear all,

I am using oracle Dev 10g R2 in windows Xp. I have a matrix report and it will produce result correctly as the attachment1. Now I want to display this report as a same format. I would like to display 0 for those that does not exist in the query.

Is this possible? Please help me anyone.

Regards

Mahmud /forum/fa/8549/0/

/forum/fa/8549/0/

Attachment: untitled.JPG
(Size: 173.87KB, Downloaded 1599 times)

[Updated on: Wed, 22 December 2010 04:39]

Report message to a moderator

Re: Matrix Report [message #487055 is a reply to message #487051]

Wed, 22 December 2010 04:51

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

Senior Member
Account Moderator

Quote:

I would like to display 0 for those that does not exist in the query.

Those what? What does not exist? Months? If they don't exist, you'd have to create them (search the Forum for "row generator" techniques).

Report message to a moderator

Re: Matrix Report [message #487060 is a reply to message #487055]

Wed, 22 December 2010 05:17

mahmud732
Messages: 82
Registered: October 2009
Location: Dhaka

Member

Dear Littlefoot

Yeah months with respective business does not exist.

Report message to a moderator

Previous Topic:	SET_HYPERLINK
Next Topic:	report in excel format

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 21:33:55 CDT 2024