OraFAQ Forum: Reports & Discoverer » dispaly repeating frame of details with no master

Home » Developer & Programmer » Reports & Discoverer » dispaly repeating frame of details with no master

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

dispaly repeating frame of details with no master [message #614897]

Wed, 28 May 2014 08:01

hahaie
Messages: 194
Registered: May 2014

Senior Member

HELLO
IN REPORT BUILDER,IN MASTER DETAIL REPORT IF A MASTER DOES NOT DETAILS==>> In that case REPEATING FRAME OF DETIAL DO NOT SHOW.
HOW CAN DISPALY REPEATING FRAME OF DETAILS WITH VALUE NULL OR ZERO?
In other words,Require that repeating frame fixed till another fileds or repeating frame, It does not replace.
TANKS

[Updated on: Wed, 28 May 2014 08:06]

Report message to a moderator

Re: dispaly repeating frame of details with no master [message #614938 is a reply to message #614897]

Wed, 28 May 2014 23:12

hahaie
Messages: 194
Registered: May 2014

Senior Member

More details:in attachment files group 2 with no details but in group 2 value of record 2 wrong Alternative value of record 1...
Forgive me,
I do not know English well

Attachment: output2.JPG
(Size: 39.25KB, Downloaded 1860 times)

Report message to a moderator

Re: dispaly repeating frame of details with no master [message #614942 is a reply to message #614938]

Thu, 29 May 2014 00:43

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

Senior Member
Account Moderator

I'm not sure I understood what you want to do.

Here's an example based on Scott's schema. DEPTNO = 40 doesn't have any details (i.e. there are no employees who work in that department). So, what would you want to display instead of an empty line?

/forum/fa/11900/0/

As far as I'm concerned, the way Reports do it by default is perfectly OK. Why would you want to display (for example) CLARK under the department 40 when it is obvious that he doesn't work there?

Attachment: no_details.jpg
(Size: 26.44KB, Downloaded 3091 times)

Report message to a moderator

Re: dispaly repeating frame of details with no master [message #614947 is a reply to message #614897]

Thu, 29 May 2014 01:05

hahaie
Messages: 194
Registered: May 2014

Senior Member

I mean, what you say is,The same thing that is on your mind
but
in output2.jpg record 2 is of other query
but in group 2 record 2 alternative record 1.it is wrong.
Figure output3.jpg shows that everything is well
I want it output3.jpg Instead output2.jpg

Attachment: output3.JPG
(Size: 40.94KB, Downloaded 1819 times)

[Updated on: Thu, 29 May 2014 01:09]

Report message to a moderator

Re: dispaly repeating frame of details with no master [message #615052 is a reply to message #614947]

Thu, 29 May 2014 14:33

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

Senior Member
Account Moderator

I left that question, hoping that someone else will join the discussion. Noone did.

I'm sorry, but I still don't understand which values would you want to display if details don't exist ... Have a look at my screenshot and say, explicitly, what would be written under department 40 (which doesn't have any employees).

Once again: I still think that you are doing it wrong. Or, I can't understand what sense would something like that make.

Report message to a moderator

Previous Topic:	categorizing fileds of a query in data model
Next Topic:	Oracle report 10g Issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 18:12:29 CST 2025