OraFAQ Forum: Reports & Discoverer » Move up field2, when field1 is blank and field3 up, if field2 is blank

Home » Developer & Programmer » Reports & Discoverer » Move up field2, when field1 is blank and field3 up, if field2 is blank (Report 6i and DB10g.)

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

Move up field2, when field1 is blank and field3 up, if field2 is blank [message #448308]

Mon, 22 March 2010 12:29

ferozkhan
Messages: 3
Registered: March 2010

Junior Member

hello seniors..!

i have a repeating frame and under that i have 3 fields one above the other.

Field1
Field2
Field3

what i want is, if theres is no data return for Field1, then Field2 and Field3 should be moved up,
and similarly, if theres is no data return for Field2, then Field3 should take place of Field2.

the ultimate goal is , theres should not be any blank row shown.

Kindly suggest please.

Report message to a moderator

Re: Move up field2, when field1 is blank and field3 up, if field2 is blank [message #448335 is a reply to message #448308]

Mon, 22 March 2010 15:28

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

Senior Member
Account Moderator

Try to fix that in query itself, using NVL function:

select nvl(field1, field2) f1,
       nvl(field2, field3) f2,
       field3 f3
from some_table
where ...

Report message to a moderator

Re: Move up field2, when field1 is blank and field3 up, if field2 is blank [message #448414 is a reply to message #448335]

Tue, 23 March 2010 04:49

cookiemonster
Messages: 13959
Registered: September 2008
Location: Rainy Manchester

Senior Member

Littlefoot wrote on Mon, 22 March 2010 15:28

Try to fix that in query itself, using NVL function:
select nvl(field1, field2) f1,
       nvl(field2, field3) f2,
       field3 f3
from some_table
where ...

Huh?

How's that going to work? All that's going to do is, if field1 is null, give you field2 twice then field3.

Report message to a moderator

Re: Move up field2, when field1 is blank and field3 up, if field2 is blank [message #448415 is a reply to message #448308]

Tue, 23 March 2010 04:52

cookiemonster
Messages: 13959
Registered: September 2008
Location: Rainy Manchester

Senior Member

Try setting the items vertical elasticity to variable along with their frame.

Report message to a moderator

Re: Move up field2, when field1 is blank and field3 up, if field2 is blank [message #448454 is a reply to message #448414]

Tue, 23 March 2010 08:27

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

Senior Member
Account Moderator

cookiemonster

Huh?
How's that going to work? All that's going to do is, if field1 is null, give you field2 twice then field3.

True. A really stupid answer. Sorry.

Report message to a moderator

Re: Move up field2, when field1 is blank and field3 up, if field2 is blank [message #448455 is a reply to message #448308]

Tue, 23 March 2010 08:29

cookiemonster
Messages: 13959
Registered: September 2008
Location: Rainy Manchester

Senior Member

Don't worry - happens to all of us from time to time.

Report message to a moderator

Re: Move up field2, when field1 is blank and field3 up, if field2 is blank [message #448483 is a reply to message #448414]

Tue, 23 March 2010 12:06

ferozkhan
Messages: 3
Registered: March 2010

Junior Member

Thank you for your reply..

but still Mr. Littlefoot, by doing through SQL,
the Fields created on the report Layout, will still be blank
for any of the empty value.

and i dont want any unnecessary blank row.

Mr. CookieMonster, i tried to change the vertical elasticity, but still, Fields didnt moved UP.

i leave for your reference the screen shot of my reports (rdf & preveiwer) .

Please refer attached file "RepPicLink.txt"

if u can get an idea about my problem, then please do post me the solution.

Attachment: RepPicLink.txt
(Size: 0.19KB, Downloaded 1567 times)

Report message to a moderator

Re: Move up field2, when field1 is blank and field3 up, if field2 is blank [message #448487 is a reply to message #448308]

Tue, 23 March 2010 12:20

cookiemonster
Messages: 13959
Registered: September 2008
Location: Rainy Manchester

Senior Member

The attached file appears to be empty, and I'm not sure why it's a .txt, it should be a .jpg

Report message to a moderator

Re: Move up field2, when field1 is blank and field3 up, if field2 is blank [message #448488 is a reply to message #448487]

Tue, 23 March 2010 12:33

ferozkhan
Messages: 3
Registered: March 2010

Junior Member

please add "http colon 2 front slahes" before all the following links;
- farm5.static.flickr.com/4048/4456207705_c04f233673_o.jpg
- farm3.static.flickr.com/2785/4457800136_9a204f6711_o.jpg
- farm5.static.flickr.com/4058/4456207709_eb56922642_o.jpg

Report message to a moderator

Re: Move up field2, when field1 is blank and field3 up, if field2 is blank [message #448512 is a reply to message #448488]

Tue, 23 March 2010 21:58

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Why can`t you post your screen shot here? As an attachment?

Sriram Smile

Report message to a moderator

Re: Move up field2, when field1 is blank and field3 up, if field2 is blank [message #448569 is a reply to message #448512]

Wed, 24 March 2010 02:01

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

Senior Member
Account Moderator

Because users with too few posts aren't allowed to do that (in order to prevent spam).

Report message to a moderator

Re: Move up field2, when field1 is blank and field3 up, if field2 is blank [message #448572 is a reply to message #448569]

Wed, 24 March 2010 02:10

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

Senior Member
Account Moderator

The solution, after all, seems to be in creating a format trigger (for all of these fields) which would look like this (example for the first field):

return (:field1 is not null);

It would result in not displaying that field at all, if it is empty.

Report message to a moderator

Re: Move up field2, when field1 is blank and field3 up, if field2 is blank [message #448623 is a reply to message #448569]

Wed, 24 March 2010 06:56

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Littlefoot wrote on Wed, 24 March 2010 12:31

Because users with too few posts aren't allowed to do that (in order to prevent spam).

Ohh I forgot the 6 post restriction..

Thank you

sriram Smile

Report message to a moderator

Re: Move up field2, when field1 is blank and field3 up, if field2 is blank [message #448660 is a reply to message #448623]

Wed, 24 March 2010 09:55

sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad

Senior Member

I think the best solution for this scenario is to use the "Anchor" tool.

Just select the Anchor tool from the tool pallette and drag and drop it from f3 to f2 and again f2 to f1.

Report message to a moderator

Previous Topic:	alternate of a button in oracle 10g reports
Next Topic:	Share Workbook : Table in EUL_US

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 10:44:20 CST 2024