CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> CodeCharge Studio -> ASP

 Reports: showing a column field depending if it has data or not

Print topic Send  topic

Author Message
Chris__T


Posts: 339
Posted: 05/04/2009, 12:37 PM

I have a report with several columns. Two columns are for an Applicant Firm Name, and a Contractor Firm Name. The report only needs one of them, but the firm name could come from either one or both. I'm trying to set something up so when it loads the report, it checks to see if the labels have data in them....

(pseudo-code)
IF Applicant_Firm_Name is empty then only show Contractor_Firm_Name
else
show Applicant_Firm_Name

But I know this won't work correctly since the report will have several rows of records. So it has to do this check for every instance of a record in the report

Any ideas?
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.