Hide Row based on a column value

CodeCharge Studio

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

Hide Row based on a column value

Author

Message

bhaneef

Posts: 4

Posted: 03/11/2010, 11:12 AM

I want to hide the entire row if value of label7 is empty. Kindly help me.

Here is the source code of my row.

**********************************************

<tr class="Row">
<th scope="row">{Label7}</th>

<td>{field7}</td>
</tr>

***********************************************
_________________
People May not Believe what you say .. They will always believe what you do ...

TheunisP

Posts: 342

Posted: 03/12/2010, 12:25 AM

put the entire row in a normal panel, in the before row shwo event you can then check the value of the label and hide or show the row depending on value e.g. your table/grid name is gridSample

so in the before show event

if gridSample.Label7.value = "" then
pnlSample.visible=false
else
pnlSample.visible=true
end if

bhaneef

Posts: 4

Posted: 03/12/2010, 1:48 AM

Thanks.
It worked for me.
_________________
People May not Believe what you say .. They will always believe what you do ...

Vasiliy

Posts: 378

Posted: 03/12/2010, 7:52 AM

Another option is to add label7 value check to SQL WHERE clause:
WHERE (label7 IS NOT NULL) AND (label7 <> '')
_________________
Vasiliy

botham

Posts: 1

Posted: 03/30/2010, 2:29 AM

Quote Vasiliy:
Another option is to add label7 value check to SQL WHERE clause:
WHERE (label7 IS NOT NULL) AND (label7 <> '')

Thanks for providing this option. Its going to work and the first one is not working. I am greatly thankful to you for this act.

_________________
botham

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home | Search | Members | Register | Login