Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

hide columns having null values 1

Status
Not open for further replies.

chochoo

Programmer
Aug 24, 2003
33
PK
hi gurus!
i've a report having 3 columns "name","plus","minus"
each name may have some value in either "plus" or in "minus", a name could n't have values in both "plus" and "minus" in a same time. there is also one possiblity that any name can have null in both "plus" and "minus". if this condition is true , is this possible to hide the complete row from the report(not from the database)? "name" is the database column and "plus" and "minus" are formula columns. looking for an urgent reply
thankx in advance
 
In the Object Navigator select the repeating frame where name is displayed, press F4, go to the Format Trigger and between the 'begin' and 'end' type the following:
Code:
if :plus is null and :minus is null then
	return false;
else
	return true;
end if;
 
hi thanks nagornyi for your solution, its working but i've also put the trigger for plus and mins to hide the complete row
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top