Home » Developer & Programmer » Reports & Discoverer » dispaly repeating frame of details with no master
dispaly repeating frame of details with no master [message #614897] Wed, 28 May 2014 08:01 Go to next message
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 Go to previous messageGo to next message
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 402 times)
Re: dispaly repeating frame of details with no master [message #614942 is a reply to message #614938] Thu, 29 May 2014 00:43 Go to previous messageGo to next message
Littlefoot
Messages: 21594
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?
Re: dispaly repeating frame of details with no master [message #614947 is a reply to message #614897] Thu, 29 May 2014 01:05 Go to previous messageGo to next message
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 393 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 Go to previous message
Littlefoot
Messages: 21594
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.
Previous Topic: categorizing fileds of a query in data model
Next Topic: Oracle report 10g Issue
Goto Forum:
  


Current Time: Thu Sep 24 03:11:50 CDT 2020