CodeCharge Studio
search Register Login  

Visual Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> ASP

 How to not display field that does not have data inside?

Print topic Send  topic

Author Message
farhana_aini

Posts: 1
Posted: 09/09/2008, 6:33 PM

Hi all,

I would like to know how to not display field that does not have data inside it?
For example,

Name Age Item1 Item2 Item3
Ali 45 book
John 55 pencil

when i use "select" query, it will display all column... i dont want to display column item2 and item3 because it does not have any data in it...

please help! :(
_________________
FARHANA AINI
View profile  Send private message
GaryDN

Posts: 34
Posted: 09/09/2008, 7:33 PM

look up Panels in the docs. I have not used them but it should do what you want.

Panel
Description
The panel component creates a container for settings that control the visibility of one, or several, components of HTML snippets in an application. For example, a panel can allow only management to view additional form fields and exclude the option for non-management personnel. The panel component is often used with the Hide-Show Component action, which can be assigned to a panel's Before Show event where you specify the condition of when the panel should be shown or hidden.

A panel component can contain any CodeCharge Studio components of a form that are supported by that form. For example, if a panel is added to a CodeCharge Studio form such as grid or record it can contain only form specific components (the Include Page cannot be placed inside the Panel). For a panel to work correctly, it is necessary that the panel does not contain structural elements of other components, such as component sections identified as blocks within the HTML. For example, when using a grid form, the Row and AltRow blocks of the grid are structural and therefore cannot be included into a panel.

View profile  Send private message
wkempees


Posts: 1679
Posted: 09/10/2008, 1:49 PM

When using GridBuilder, look closely to find "add panels to each column".
Then BeforeShowRow or BeforeShow hide a panel.
OR
Before show row, add Action "Hide-Show Component"
You can then simply choose the columns and
set the condition to reflect your required situation.

Walter

_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)

if you liked this info PAYPAL me: http://donate.consultair.eu
View profile  Send private message

Add new topic Subscribe to topic   


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


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.