Home » Developer & Programmer » Reports & Discoverer » Move up field2, when field1 is blank and field3 up, if field2 is blank (Report 6i and DB10g.)
Move up field2, when field1 is blank and field3 up, if field2 is blank [message #448308] Mon, 22 March 2010 12:29 Go to next message
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.
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 Go to previous messageGo to next message
Littlefoot
Messages: 20900
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 ...
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 Go to previous messageGo to next message
cookiemonster
Messages: 12415
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.
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 Go to previous messageGo to next message
cookiemonster
Messages: 12415
Registered: September 2008
Location: Rainy Manchester
Senior Member
Try setting the items vertical elasticity to variable along with their frame.
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 Go to previous messageGo to next message
Littlefoot
Messages: 20900
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.
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 Go to previous messageGo to next message
cookiemonster
Messages: 12415
Registered: September 2008
Location: Rainy Manchester
Senior Member
Don't worry - happens to all of us from time to time.
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 Go to previous messageGo to next message
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.

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 Go to previous messageGo to next message
cookiemonster
Messages: 12415
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Why can`t you post your screen shot here? As an attachment?

Sriram Smile
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 Go to previous messageGo to next message
Littlefoot
Messages: 20900
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).
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 Go to previous messageGo to next message
Littlefoot
Messages: 20900
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.
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 Go to previous messageGo to next message
ramoradba
Messages: 2454
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
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 Go to previous message
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.
Previous Topic: alternate of a button in oracle 10g reports
Next Topic: Share Workbook : Table in EUL_US
Goto Forum:
  


Current Time: Wed Dec 07 23:58:50 CST 2016

Total time taken to generate the page: 0.14288 seconds